How can we help you today? How can we help you today?

10 Expensive Queries For the Last Week

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?
UnicornsRreal
0

Comments

1 comment

Sort by
  • 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
    Chris Spencer
    0

Add comment

Please sign in to leave a comment.