Advertisement

SQL Query Performance Analysis

  • Grant Fritchey

Abstract

A common cause of slow SQL Server performance is a heavy database application workload-the nature of the queries themselves. Thus, to analyze the cause of a system bottleneck, it is important to examine the database application workload and identify the SQL queries causing the most stress on system resources. To do this, you can use the Extended Events and other Management Studio tools.

Keywords

Nest Loop Execution Plan Query Performance Extended Event Event Session 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Grant Fritchey 2012

Authors and Affiliations

  • Grant Fritchey

There are no affiliations available

Personalised recommendations