Skip to content

[BUG] Install error on 09_collect_query_store.sql #446

Closed

Description

@luca-domenichini

Component

Installer (GUI)

Performance Monitor Version

2.1.0

SQL Server Version

SQL Server 2022 StdDev 16.0.4230.2

Windows Version

Win11 25H2 26200.7840

Describe the Bug

Running GUI installer for the first time.
Got this:

Executing 09_collect_query_store.sql...
[ERROR] 09_collect_query_store.sql - FAILED: Batch 4 failed:
ALTER PROCEDURE
    collect.query_store_collector
(
    @debug bit = 0 /*Print debugging information*/
)
WITH RECOMPILE
AS
BEGIN
    SET NOCOUNT ON;
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

    DECLARE
        @rows_collected bigint = 0,
        @start_time datetime2(7) = SYSDATETIME(),
        @last_collection_time datetimeoffset(7) = NULL,
        @collection_interval_minutes integer = NULL,
        @cutoff_time datetimeoffset(7) = NULL,
        @sql nvarchar(max... [truncated, total length: 28887]

Original error: Invalid column name 'collect_query'.
Invalid column name 'collect_plan'.

Installation completed anyway:

Image

Full install log:
PerformanceMonitor_Install_LAPTOP-K4QM1LML_SQL2022_20260306_092013.txt

Steps to Reproduce

  1. open and run installer

Expected Behavior

  1. do not get errors

Actual Behavior

  1. errors are raised

Error Messages / Log Output


Screenshots

No response

Additional Context

No response

Activity

  1. erikdarlingdata commented on Mar 6, 2026

    @erikdarlingdata
    Owner

    Dupe of #409

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions