March 17, 2017 at 12:27 pm
Never really come across this issue, i have a query when i execute overall server CPU gets to 80%.When i look in the details in task manager, whenever i run the query process "System" shows it is using 60% CPU and "sqlserver.exe" uses only 20 %. I do know the query has a missing index, just curious to know why "System" process is so pegged.
March 19, 2017 at 9:10 am
curious_sqldba - Friday, March 17, 2017 12:27 PMNever really come across this issue, i have a query when i execute overall server CPU gets to 80%.When i look in the details in task manager, whenever i run the query process "System" shows it is using 60% CPU and "sqlserver.exe" uses only 20 %. I do know the query has a missing index, just curious to know why "System" process is so pegged.
Maybe due to the "system" trying to do I/O to/from disk. We can't really tell though because there's not enough information and it sounds like the query may have other problems. Can you attach the ACTUAL execution plan?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy