New to SQL Server 2005 are dynamic management objects, which are database views or functions that return state specific information for the given database instance at a given time. These objects allow the DBA or developer to monitor the database server in an efficient, controlled way. Dynamic management objects replace many of the former system tables available in previous versions of SQL Server, but give the DBA many more metrics to observe.

Top Related posts:
  1. The Top 20 C++ Tips of All Time