Post reply

Several Instances of SQL

  • June 2, 2005 at 5:25 pm

    #88526

    I currently have a SQL server that has 6 instances of SQL.  Can you tell me if there is a way to tell the difference between each instance in task manager.  So you can check which one is using most of the processor etc.  At the moment it just shows SQLServ.exe and I can't tell which is which.

    Thanks in advance.

     

    Thanks,

    Kris

  • June 2, 2005 at 9:45 pm

    #562767

    Have a look at the SQL Server Log. Shortly after SQL starts, it writes a record into this log that looks like

    Server Process ID is 3936.

    This is the value shown in task manager as PID

  • June 2, 2005 at 9:53 pm

    #562768

    Thanks for that

    Thanks,

    Kris

  • June 3, 2005 at 7:02 pm

    #563044

    In Windows 2003 you can see user name (add "Users name" column from "View" menu). You will see difference if your instances run under different NT accounts.

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

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