Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLWATCH 4.3: Is [dbo].[sqlwatch_config_snapshot_type].[collect] working? #449

Open
kekcjkee opened this issue Jul 7, 2022 · 1 comment

Comments

@kekcjkee
Copy link
Contributor

kekcjkee commented Jul 7, 2022

Describe the bug
I have set column "collect" to 0 for some snapshots. For example: Disk Utilisation Table, Disk Utilisation Database.
But I can't find the part of the code where it is used. Job: SQLWATCH-LOGGER-DISK-UTILISATION anyway collects data.

I have VLDB which has size about 30TB. So this job takes a very long time. Sometimes it is reason for blocking user's query.

To Reproduce
Steps to reproduce the behavior:
1.
UPDATE [dbo].[sqlwatch_config_snapshot_type] SET collect = 0 WHERE [snapshot_type_id] in (2, 22)
2. Look on job SQLWATCH-LOGGER-DISK-UTILISATION

Expected behavior
I want to understand how is working [dbo].[sqlwatch_config_snapshot_type].[collect].

Screenshots
image

Windows Server (please complete the following information):

  • OS Version: [Windows Server 2022 Datacenter 10.0]

SQL Server (please complete the following information):

  • SQL Version: [Microsoft SQL Server 2019 (RTM-CU16-GDR) (KB5014353) - 15.0.4236.7 (X64)]
  • SQL Edition: [Developer]

SQL Server Management Studio (SSMS -> about -> copy info):
SQL Server Management Studio 15.0.18358.0
SQL Server Management Objects (SMO) 16.100.44091.28
Microsoft Analysis Services Client Tools 15.0.19260.0
Microsoft Data Access Components (MDAC) 10.0.14393.0
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.14393

SQLWATCH version (from DACPAC or from sysinstances)

  • 4.3.0.0
@marcingminski
Copy link
Owner

This should work if it doesn't it's probably a bug.
I'd probably recommend disabling the job in the first place. This flag/switch was designed for job-less operations i.e. broker or a collector app.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants