Anzeige
Erschienen in:
2018 | OriginalPaper | Buchkapitel
4. CPU Performance Analysis
verfasst von : Grant Fritchey
Erschienen in: SQL Server 2017 Query Performance Tuning
Verlag: Apress
Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.
Wählen Sie Textabschnitte aus um mit Künstlicher Intelligenz passenden Patente zu finden. powered by
Markieren Sie Textabschnitte, um KI-gestützt weitere passende Inhalte zu finden. powered by
Abstract
This chapter concludes the book’s exploration of the system, with a discussion about CPU, network, and general SQL Server metrics. The CPU is the work engine of a system and keeps everything running. All the different calculations required for gathering and delivering data, maintaining the system, and ordering access are performed by the CPU. Getting bottlenecked on the CPU can be a difficult process to work out of. Unlike memory, which you can sometimes easily install more of, or disks, which you can sometimes easily add more of or upgrade, CPUs are an integral part of the system you’re running on and can frequently be upgraded only by buying newer machines. So, you’ll want to keep an eye on CPU usage. Networks are seldom a major bottleneck for SQL Server, except of course when dealing with Azure SQL Database, but it’s good to keep an eye on them too. Finally, there are some SQL Server internal processes that you’ll need to gather metrics on. This chapter covers the following topics:
-
How to gather metrics on the processor
-
Additional metrics available through T-SQL queries
-
Methods for resolving processor bottlenecks