Post reply

SQL SERVER IS VERY SLOW

  • October 29, 2008 at 9:52 am

    #192788

    After moving the nonclustered indexes to seperate disk array on secondary filegroup the CPU usage is reaching to 90-100%. Any thing wrong you think? Can some please help me understand why its consuming most of the cpu usage?

  • October 29, 2008 at 9:56 am

    #891318

    Are you sure that you didn't drop an index by accident?

    Run profiler for a while, find the queries that are using the most cpu, run them and look at the execution plan. See if there are places where it looks like an index might be missing.

    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

  • October 29, 2008 at 10:05 am

    #891329

    Could these disks be very slow as well? Or slower?

  • October 29, 2008 at 10:24 am

    #891350

    I ran the missing indexes script and I do not see any indexes are missing. what will be the problem you think?

  • October 29, 2008 at 1:48 pm

    #891458

    hydbadrose (10/29/2008)

    what will be the problem you think?

    No idea. There are far too many possibilities to say for certain.

    Run profiler for a while, find the queries that are using the most cpu, run them and look at the execution plan. See if you can see what's the most resource intensive.

    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

Viewing 5 posts - 1 through 4 (of 4 total)

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