SQL Server Performance Forum – Threads Archive
Performance monitoring 2005
HI There Does anyone know if there is documentation on performance monitoring for 2005 yet.I see in perfmon there are some new counters etc for 2005 Sql Server Instance. What is new in performance monitoring for 2005 databases and what has changed ? I had a quick look at 2005 BOL but did not see anything detailed about this ? Thanx
http://www.sql-server-performance.com/absolutenm/templates/?a=415&z=1
http://msdn.microsoft.com/sql/learning/perf/default.aspx FYI HTH. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hi:<br />MS SQL Server books online for 2005 is fully updated with performance monitor counters. You can have a look on below link… OR simply browse till "performance counters [SQL Server]" topic in index menu.<br /><br /<a target="_blank" href=http://msdn2.microsoft.com/en-us/library/ms190382.aspx>http://msdn2.microsoft.com/en-us/library/ms190382.aspx</a><br /><br />SQLServer:Access Methods<br />SQLServer:Backup Device<br />SQLServer:Buffer Manager<br />SQLServer:Buffer Partition<br />SQLServer:CLR<br />SQLServer:Cursor Manager by Type<br />SQLServer:Cursor Manager Total<br />SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />atabase Mirroring<br />SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />atabases<br />SQLServer:Exec Statistics<br />SQLServer:General Statistics<br />SQLServer:Latches<br />SQLServer:Locks<br />SQLServer:Memory Manager<br />SQLServer<img src=’/community/emoticons/emotion-4.gif’ alt=’‘ />lan Cache<br />SQLServer<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />QL Errors<br />SQLServer<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />QL Statistics<br />SQLServer:Transactions<br />SQLServer:User Settable<br />SQLServer: Wait Statistics<br /><br />– the list look great to me.. <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />Cheers !!<br /><br />Deepak Kumar<br /><br />–This posting is provided “AS IS†with NO rights for the sake of knowledge sharing.
]]>