Post reply

Find Instance in task manager

  • February 18, 2008 at 1:53 am

    #69793

    Hi,

    we have an Win 2000 Server with 3 SQL Server 2000 which run as cluster resource and 1 as normal instance.

    In the task manager i see four times sqlservr.exe - how can i find which exe is which instance?

    Thanks in advance 😉

    Jürgen

  • February 21, 2008 at 1:19 am

    #780525

    Maybe anybody here can help me

    Would be great 🙂

  • February 21, 2008 at 1:30 am

    #780529

    run

    select serverproperty('ProcessID')

    on the specific instance

    that returns the "Process ID of the SQL Server service. ProcessID is useful in identifying which Sqlservr.exe belongs to this instance." (quote from BOL)

    use it in task manager

    dragos

  • February 21, 2008 at 1:47 am

    #780541

    Is also in SQL Server errorlog - 4th line of log..

    'Server process ID is xxxx.'

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

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