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.
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.ThanksAmitAmit |
|
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 installThe 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 SystemIf this doesn't help, let me knowJack 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 Serverselect * from sys.dm_os_performance_countersRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.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 65792SQLServer:Databases Log File(s) Used Size (KB) AdventureWorksDW 413 65792SQLServer:Databases Percent Log Used AdventureWorksDW 20 65792SQLServer:Databases Active Transactions AdventureWorksDW 0 65792SQLServer:Databases Transactions/sec AdventureWorksDW 12 272696576SQLServer:Databases Repl. Pending Xacts AdventureWorksDW 0 65792SQLServer:Databases Repl. Trans. Rate AdventureWorksDW 0 272696576SQLServer:Databases Log Cache Reads/sec AdventureWorksDW 13 272696576SQLServer:Databases Log Cache Hit Ratio AdventureWorksDW 8 537003264SQLServer:Databases Log Cache Hit Ratio Base AdventureWorksDW 13 1073939712SQLServer:Databases Bulk Copy Rows/sec AdventureWorksDW 0 272696576SQLServer:Databases Bulk Copy Throughput/sec AdventureWorksDW 0 272696576SQLServer:Databases Backup/Restore Throughput/sec AdventureWorksDW 0 272696576SQLServer:Databases DBCC Logical Scan Bytes/sec AdventureWorksDW 0 272696576SQLServer:Databases Shrink Data Movement Bytes/sec AdventureWorksDW 0 272696576SQLServer:Databases Log Flushes/sec AdventureWorksDW 3 272696576SQLServer:Databases Log Bytes Flushed/sec AdventureWorksDW 1536 272696576SQLServer:Databases Log Flush Waits/sec AdventureWorksDW 3 272696576SQLServer:Databases Log Flush Wait Time AdventureWorksDW 0 65792SQLServer:Databases Log Truncations AdventureWorksDW 0 65792SQLServer:Databases Log Growths AdventureWorksDW 0 65792SQLServer:Databases Log Shrinks AdventureWorksDW 0 65792SQLServer:Databases Tracked transactions/sec AdventureWorksDW 0 272696576SQLServer:Databases Write Transactions/sec AdventureWorksDW 1 272696576SQLServer:Databases Commit table entries AdventureWorksDW 0 65792SQLServer:Databases Data File(s) Size (KB) AdventureWorksDW2008R2 77120 65792SQLServer:Databases Log File(s) Size (KB) AdventureWorksDW2008R2 2040 65792SQLServer:Databases Log File(s) Used Size (KB) AdventureWorksDW2008R2 437 65792SQLServer:Databases Percent Log Used AdventureWorksDW2008R2 21 65792SQLServer:Databases Active Transactions AdventureWorksDW2008R2 0 65792Please help me further.ThanksAmitAmit |
 |
|
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.ThanksAmitAmit |
 |
|
|
|
|
|
|