Warning!!! Don't install 13.0.24 it needs to be pulled.
DonFerguson
Posts: 202 Silver 5
I just upgraded to 13.0.24 from 13.0.23 and the CPU on my repository host shot up from about 25% to 100%.
There is a new query introduced that has a "No Join Predicate" warning in the execution plan.
There is a new query introduced that has a "No Join Predicate" warning in the execution plan.
SELECT
[Leaf].[Id]
, [Leaf].[IdCollectionDate]
, [Leaf].[Cluster_Name]
, [Leaf].[Cluster_SqlServer_Name]
, [Leaf].[Cluster_SqlServer_Database_Name]
, [Leaf].[Cluster_SqlServer_Database_File_Name]
, [Leaf].[Cluster_SqlServer_Database_File_Type]
, [Leaf].[CollectionDate]
, [Leaf].[Cluster_SqlServer_Database_File_UsedSize]
FROM [data].[Cluster_SqlServer_Database_File_UnstableSamples_DateRange](@MinDate, @MaxDate, @MaxSamples, @EventCount) AS [Leaf]
WHERE
[Leaf].[Cluster_Name] = @Cluster_Name
AND
[Leaf].[Cluster_SqlServer_Name] = @Cluster_SqlServer_Name
Tagged:
Answers
I opened a ticket this morning about this, but am yet to hear anything back. I'll check this forum going forward before upgrading the next time.
We pulled this version and will investigate as a matter of priority.
We're aiming to release the fix early next week.
Apologies again!
We are on 13.0.25.22151 and are seeing the same issue periodically:
sp_whoisactive:
Appreciate we've been dealing with this on an internal ticket but just wanted to add an additional response here for anyone else who might be seeing an issue with high CPU after updating past 13.0.24
Our development team are currently investigating what they believe might be behind the CPU issue observed, although this may look similar to the query originally reported by Don on this forum post it is a different issue. If you find this forum post and are experiencing the same symptoms (on 13.0.25 or later) we would encourage you to log a ticket with support for us to gather some additional information for diagnosis.
Hope to have an additional update here soon with further information on this.
Tom Claringbold | Redgate Software
Have you visited our Help Center?
13.0.34 can be downloaded here, please let us know if any issues updating or if you believe the issue persists post update please let us know.
Tom Claringbold | Redgate Software
Have you visited our Help Center?