Home

Results 1 to 3 of 3

Thread: Question on the General_Counter script.

  1. #1
    Join Date
    Nov 2016
    Posts
    84

    Question on the General_Counter script.

    Greetings,
    We have a request to monitor specific performance counters across a number of SQL Servers but they all have named instances. We have on the order of 50 unique instances across over 200 hundred servers. Is there a way to place a wild card where the instance name is so we can use one job to measure the counter across all the servers?

    For instance, instead of "MSSQL$SQL1:Buffer Partition\Free list empty/sec\*" is there a way to do "*:Buffer Partition\Free list empty/sec\*"? Many thanks in advance for any help.

    v/r
    Chris

  2. #2
    Join Date
    Nov 2016
    Location
    Houston, TX
    Posts
    29

    Re: Question on the General_Counter script.

    abel5405 on 1/4/2019 at 12:34:02 PM wrote:

    >
    >Greetings,
    >We have a request to monitor specific performance counters across a
    >number of SQL Servers but they all have named instances. We have on
    >the order of 50 unique instances across over 200 hundred servers. Is
    >there a way to place a wild card where the instance name is so we can
    >use one job to measure the counter across all the servers?
    >
    >For instance, instead of "*MSSQL$SQL1:Buffer Partition\Free list
    >empty/sec\**" is there a way to do "**:Buffer Partition\Free list
    >empty/sec\**"? Many thanks in advance for any help.
    >
    >v/r
    >Chris



    You should be able to list it as *MSSQL$*:Buffer Partition\Free list
    empty/sec\**

    --ebell


  3. #3
    Join Date
    Nov 2016
    Posts
    84

    Re: Question on the General_Counter script.

    Will give that a try Ethan! Thanks man!

    v/r
    Chris

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •