1 Reply Latest reply on Apr 20, 2009 9:25 AM by Yann

    Network Wide Availability & Response Time Graphs, SQL Query, Disk Queue Length - NPM 9.1

    skierjmh

      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.