Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning SQL Server 2008 R2 is Sending too much Data through the network RE: SQL Server 2008 R2 is Sending too much Data through the network

  • June 5, 2013 at 2:10 am

    #1621211

    SQL Geek (6/5/2013)

    Hi SQLSACT, There is no wait only the CPu utilization is 90-100%.

    CPU usage at 100% in no way indicates or suggests that there's too much network traffic.

    In contrast, it's an indication that one or more queries are performing inadequately, either due to changes to the query, the tables or the data.

    Identify what queries are using the CPU, tune them to work more efficiently

    Chapter 3: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass