Details

DMVs - Understand an Application's Database Usage

Speaker: Jerry Brenner

Duration: 60 minutes

Track: 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.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids