Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Gathering Perfmon counters on multiple servers similtaneously Expand / Collapse
Author
Message
Posted Tuesday, September 18, 2012 2:16 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 3:49 AM
Points: 904, Visits: 1,884
Generally when reviewing a server we capture a bunch of perfmon counters using either SQLDiag, or just perfmon either via GUI or via LogMan.exe.

But now we have a large distributed environment to profile. Obviously we wont be gathering micro level statists on all servers, but we want a general view of all servers, to give us an idea of where to start digging in to look for performance issues.

Our plan is to capture a bunch of perfmon counters on each server, but our problem is we dont want to set this up on each of the 20+ servers.

I know that the MAP tool does some performance counter gathering so that may be useful, but can anyone recommend any other tools that might make this job easier?
Post #1360616
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse