DMVs - Understand an Application's Database Usage
Track 3 - Development
The DMVs contain a wealth of information about how your application uses the database. This talk will describe how to build a tool to mine the DMVs to get a good picture of how your application uses the database, leveraging your understanding of your application and/or it’s data model. By building a tool in a programming language, instead of relying on scripts, you can use set operations to minimize the number of queries executed against the database and then correlate information from a variety of DMVs and system tables. For example, you can execute a single query to get the execution statistics, text and showplan xml for the top N queries and then use XPath on the client to query the showplan xml and extract a wealth of information.