When you need to troubleshoot a problem, prior to SQL Server 2005 you have to depend upon PROFILER or query system tables constantly or some other means to trace the system usage. SQL Server 2005 onwards DBAs are equipped with Dynamic Management Views...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Mon, Sep 13 2010
Filed under: Filed under: sql server, performance, memory, dmv, dba, best practices, disk space, troubleshoot, system, resource, beginner, performance tuning