SQL Server performance counters not available

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

SQL Server performance counters not available

Author

Topic

sqlamit31
Starting Member

3 Posts

Posted - 2011-05-22 : 17:30:52

Hi Guys,

I am new to SQL Server. I am not able to see the SQL Server performance counters in performance monitor.I am running SQL Server on Windows 7.Not sure is it some permissions issue or something else.

Please help me how to resolve this.

Thanks
Amit

Amit

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-05-23 : 01:32:19

This might be caused by a Minimum install or not choosing Performance counters from a custom install
The correct way to rebuild the SQL server specific counters is to run the following command :
lodctr <input_app_performance-counter_ini_file>
lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"
lodctr is a program that loads performance counters and is associated with the Windows Operating System
If this doesn't help, let me know

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-05-25 : 04:35:27

can you get result of this query on SQL Server

select * from sys.dm_os_performance_counters

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com

sqlamit31
Starting Member

3 Posts

Posted - 2011-05-25 : 18:40:12

Hi Guys,thanks for the response,

Jack,

I tried sqlctr.ini but it did not work as well:

lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"

Syed,

Below is the output of counters in sys.dm_os_performance_counters, there are 1281 records in this view:

SQLServer:Databases Log File(s) Size (KB) AdventureWorksDW 2040 65792
SQLServer:Databases Log File(s) Used Size (KB) AdventureWorksDW 413 65792
SQLServer:Databases Percent Log Used AdventureWorksDW 20 65792
SQLServer:Databases Active Transactions AdventureWorksDW 0 65792
SQLServer:Databases Transactions/sec AdventureWorksDW 12 272696576
SQLServer:Databases Repl. Pending Xacts AdventureWorksDW 0 65792
SQLServer:Databases Repl. Trans. Rate AdventureWorksDW 0 272696576
SQLServer:Databases Log Cache Reads/sec AdventureWorksDW 13 272696576
SQLServer:Databases Log Cache Hit Ratio AdventureWorksDW 8 537003264
SQLServer:Databases Log Cache Hit Ratio Base AdventureWorksDW 13 1073939712
SQLServer:Databases Bulk Copy Rows/sec AdventureWorksDW 0 272696576
SQLServer:Databases Bulk Copy Throughput/sec AdventureWorksDW 0 272696576
SQLServer:Databases Backup/Restore Throughput/sec AdventureWorksDW 0 272696576
SQLServer:Databases DBCC Logical Scan Bytes/sec AdventureWorksDW 0 272696576
SQLServer:Databases Shrink Data Movement Bytes/sec AdventureWorksDW 0 272696576
SQLServer:Databases Log Flushes/sec AdventureWorksDW 3 272696576
SQLServer:Databases Log Bytes Flushed/sec AdventureWorksDW 1536 272696576
SQLServer:Databases Log Flush Waits/sec AdventureWorksDW 3 272696576
SQLServer:Databases Log Flush Wait Time AdventureWorksDW 0 65792
SQLServer:Databases Log Truncations AdventureWorksDW 0 65792
SQLServer:Databases Log Growths AdventureWorksDW 0 65792
SQLServer:Databases Log Shrinks AdventureWorksDW 0 65792
SQLServer:Databases Tracked transactions/sec AdventureWorksDW 0 272696576
SQLServer:Databases Write Transactions/sec AdventureWorksDW 1 272696576
SQLServer:Databases Commit table entries AdventureWorksDW 0 65792
SQLServer:Databases Data File(s) Size (KB) AdventureWorksDW2008R2 77120 65792
SQLServer:Databases Log File(s) Size (KB) AdventureWorksDW2008R2 2040 65792
SQLServer:Databases Log File(s) Used Size (KB) AdventureWorksDW2008R2 437 65792
SQLServer:Databases Percent Log Used AdventureWorksDW2008R2 21 65792
SQLServer:Databases Active Transactions AdventureWorksDW2008R2 0 65792

Please help me further.

Thanks
Amit

Amit

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-05-26 : 01:16:03

sqlamit31 , when you executed - lodctr "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini" - what response did you see? Does that file exist ?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

sqlamit31
Starting Member

3 Posts

Posted - 2011-05-26 : 07:00:56

Yes Jack the .ini file exists in the folder.When I executed the above command, the command prompt came back with no response.

Thanks
Amit

Amit

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources