Review of 3 articles: “Performance Tuning Using Extended Events” by Brian Davey. Davey is a Senior Database Administrator in Elmhurst, Illinois.
Davey’s articles offer a great explanation on using SQL Server extended events for performance tuning SQL Server.
Here are some of the highlights of the three articles.
There are 4 relevant SQL Server extended events to identify queries for SQL Server performance tuning:
- application aborts
- long running queries
There are 3 common extended event configurations:
- File size and number of rollover files (max_file_size, max_rollover_files)
- Losing Event Data (EVENT_RETENTION_MODE)
- Automatic restart (STARTUP_STATE)
Davey walks through his own custom stored procedure to shred the XML output from the extended event traces. Davey gives an excellent explaination of what to look for each of the 4 relevant SQL Server extended events.
In Part 3, Davey discusses building multiple reports to analyze the results from each of the 4 relevant SQL Server extended events.
Finally, Davey does caution “careful root-cause analysis should be used … before implementing any changes”.
These three articles by Davey are great info on using SQL Server extended events for performance tuning and gets a thumbs up! Davey’s custom SQL code is also downloadable and ready to be used.
DBAs it’s time to learn how to use extended events for performance tuning. Right?
Pearson Education (InformIT) – eBook Deal of the Day
Pluralsight – Start your Free Trial today! – Don’t let technology outpace you. Work smarter and master your craft with a technology learning platform that will help you build better and create more.
Coursera – You’ve got a deep network, a great resume, and a top-notch LinkedIn profile. Start building in-demand skills on Coursera, and your career will be ready to take off. Start your 7-day risk-free trial today. – Take the world’s best courses, online.
RetiredDBA.com is compensated if you click to an advertiser website and/or you make a purchase after clicking to an advertiser website. This does not INCREASE the price you pay. The income is used to continue to provide as much free content as possible.