Chapter 22. Dynamic Management Views

After completing this chapter, you will be able to

  • Retrieve information about objects within an instance

  • View activity for any database

  • Identify potential bottlenecks

The term “enterprise class” has been thrown around so much within the industry that the meaning has become lost. An enterprise class application or platform does not mean that you can store or process a large amount of data. An enterprise class application or platform provides the instrumentation that allows administrators to locate, diagnose, and fix problems before they escalate to impact the business. SQL Server 2008 provides an enterprise class data management platform through the exposure of diagnostic information at every layer of the engine. ...

Get Microsoft® SQL Server® 2008 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.