A system can directly impact SQL Server and the queries running on it in three primary places: memory, disk, and CPU. You’re going to explore each of these in turn starting, in this chapter, with memory. Queries retrieving data in SQL Server must first load that data into memory. Any changes to data are first loaded into memory where the modifications are made, prior to writing them to disk. Many other operations take advantage of the speed of memory in the system, such as sorting data using an ORDER BY clause in a query, performing calculations to create ...
© Grant Fritchey 2018
Grant FritcheySQL Server 2017 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-3888-2_22. Memory Performance Analysis
Grant Fritchey1
(1)
Grafton, Massachusetts, USA
Get SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
