The global resource for a SQL Server system is TEMPDB, because it holds all the information pertaining to temporary user objects, internal objects used by SQL engine, row versioning for data modifications and any ad hoc TSQL execution results. Since SQL...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Wed, Jun 8 2011
Filed under: Filed under: sql server, perfmon, performance, dba, best practices, table, troubleshoot, tempdb, monitoring, benchmarking, performance monitoring, counters