Sorgu 0x815EA28694861835

(@name nvarchar(128),@schema nvarchar(128),@like nvarchar(520),@FromUtc datetime,@ToUtc datetime,@Top int)WITH o AS (
        SELECT mo.ServerID, ms.ServerName, mo.DatabaseName, mo.SchemaName, mo.ObjectName, mo.ObjectType, mo.ModifyDateUtc
        FROM perf.MetaObject AS mo
        JOIN DBA.ManagedServers AS ms ON ms.ServerID = mo.ServerID AND ISNULL(ms.IsActive, 0) = 1
        JOIN DBA.MonitoredDatabase AS md ON md.ServerID = mo.ServerID AND md.DatabaseName = mo.DatabaseName AND md.IsActive = 1
        WHERE mo.IsDeleted = 0 AND mo.ObjectType IN ('P ', 'FN', 'IF', 'TF', 'V ', 'TR')
          AND ((@name IS NOT NULL AND mo.SchemaName = @schema AND mo.ObjectName = @name)
               OR (@name IS NULL AND mo.ObjectName LIKE @like ESCAPE N'\'))
    )
    SELECT TOP (@Top) o.ServerID AS ServerId, o.ServerName, o.DatabaseName, o.SchemaName, o.ObjectName, RTRIM(o.ObjectType) AS ObjectType,
           o.ModifyDateUtc, ISNULL(a.Statements, 0) AS Statements, ISNULL(a.Executions, 0) AS Executions, ISNULL(a.TotalDurationMs, 0) AS TotalDurationMs
    FROM o
    OUTER APPLY (SELECT COUNT(DISTINCT q.query_hash) AS Statements, SUM(q.Executions) AS Executions, SUM(q.TotalDurationMs) AS TotalDurationMs
                 FROM perf.QueryDailyStats AS q
                 WHERE q.StatDateUtc >= @FromUtc AND q.StatDateUtc <= @ToUtc
                   AND q.ServerID = o.ServerID AND q.DatabaseName = o.DatabaseName
                   AND q.ObjectName = CONCAT(o.SchemaName, N'.', o.ObjectName)) AS a
    ORDER BY ISNULL(a.TotalDurationMs, 0) DESC, o.ObjectName, o.DatabaseName