Related Perfmon: which counter identifies that threads are waiting? but sadly abandoned by the asker
Using perfmon, which counters should I pay particular attention to when debugging ASP.NET and SQL performance problems?
Some system stats in case that makes any difference
SQL Server 2008 (64 bit version)
Windows Server 2008 R2 Enterprise x64 (SP1)
12GB RAM
Xeon X5560 x 2.80GHz (2)
There are two fairly active database instances on this computer. One belongs to our product, one belongs to a SCADA vendor. I would love to see the performance separately on each of those two instances to know if one of the components keeps dropping into contention.