PowerShell script for monitoring SharePoint WFE's and SQL Server back-ends

You may find that this gallery upload is more than you think (wasn't that the slogan of Office once?). Choosing the correct set of performance counters for monitoring SharePoint WFE's and back-ends is a daunting task, and this is my attempt.

4.1 Star
6,533 times
Add to favorites
E-mail Twitter del.icio.us Digg Facebook
  • how to wirte counters.txt file to get following parameters??
    3 Posts | Last post November 27, 2012
    • 1)Excel Services Web Frontend (Active Requests)
      2)Excel Calculation Services(Requests With Errors Per Sec,Sessions Per Second,Cached Charts Requested Per Sec,active sessions,active requests)
      3)Excel WebAccess(Excel Web Access Request Time,Chart Image Requests per Second)
      4)Office Search Archival Plugin(Active Docs in First Queue,Total Documents,Active Queue,Bulk Insert Sessions)
      5)Office Search Schema Plugin(Aliases Loaded,Error Documents,Refresh Count,Total Documents)
      6)Office Server Search Indexer Catalogs(Failed Queries,Succeeded Queries,queries,index size)
      7)Share Point Server Servcies(Service Name,status,health)
      8)Web Content Management-Publishing Cache(Publishing Cache Hit Ratio,Total Object Discards)
    • I'm considering adding such counters in a new SharePoint 2013 specific version, thanks for the input!
    • Btw, using the -listset parameter, you can find out more info about the names of performance counters yourself, and add them to the counters.txt file. For example, using the following command, I'm getting all the names of SharePoint Foundation counters:
      (get-counter -listset "sharepoint foundation").paths
  • What is the attached counters.txt good for?
    2 Posts | Last post August 30, 2012
    • Thanks,
    • Zoltan:
      The counters.txt file holds the list of counters whose values are retrieved by the get-counter command in the script.