Understanding Dynamic Management Views and Functions in SQL Server 2008

Posted on SQL Server Central See other posts from SQL Server Central
Published on 2010/04/06 Indexed on 2010/04/06 6:04 UTC
Read the original article Hit count: 256

Filed under:
Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system.
SQL Response SQL Server monitoring made easy
"Keeping an eye on our many SQL Server instances
is much easier with SQL Response." Mike Lile.
Download a free trial of SQL Response now.

© SQL Server Central or respective owner