Name: Programmatically Analyze the DMVs to Understand an Application’s Database Usage
Start: 2012-11-20T18:30:00-08:00
End: 2012-11-20T21:30:00-08:00
Location: Microsoft

Speaker: Jerry Brenner of Guidewire

The DMVs (Dynamic Management Views) contain a wealth of information about how your application uses the database. Jerry will discuss a set of useful queries against the DMVs, describing how to build a tool using those (or similar) queries to get a good picture of how your application uses the database while 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. The demo will use examples from the performance testing of various applications.

You'll learn:

How contents of some of the DMVs related to query performance The advantages of analyzing the top queries as a group How the DMVs can be used to identify potential scaling issues before they turn into problems in production The advantages of programmatically analyzing the contents of the DMVs (vs. relying on scripts or individual queries) Jerry Brenner is Lead Performance Engineer at Guidewire and spends a lot of time developing tools that mine the DMVs and system tables, to enable quick debugging of performance issues. He spent the first half of his career working on query optimizers and implementing SQL functionality. He was technical lead for the rewriting of subquery processing in Sybase, so that Peoplesoft could release on Sybase, and an original member of the query processing team at Cloudscape, the first relational database written in Java.

Mark Ginnebaugh

Silicon Valley Azure Data Platform Meetup

Technology

SQL Server

Database Professionals

Database Development

Data Management

Data Analytics

Microsoft Azure

Data Governance

Power BI

Business Intelligence

Data Visualization

PaaS (Platform as a Service)

Programmatically Analyze the DMVs to Understand an Application’s Database Usage

Microsoft

Share

Silicon Valley Azure Data Platform Meetup

Programmatically Analyze the DMVs to Understand an Application’s Database Usage

Silicon Valley Azure Data Platform Meetup

Details

Members are also interested in