Blog Post
SQL Server - Identify Top IO & CPU Cost Queries
Author
Mandy Doward
Date
June 6, 2017
Length
1 min
SQL Server, CPU & IO
SQL Server is very CPU and IO intensive and many SQL query performance and application performance problems will come dopwn to excessive processor or disk activity.
Although Windows servers create the illusion of a single CPU being able to carry out m,any task at the same time, it is not possible. The illusion is created by employing a time slicing approach where each task (thread) that is placed in the processor queue gets to use the processor for a small amount of time and then goes back into the processor queue to await its next turn.
Share This Page
Mandy Doward
Managing Director
PTR’s owner and Managing Director is a Microsoft MCSE certified Business Intelligence (BI) Consultant, with over 30 years of experience working with data analytics and BI.
PTR FAQs
See our FAQs or get in contact for more information on any of our services, solutions, or to start your PTR journey.