[BUG] - Unable to Upgrade Server

[carlei1978]

Component

Full Dashboard

Performance Monitor Version

2.8.0

SQL Server Version

Microsoft SQL Server 2022 (RTM-CU16) (KB5048033) - 16.0.4165.4 (X64) Nov 6 2024 19:24:49 Copyright (C) 2022 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2022 Datacenter 10.0 (Build 20348: ) (Hypervisor)

Windows Version

Windows Server 2022 DataCenter (10.0.20348)

Describe the Bug

Unable to successfully upgrade the server from v2.4.1 due to a timeout whilst executing Batch 6 in the file 98_validate_installation.sql

This has affected all attempted upgrades since v2.4.1 on this particular server. Other servers upgrade fine so believe this is an issue to do with data volumes.

Steps to Reproduce

1. Open the Full Dashboard
2. Right Click a Server and click Edit Server
3. Click Check for Updates button
4. Click Upgrade Now
   I have also tried unticking "Run validation after install" in Advanced Options but the error remains the same (perhaps this is another bug if this should stop the 98_validate.install.sql file from being executed?)

Expected Behavior

The server to be upgraded to the expected version

Actual Behavior

The upgrade reports a failure and remains listed at v2.4.1

Error Messages / Log Output

================================================================================
Performance Monitor Installation Report
================================================================================

INSTALLATION SUMMARY
--------------------------------------------------------------------------------
Status:              FAILED
Start Time:          2026-04-23 08:09:05
End Time:            2026-04-23 08:14:17
Duration:            312.8 seconds
Files Executed:      53
Files Failed:        1

SERVER INFORMATION
--------------------------------------------------------------------------------
Server Name:         MyServer
SQL Server Edition:  Standard Edition (64-bit)

SQL Server Version:
  Microsoft SQL Server 2022 (RTM-CU16) (KB5048033) - 16.0.4165.4 (X64)
  Nov  6 2024 19:24:49
  Copyright (C) 2022 Microsoft Corporation
  Standard Edition (64-bit) on Windows Server 2022 Datacenter 10.0 <X64> (Build 20348: ) (Hypervisor)

INSTALLER INFORMATION
--------------------------------------------------------------------------------
Installer Version:   2.8.0
Working Directory:   C:\Users\myuser\AppData\Local\PerformanceMonitorDashboard\current
Machine Name:        mymachine
User Name:           myuser

ERRORS
--------------------------------------------------------------------------------
File: 98_validate_installation.sql
Error: Batch 6 failed:
PRINT '================================================================================';
PRINT 'Performance Monitor Installation Validation';
PRINT '================================================================================';
PRINT '';

/*
Step 1: Check for errors in collection_log
*/
PRINT 'Step 1: Checking config.collection_log for ERROR status...';
PRINT '';

IF EXISTS (SELECT 1/0 FROM config.collection_log WHERE collection_status = N'ERROR')
BEGIN
    PRIN...

================================================================================
Generated by Performance Monitor Installer
Copyright (c) 2026 Darling Data, LLC
================================================================================

Screenshots

No response

Additional Context

Below are the sizes of the tables in the database being upgraded for context:

TableName	SchemaName	rows	TotalSpaceKB	TotalSpaceMB	UsedSpaceKB	UsedSpaceMB	UnusedSpaceKB	UnusedSpaceMB
query_stats	collect	7173519	14866920	14518.48	14749064	14403.38	117856	115.09
query_store_data	collect	4442092	9617768	9392.35	9421512	9200.7	196256	191.66
procedure_stats	collect	371429	1983784	1937.29	1970200	1924.02	13584	13.27
query_stats_latest_hash	collect	3661895	585368	571.65	579016	565.45	6352	6.2
default_trace_events	collect	8208180	426864	416.86	377936	369.08	48928	47.78
trace_analysis	collect	729599	338144	330.22	310064	302.8	28080	27.42
query_snapshots_20260420	collect	7299	226336	221.03	226240	220.94	96	0.09
query_snapshots_20260421	collect	5903	175664	171.55	175560	171.45	104	0.1
query_snapshots_20260417	collect	3821	156960	153.28	156872	153.2	88	0.09
query_snapshots_20260422	collect	5220	155152	151.52	155072	151.44	80	0.08
query_snapshots_20260416	collect	2159	66208	64.66	66168	64.62	40	0.04
file_io_stats	collect	395031	61528	60.09	54424	53.15	7104	6.94
query_snapshots_20260423	collect	1672	50672	49.48	50552	49.37	120	0.12
query_snapshots_20260414	collect	935	28752	28.08	28656	27.98	96	0.09
perfmon_stats	collect	548280	18392	17.96	18136	17.71	256	0.25
query_store_data_latest_hash	collect	293812	17048	16.65	16952	16.55	96	0.09
query_snapshots_20260418	collect	763	16912	16.52	16864	16.47	48	0.05
query_snapshots_20260415	collect	590	16656	16.27	16568	16.18	88	0.09
procedure_stats_latest_hash	collect	105395	15256	14.9	15120	14.77	136	0.13
spinlock_stats	collect	317347	13912	13.59	13728	13.41	184	0.18
wait_stats	collect	321118	12568	12.27	12336	12.05	232	0.23
collection_log	config	195729	12168	11.88	10520	10.27	1648	1.61
blocking_BlockedProcessReport	collect	474	10176	9.94	8752	8.55	1424	1.39
query_snapshots_20260413	collect	259	8224	8.03	8072	7.88	152	0.15
blocked_process_xml	collect	418	6928	6.77	6696	6.54	232	0.23
memory_clerks_stats	collect	136191	5272	5.15	5016	4.9	256	0.25
database_size_stats	collect	32951	3080	3.01	2888	2.82	192	0.19
deadlocks	collect	70	1984	1.94	1656	1.62	328	0.32
latch_stats	collect	40746	1432	1.4	1288	1.26	144	0.14
BlitzLockFindings	collect	1306	1016	0.99	696	0.68	320	0.31
memory_pressure_events	collect	28462	784	0.77	552	0.54	232	0.23
critical_issues	config	498	752	0.73	400	0.39	352	0.34
cpu_utilization_stats	collect	21539	728	0.71	528	0.52	200	0.2
plan_cache_stats	collect	15071	664	0.65	456	0.45	208	0.2
query_snapshots_20260412	collect	0	496	0.48	488	0.48	8	0.01
database_configuration_history	config	4505	472	0.46	272	0.27	200	0.2
waiting_tasks	collect	8661	408	0.4	256	0.25	152	0.15
deadlock_xml	collect	8	392	0.38	264	0.26	128	0.13
cpu_scheduler_stats	collect	5020	336	0.33	208	0.2	128	0.13
collection_schedule	config	34	288	0.28	64	0.06	224	0.22
running_jobs	collect	3909	272	0.27	176	0.17	96	0.09
server_configuration_history	config	97	280	0.27	64	0.06	216	0.21
session_stats	collect	3370	280	0.27	160	0.16	120	0.12
memory_stats	collect	3379	264	0.26	192	0.19	72	0.07
tempdb_stats	collect	3370	264	0.26	152	0.15	112	0.11
server_info_history	config	41	216	0.21	48	0.05	168	0.16
HealthParser_PendingTasks	collect	136	200	0.2	32	0.03	168	0.16
memory_grant_stats	collect	3380	200	0.2	144	0.14	56	0.05
query_snapshots_20260419	collect	7	208	0.2	168	0.16	40	0.04
SqlServerVersions	dbo	461	200	0.2	80	0.08	120	0.12
ignored_wait_types	config	124	144	0.14	32	0.03	112	0.11
trace_flags_history	config	4	144	0.14	32	0.03	112	0.11
blocking_deadlock_stats	collect	2288	136	0.13	96	0.09	40	0.04
critical_issues	config	431	72	0.07	16	0.02	56	0.05
HealthParser_CPUTasks	collect	6	72	0.07	16	0.02	56	0.05
HealthParser_MemoryConditions	collect	40	72	0.07	16	0.02	56	0.05
HealthParser_SevereErrors	collect	23	72	0.07	16	0.02	56	0.05
installation_history	config	10	72	0.07	16	0.02	56	0.05
server_properties	collect	1	72	0.07	16	0.02	56	0.05
HealthParser_Blocking	collect	0	0	0	0	0	0	0
HealthParser_Deadlocks	collect	0	0	0	0	0	0	0
HealthParser_IOIssues	collect	0	0	0	0	0	0	0
HealthParser_MemoryBroker	collect	0	0	0	0	0	0	0
HealthParser_MemoryNodeOOM	collect	0	0	0	0	0	0	0
HealthParser_SchedulerIssues	collect	0	0	0	0	0	0	0
HealthParser_SignificantWaits	collect	0	0	0	0	0	0	0
HealthParser_SystemHealth	collect	0	0	0	0	0	0	0
HealthParser_WaitsByCount	collect	0	0	0	0	0	0	0
HealthParser_WaitsByDuration	collect	0	0	0	0	0	0	0

I am running the Balanced Collector schedule with default retention periods.

I have manually executed the script in SSMS successfully - takes around 9 minutes to complete.

[erikdarlingdata]

Hello @carlei1978 - thanks for reporting this! I've made some changes to hopefully get anyone else needing to do this upgrade around the problem.