Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Friday, September 1, 2017

100% High CPU Usage and High Number of Wait Times (6K ms/Sec)

SQLServerCentral » Latest topics
100% High CPU Usage and High Number of Wait Times (6K ms/Sec)
We are facing a problem where CPU usage on SQL Server 2008 R2 spikes to 100% and during this period our backoffice application clients stop responding. It takes 3-5 seconds and then clients start responding. When it happens then Data File I/O in SQL Serve

No comments: