You've got SQL Server Tracing data that might show you what pokey database calls your app's making, and you've got PerfMon Counters for Windows, the .NET Framework and IIS; but these are just telling ...

Rolling Your Own Unfortunately, you can sometimes capture SQL Server Tracing data and dozens of PerfMon Counters and still feel like you're just guessing at what the problem is.

Some of the more popular performance counters are for processor and memory usage, simultaneous connections, throughput and response time, SQL Server performance, and Active Server Pages (ASP) and ...

MRTG or Cacti using the same Perfmon counters via SNMP is a great tool, and it should be running all the time so that you can have baseline numbers.

I was just wondering if anyone was dumping performance monitoring data to SQL Server tables?Any tips, advice, thoughts in general on this?Lessons hard learned, etc...?Here is what I am dreaming of ...

You can use performance counters to monitor a server's health, as well as its corresponding applications and network interactions. Some of the more popular performance counters are for processor and ...