Abstract
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 due to an ORDER BY clause in a query, performing calculations to create hash tables when joining two tables, and putting the tables in memory through the in-memory OLTP tables functions. Because all this work is being done within the memory of the system, it’s important that you understand how memory is being managed.
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). Memory Performance Analysis. In: SQL Server 2017 Query Performance Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3888-2_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3888-2_2
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)