High CPU/IO

  • Hi,

    I have a third party app Virutal Center which is on a consolidated server. I ran sp_who2 and it seems that it's not doing anything, but it has high cpu and I/O. The guys using the app mentioned that their app has grinded to halt although Im not seeing much from the db side? Any advice much appreciated.

  • Hello,

    When there is high CPU & I/O there is some problem with the query, kindly check which query is talking much CPU & I/O and analyse it.

    check index as well in the query table.

    Regards
    Durai Nagarajan

  • Hi,

    As this is a third party app, the guys are accessing this through the GUI and the app just freezes!

  • http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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
  • TST1 (9/20/2011)


    Hi,

    I have a third party app Virutal Center which is on a consolidated server. I ran sp_who2 and it seems that it's not doing anything, but it has high cpu and I/O. The guys using the app mentioned that their app has grinded to halt although Im not seeing much from the db side? Any advice much appreciated.

    Where are you measuring the CPU and I/O. Whats the utilization of the sqlservr.exe.

    Is the whole app hung or just a particular page or feature.

    Are you sure you have sized the server properly to begin with ?

    Jayanth Kurup[/url]

  • I'm not really able to do much since this is a third party product which is frustrating! I would have thought that perhaps I might have been able to retrieve something from dmvs?

  • TST1 (9/20/2011)


    I'm not really able to do much since this is a third party product which is frustrating! I would have thought that perhaps I might have been able to retrieve something from dmvs?

    I've tuned 3rd party apps to death with only adding new indexes (not editing since it could have been seen as breach of contract and break in future updates).

    I've seen up to 90% slashing in all costs (cpu, reads, duration). Those articles are not to be underestimated ;-).

  • Yeah, if it's grinding along, you should be looking as sys.dm_exec_requests for blocked & blocking processes or for processes that are using lots of resources or are waiting on resources. You can get all of that there. Combine it with other DMOs for the sql text and the execution plan. If you want to see how things are behaving over time, use sys.dm_exec_query_stats to see the history (in cache) of the queries.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply