10 Expensive Queries For the Last Week

UnicornsRreal

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?

Chris Spencer

Hi

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:

WHERE utils.TicksToDateTime(data.Cluster_SqlServer_TopQueries_Instances_View.IdCollectionDate) > DATEADD(day, -7, GETDATE())

It might take a bit of experimentation to get this working.

Regards
Chris