REMINDER: Performance VC Meeting TODAY Thursday 5/24 @2PM ET
Ryan Adams
Our speaker this month is Jerry Brenner. Jerry will be presenting “DMVs - Understanding an Application's Database Usage”.
Topic Abstract:
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.
Speaker:
Jerry Brenner is Lead Performance Engineer at Guidewire, spending 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.
This meeting is sponsored by CONFIO SOFTWARE. There will be a drawing for a $50 Amazon gift card at the end of the meeting. A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address.
Meeting Details:
May 24th, 2PM ET
Performance Virtual Chapter on the web!
Website – http://performance.sqlpass.org
Twitter – http://www.twitter.com/SQLPass_PVC
Distribution List - http://groups.google.com/group/perfvc
Ryan J. Adams
NTSSUG Director of Logistics and Communications
PASS Performance Virtual Chapter Director of Marketing
PASS Regional Mentor – U.S. South Central
MCP MCSA MCSE MCDBA
MCTS:SQL 2005 MCITP:SQL 2005