Comments
-
https://thwack.solarwinds.com/product-forums/database-performance-analyzer-dpa/f/forum/365/custom-report---top-sql-for-database-user I just modified it as I see that all tables in DPA database have schema called "ignite". It's working as of 8/6/2021. declare @from_date varchar(16) = '2021-05-03 00:00', @to_date varchar(16)…
-
Thank you for posting this code. It was super useful. I just modified it as I see that all tables in DPA database have schema called "ignite". It's working as of 8/6/2021. declare @from_date varchar(16) = '2021-05-03 00:00', @to_date varchar(16) = '2021-08-07 00:00', @iname varchar(50) = '<INSERT SERVER NAME>', @dbname…
