PASS Summit 2010
Register Now

ROI Justification

Sponsors

Questions?

PASS Facebook PASS LinkedIn PASS Twitter


Premier Sponsor:
  

Platinum Sponsor:
  
DMV's as a Shortcut to Procedure Tuning
Dynamic Management Views (DMV) expose a wealth of information to the database administrator. However, they also expose information that is vital to the database developer. More often than not people gather performance metrics through server side traces. This session will show how to gather information from the DMVs for currently executing, and recently executed queries. The session will demonstrate combining this information with other DMVs to get more intersting information such as the query plan and query text. I'll show where you can get aggregate information for the queries in cache to determine which queries are being frequently accessed or using the most resources. I'll show how to determine which indexes are being used in your system and which are not. All of this will be focused, not on the DBA, but on the query writer, the developer or database developer that needs information to tune and troubleshoot data access.
Speaker:
FM Global
Principal DBA
I am a database administrator for FM Global, an engineering and insurance company. I have 20+ years experience in IT including time spent in support and development. I have been working with SQL Server since 6.0 back in 1995. I have developed in VB, VB.Net, C# and Java. I volunteer at PASS with the Editorial Committee. I'm the serving president of the Southern New England SQL Server Users Group (SNESSUG). I was awarded as a Microsoft SQL Server MVP in 2009 and 2010.
Register Now for PASS Summit 2010!


 
  Top Reasons to Attend
PASS Summit 2010
  • Over 160 technical sessions from the world's top SQL Server and BI experts
  • 2 full days of deep-dive Pre- and Post-Conference Seminars
  • Networking with thousands of SQL Server MVPs, experts, Microsoft employees, and peers
  • Face-to-face support with the Microsoft CSS and SQLCAT teams
  • Ask the Experts Lounge
  • And much more!
 
 

Gold Sponsor

     
     
Copyright 2010 by PASS | Terms of Use | Privacy Statement