What we've found is that this resource causes the AVDL and ARDQL to go through the roof on our SQL server. Normal operation the lengths are in the 10-20's, when the web server is trying to populate that resource (7day at one hour intervals), it rockets up to 150-500 and takes 3-4min to load, for a query on two nodes. This wasn't the case in 9.0. Anyone else seeing this? Did this resource somehow change? Is there a way to see what the actual query is that it is running? This is the only resource that I've seen do this, none of the other ones have caused it.
Is there a way to see what the actual query is that it is running?
You can run a SQL Profiler trace to show which query are run while you refresh the view.