Responce Time Lowest 10%
We are working to find out if our DBA's have made a negative impact on our application or not
One of the ways we are looking to determine this is to remove the Slowest 10% from our numbers as they are considered outliers Is there a way to do this?
Hi. So - you want to find the slowest database statements?
What you can do is open the Database dashlet for a certain time period, e.g: last hour. It will show you the statements being executed. Then you can specify a comparision timeframe and set that to e.g: same hour of last week. The dashlet will then show you the difference in both execution count but also timing
If you want to learn more about the comparison feature check out Session Comparison
Before going into individual statements you may want to start by comparing overall trends in time spent in database vs. time spent in application code. You can for instance look at the Layer Breakdown and look for the time spent in the ADO.NET/JDBC API. If that has changed since the DBAs made their changes towards spending more time in these database APIs (=Layers) you know that their changes impacted your application
Andi
