Sign in
 
Home20132010Other VersionsLibraryForumsGallery

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.

counters.txt
 
 
 
 
 
4.1 Star
(34)
6,470 times
Add to favorites
SharePoint
2/14/2014
E-mail Twitter del.icio.us Digg Facebook
  • Hide
    how to wirte counters.txt file to get following parameters??
    3 Posts | Last post November 27, 2012
    • Written October 29, 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)
    • Written November 26, 2012 
      I'm considering adding such counters in a new SharePoint 2013 specific version, thanks for the input!
    • Written November 27, 2012 
      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
  • Hide
    What is the attached counters.txt good for?
    2 Posts | Last post August 30, 2012
    • Written July 31, 2012 
      Thanks,
Zoli
    • Written August 30, 2012 
      Zoltan:
The counters.txt file holds the list of counters whose values are retrieved by the get-counter command in the script.