New performance monitor counters for SQL Server 2008

  • Article

I have been looking at some of the new performance counters that are shipped with SQL Server 2008.  Unfortunately some of these are either not well documented or not documented at all.  The list so far consists of:

  1. SQL Server Databases: Tracked transactions/sec - Number of committed transactions recorded in the commit table for the database.
  2. SQL Server Databases: Write Transactions/sec - Number of transactions which wrote to the database in the last second.
  3. SQL Server Buffer Node: Remote node page lookups/sec - Number of lookup requests from this node which were satisfied from other nodes.
  4. SQL Server Buffer Node: Local node page lookups/sec - Number of lookup requests from this node which were satisfied from this node.
  5. SQL Server General Statistics: Connection reset/sec - Total number of connection resets per second.
  6. SQL Server General Statistics: Tempdb recovery unit id unit - Number of duplicate tempdb recovery unit id generated
  7. SQL Server General Statistics: Tempdb rowset id - Number of duplicate tempdb rowset id generated
  8. SQL Server SQL Statistics: Misguided plan executions/sec - Number of plan executions per second in which a plan guide could not be honored during plan generation
  9. SQL Server SQL Statistics: Guided plan executions/sec - Number of plan executions per second in which the query plan has been generated by using a plan guide.
  10. Deprecated Features: Usage <feature> – this is a really nice counter which lists feature usage since last SQL Server startup

I know there are lots more e.g. resource governor etc. but these are the counters which caught my eye.