"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking"
Dynamic Management views were introduced in SQL Server 2005 and have made management and troubleshooting of SQL Server significantly easier than in previous versions. Even if you do not write your own queries against these DMVs you may be using them in Performance Dashboard Reports or other performance reporting applications. In this talk I will go through my TOP favorite DMVs and show how and when they can be used and why I like them!
Speaker focus
Martin Bell is a dashing and attractive redhead and you would never guess that he has been a freelance computer consultant in the UK for over 23 years. He’s worked on many relational database systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003 proving he is not just a pretty face! As an insight into his masochistic tendancies he currently organises the Scottish Area and Leeds Area SQL Server User Group meetings. He is also a founding organiser of the highly successful SQLBits Community Conferences showing he is slightly mad and very funny!!
Other sessions from this conference