Performance monitoring 2005 | SQL Server Performance Forums

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 FYI HTH. Satya SKJ
Contributing Editor & Forums Moderator
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=></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=’:D‘ />atabase Mirroring<br />SQLServer<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />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=’:p‘ />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.