Post reply

CPU creep ...

  • April 8, 2004 at 7:03 am

    #107505

    Our customers are deployed in a hosted environment using a Citrix farm a a 2 node Active/Passive SQL cluster, Quad Xeons/8 gig RAM. We have a problem where the CPU utilization slowly creeps up after a few days, starts to hurt performance for the users, and then we have to reboot the database server. Then it's ok again for a few days. We're a little baffled since there are no obvious things going on like hung processes or memory leaks.

    Has anybody run into this or have suggestions on some thing to look for?

    Thanks

    Bob


    Bob
    SuccessWare Software

  • April 8, 2004 at 7:28 am

    #502139

    Have you been able to establish that the cpu utilization is being taken up by SQL?


    Shamless self promotion - read my blog http://sirsql.net

  • April 8, 2004 at 8:05 am

    #502150

    That's one of the things we are looking into.


    Bob
    SuccessWare Software

  • April 8, 2004 at 8:08 am

    #502152

    When you look at the task manager is the majority of the cpu used by SQL? And if so, try running a

    SELECT * FROM MASTER..SYSPROCESSES ORDER BY CPU DESC

    to get those processes that are using the most cpu and trace the problem down from there by checking each spid and seeing what the login is and what it's running.


    Shamless self promotion - read my blog http://sirsql.net

  • April 8, 2004 at 8:25 am

    #502158

    Thanks.

    I'll forward this to the engineer working on it. They don't give me permissions to run task manager or perfmon


    Bob
    SuccessWare Software

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

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