Post reply

Perfmon with SQL Server multiple instances

  • April 5, 2016 at 3:06 pm

    #309648

    Don't know if this is the correct forum but here it is - using perfmon on a SQL Server with named instances, when selecting an object you will see those instances but not with a specific reference (i.e. sqlservr#1, sqlservr#2). How can you determine which named instance corresponds to a specific sqlservr#. Default looks simple enough - but those with a reference number? Does anyone have any experience with that?

    Any comments / URLs are appreciated. Thanks.

  • April 5, 2016 at 3:23 pm

    #1870009

    The SQL Server objects are named for the instance name. They'll be something like MSSQL$InstanceOne/Memory Manager

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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