Abstract
SQL Server 2012 and the Windows operating systems that it runs on perform very well storing, maintaining, and presenting data to your users. Many of the processes that make them run so well are built into SQL Server 2012 and the operating system. Sometimes, because of a variety of factors, such as data changes, new code, or poor design choices, performance can suffer. To understand how well, or poorly, your server is performing, you need to understand how to measure that performance.
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
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Rob Walters, Grant Fritchey
About this chapter
Cite this chapter
Walters, R., Fritchey, G. (2012). Performance Tuning and Optimization. In: Beginning SQL Server 2012 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3982-6_13
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3982-6_13
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3981-9
Online ISBN: 978-1-4302-3982-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books