Post reply

Performance issues on one instance

  • March 6, 2005 at 4:19 pm

    #362100

    I recently upgraded from SQl Standard to SQL Enterprise.  I have 6 instances on this server.  Since upgrading I have one instance that is using all the CPU while the others are running just fine. 

    The problem being that when I go into task manager all it shows me is 6 sqlsevr.exe's with one sitting on 90%.  How can I tell which one of the instances is doing this and what is the best method to find out why?

    Thanks,

    Kris

  • March 6, 2005 at 8:10 pm

    #545645

    Have a look in the SQL Server Log for each instance.  Near the start of it you will see a line that looks like

    Server Process ID is 1234

    In task manager, add Process ID as one of the columns. 

    You should now be able to find the SQL instance by matching up the process id from the SQL Log and task manager.

  • March 6, 2005 at 8:37 pm

    #545647

    Thanks, you're a legend

    Thanks,

    Kris

  • March 7, 2005 at 8:48 am

    #545741

    alternative you could use

    select serverproperty('ProcessID') -- on each instance.

    you can use DMO to loop through the isntances and retrieve the ProcessID property of the SQLServer object if you need to automate that

    HTH 


    * Noel

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

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