Forum Replies Created
Viewing 5 posts - 1 through 6 (of 6 total)
-
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)
Hi Jeff
Started saving performance monitor screenshots. I feel more confident after using it.Here is the update query. It is from a third party application which moves data...
-
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)
Jeff Moden - Saturday, September 2, 2017 11:10 AMmuhammadaftab25 - Saturday, September 2, 2017 12:01 AMRE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)
Hi Jeff & Chris. From the query posted by Chris, we noticed that there is an update query inside an SP that is running on a table of 4 million...
RE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)
Jeff Moden - Friday, September 1, 2017 9:00 AMRE: 100% High CPU Usage and High Number of Wait Times (6K ms/Sec)
Hi Alan
Plz see the attached results.
RAM in server is 64GB. Max memory is 2TB by default. Tempdb sits in C drive. The server has RAID 10 with C,...Viewing 5 posts - 1 through 6 (of 6 total)
