10 Expensive Queries For the Last Week
UnicornsRreal
Posts: 9
Hi
Is there away to get the most expensive queries for the last 7 days every hour?
Can this be pulled from the database some how?
Is there away to get the most expensive queries for the last 7 days every hour?
Can this be pulled from the database some how?
Comments
The repository is not documented sorry but it should be possible to get information from the following three views.
[data].[Cluster_SqlServer_TopQueries_UnstableSamples_View]
[data].[Cluster_SqlServer_TopQueries_Instances_View]
[data].[Cluster_SqlServer_TopQueries_StableSamples_View]
The function utils.TicksToDateTime() can be used to filter by date. Using something like this:
It might take a bit of experimentation to get this working.
Regards
Chris
Test Engineer
Red Gate