RetiredDBA.com

RetiredDBA.com provides tidbits, ideas and insights to all things Microsoft SQL Server.

Home / SQL Server / DBAs learn how to extend your performance!

DBAs learn how to extend your performance!

/
/
/



Review of 3 articles: “Performance Tuning Using Extended Events” by Brian Davey. Davey is a Senior Database Administrator in Elmhurst, Illinois.

Performance Tuning Using Extended Events: Part 1

Performance Tuning Using Extended Events: Part 2

Performance Tuning Using Extended Events: Part 3

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:

  • Deadlocks
  • application aborts
  • blocking
  • 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?


Ad

Udemy – Microsoft SQL Server 2019 – An introduction

Udemy – Get top courses for as low as $12.99!

Pearson Education (InformIT) – eBook Deal of the Day

Edureka – Data Science Training by Edureka Drive Business Insights from Massive Data Sets Utilizing the Power of R Programming, Hadoop, and Machine Learning.

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.

Pluralsight – Get your Skill IQ with a Free Assessment from PluralSight

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.

Whizlabs – Online Training for Agile Certified Practitioner (PMI ACP)® Certification Exam | Enroll Now

Edureka –


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.


This div height required for enabling the sticky sidebar

Advertisers



Programmer Solutions Inc Websites

BUSINESS
CITY JOB RESOURCES
MIDWEST JOB RESOURCES
SOUTH JOB RESOURCES
WEST JOB RESOURCES
Industrial Supply DealsChicago Job ResourceKansas Job ResourceAlabama Job ResourceAlaska Job Resource
Office Supply DealsWashington, DC Job ResourceIllinois Job ResourceArkansas Job ResourceArizona Job Resource
EDUCATION
SPECIAL JOB RESOURCES
Indiana Job ResourceDelaware Job ResourceCalifornia Job Resource
Back To School MallDiversity Job ResourceIowa Job ResourceFlorida Job ResourceColorado Job Resource
SHOPPING
First Job ResourceMichigan Job ResourceGeorgia Job ResourceHawaii Job Resource
Health Care and FitnessFreelance Job ResourceMinnesota Job ResourceKentucky Job ResourceIdaho Job Resource
Just Best GiftsIntern Job ResourceMissouri Job ResourceLouisiana Job ResourceMontana Job Resource
Just Clearance SalesSeasonal Job ResourceNebraska Job ResourceMaryland Job ResourceNevada Job Resource
Just Comparison ShoppingSenior Job ResourceNorth Dakota Job ResourceMississippi Job ResourceNew Mexico Job Resource
Just OutletsVolunteer Job ResourceOhio Job ResourceNorth Carolina Job ResourceOregon Job Resource
Luxury Matters
TARGETED JOB RESOURCES
South Dakota Job ResourceOklahoma Job ResourceUtah Job Resource
Tradin StuffBlue Collar Job ResourceWisconsin Job ResourceSouth Carolina Job ResourceWashington Job Resource
Value BuyersExecutive Job Resource
NORTHEAST JOB RESOURCES
Tennessee Job ResourceWyoming Job Resource
TECHNOLOGY
Finance Job ResourceConnecticut Job ResourceTexas Job Resource 
FrontPage HelpHealthcare Job ResourceMaine Job ResourceVirginia Job Resource 
MCDBA DirectoryIT Job ResourceMassachusetts Job ResourceWest Virginia Job Resource 
Retired DBAPink Collar Job ResourceNew Hampshire Job Resource  
SQL Server DirectorySports Job ResourceNew Jersey Job Resource  
Transact SQL DirectoryWhite Collar Job ResourceNew York Job Resource  
  Pennsylvania Job Resource  
  Rhode Island Job Resource  
  Vermont Job Resource