Post reply

SQL Server Memory Usage.

  • April 11, 2008 at 3:33 am

    #71142

    My CPU Usage was increased while I ran a query for getting large amount of data from SQL table. But after executed my query the CPU Usage still shows the same status. It didn’t reduce it’s usage. What is the problem? Can you help me regarding this?

    My system requirement:-

    Ram size: 3GB,

    Operating System: Server 2003

    SQL version: Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Database Size: 90GB.

  • April 11, 2008 at 3:38 am

    #801366

    CPU or memory? (Title says one, post says the other)

    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

  • April 11, 2008 at 4:28 am

    #801377

    I meant CPU Usage.

  • April 11, 2008 at 2:29 pm

    #801719

    so when you go into task manager the SQL service is taking a lot of the CPU? continually?

    I guess I would first do a sp_who2 to see what the active processes are...and what process has a lot of CPUTime

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

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