Red Gate Monitor SQL Server Repository Servers can't keep up queries after applying 14.0.64. from 14.0.62. Basically installing it made Redgate Monitor unusable for me.
A primary query that is generating on over abundance of memory grants is the following:
SELECT
[Leaf].[Id]
, [Leaf].[IdCollectionDate]
, [Leaf].[Cluster_Name]
, [Leaf].[Cluster_SqlServer_Name]
, [Leaf].[Cluster_SqlServer_Agent_Job_Name]
, [Leaf].[Cluster_SqlServer_Agent_Job_History_Id]
, [Leaf].[Cluster_SqlServer_Agent_Job_History_RunDate]
FROM [data].[Cluster_SqlServer_Agent_Job_History_Keys_DateRange](@MinDate, @MaxDate, @MaxSamples) AS [Leaf]
A rollback to 14.0.62 resolved the issue.
@Redgate Development, please address before your next update.
Red Gate Monitor SQL Server Repository Servers can't keep up queries after applying 14.0.64. from 14.0.62. Basically installing it made Redgate Monitor unusable for me.
A primary query that is generating on over abundance of memory grants is the following:
SELECT
[Leaf].[Id]
, [Leaf].[IdCollectionDate]
, [Leaf].[Cluster_Name]
, [Leaf].[Cluster_SqlServer_Name]
, [Leaf].[Cluster_SqlServer_Agent_Job_Name]
, [Leaf].[Cluster_SqlServer_Agent_Job_History_Id]
, [Leaf].[Cluster_SqlServer_Agent_Job_History_RunDate]
FROM [data].[Cluster_SqlServer_Agent_Job_History_Keys_DateRange](@MinDate, @MaxDate, @MaxSamples) AS [Leaf]
A rollback to 14.0.62 resolved the issue.
@Redgate Development, please address before your next update.