Hello. We have about 25 SQL servers and a DBA wants to be able to analyse select queries that chew up too much CPU in order to optomise them. There is a Windows free SQL performance monitor that does this well enough but it only runs on one box and can't monitor all 25 servers. I haven't been able to figure this out in APM so far and haven't found anything that would plug into Orion yet. Nor have I found a template for such a thing. Anyone else trying to do something similar?
