ziv

Hi darichar​ , I just found the problem! In the code here, I did not include 3 lines of code that I have been trying to use. The reason I did not include them, was that they were commented out in the code. I have made a code to pull all 4 CPU Time values, and created two metrics for them. One for User CPU Time, and one for…

Hi, Thanks for the input! I think I will do just that!

Thank you very much! While I ended up with some minor changes to the code (among the changes, we don't exclude anything) , your tip and code were exactly what I needed to get this done!!! select SST.datehour, SNT.name, sum(SST.timesecs) as 'timesecs' from ( select top 15 ADT.sqlhash, ADT.sum_secs as timesecs from ( -- full…

Hi, I'm not sure what you mean with the historical charts, but likely no. I want to check how many times per hour each statement was ran, and by what user, and have hourly averages of this, from a week. To do this, I need to know by whom or from what machine was each SQL statement executed.

Hi darichar​ , thanks for your input. The user I configured for DPA has full access to the mentioned database. I have noted a difference between my query and yours, I actually employ a sub-query inside the derived table expression. (The "MeasureID = ..." in the where clause) Can you perform a test with that? Thanks, Shay.

Does not take into account all reserved pages, in the calculation of free space for data segments.

mesverrum​ , mandevil​ Thank you both for your answers! -- Ziv.