In this article Cristian Lefter will provide a closer look at SQL Server 2005 Dynamic Management Views (DMVs). The article takes a brief tour of some of the categories of DMV that are available, showing you the kind of information you can get fro them, and how to access them both through SQL queries and through summary reports. Then Cristian works through several samples that show how you can use DMVs to identify possible bottlenecks in your MS SQL Server 2005 server.
Ewan Buckingham: Ewan is Apress' Assistant Editorial Director for Microsoft Windows based books. His current interests include the evolution of the C# 3.0 language specification and the implementation of ASP.NET AJAX in an accessible manner.
Do you have a great idea for a book about a Microsoft technology? Whether it's about a language, server or something else, we'd love to hear from you. Contact Us with your ideas.
Also, we are always looking for qualified individuals to perform paid technical reviews of our books. Drop us a line if you're interested.