Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Gathering Perfmon counters on multiple servers similtaneously Expand / Collapse
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: Sunday, November 20, 2016 3:52 AM
Points: 927, Visits: 2,039
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