With the advent of the Dynamic Management Objects (DMOs) in SQL Server 2005,
Microsoft vastly expanded the range and depth of metadata that could be exposed
regarding the connections, sessions, transactions, statements, and processes that are, or
have been, executing against a database instance. These DMOs provide insight into the
resultant workload generated on the server, how it is distributed, where the pressure
points are, and so on, and are a significant and valuable addition to the DBA's
troubleshooting armory.