Hello, I'm looking for a way to consolidate into a single console several sources of health information of a distributed web application.
Currently I'm collecting/monitoring about 60 performance counters (for MEM, CPU, DISKS, IIS, MSSQL) on each of 3 Windows boxes and about 10 application parameters (via direct queries in a MSSQL DB).
Which configuration do you suggest to collect the performance counters from the Windows boxes: one sensor for each perf counter?, which type of sensor?
Is there a way to issue a single query to the DB and put on different channels every single column of the resulting recordset?
I also wish to summarize informations from remote IIS logs (now I'm using Logparser to query text files and import into the database the results). Can I setup a sensor that remotely executes an exe on IIS logs, returns a complex recordset with one channel per column? should I install a local probe service on the remote server to do this?
Thanks in advance