Abstract
A common cause of slow SQL Server performance is a heavy database application workload—the nature and quantity 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 Extended Events and other Management Studio tools.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Grant Fritchey
About this chapter
Cite this chapter
Fritchey, G. (2018). Query Performance Metrics. In: SQL Server 2017 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3888-2_6
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3888-2_6
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3887-5
Online ISBN: 978-1-4842-3888-2
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)