Popular Posts

  • The Basics of Good T-SQL Coding Style – Part 4: Performance
    SQLServerCentral.com Articles The Basics of Good T-SQL Coding Style – Part 4: Performance There are several obvious problems with p...
  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...
  • A Backup Change
    SQLServerCentral » Latest topics A Backup Change Comments posted to this topic are about the item [B] A Backup Change [/B] more in...

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

Loading...

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
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)