Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Build your own SQL Server 20... > DMVs as the source of performance-re...

DMVs as the source of performance-related information

I think that Books Online, the official SQL Server documentation, contains the best definition of the DMVs: “Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.” DMVs are a great source of performance-related information.

I won’t cover the DMVs in this chapter; instead, I encourage you to become familiar with all of them on your own. To do so, you can run the query from listing 1 to view all the dynamic objects available in your SQL Server instance, check the SQL Server documentation for more details, and play with them to see the information they provide. For a good reference on DMVs I recommend a series of articles titled “A DMV a Day” by Glenn Berry (SQL Server MVP and author of chapter 31) available on Glenn’s blog: http://sqlserverperformance.wordpress.com/2010/05/02/recap-of-april-2010-dmv-a-day-series/.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint