sqlwatch

sqlwatch copied to clipboard

SQLWATCH 4.3: usp_sqlwatch_logger_disk_utilisation: sp_spaceused returns non-numeric data

2

**Describe the bug** ``` insert into @spaceused exec [dbo].[usp_sqlwatch_internal_foreachdb] @command = 'use [?]; exec sp_spaceused @oneresultset = 1;' , @snapshot_type_id = @snapshot_type_id , @calling_proc_id = @@PROCID , @databases = @databases...

kekcjkee

OliverUweHahn

SQLWATCH_health Extended Event cause CPU related performance issues

18

The problem has been noticed for sql instances hosting system databases where many queries use scalar UDF functions. After installing SQLWATCH, the CPU load increased approximately 10 times. After excluding...

mmbednarz

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

1

**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...

kekcjkee

**Did you check DOCS to make sure there is no workaround?** I went through the documentation and am using SQLWatchImport.exe to run the imports and to do the central repo...

monteroman

ben-thul

Minor grammar change

1

ben-thul

Is this project still alive?

3

Is this project still alive? What is the roadmap? Should I use a dead project for my new project?

j-dc

Visual Studio version and project compatibility.

3

**The issue** Marcin, I've been following your project for quite some time but even after reading the documentation and going through the source code and project files I can't for...

drgarciafuentes

usp_sqlwatch_internal_process_actions - @last_action_time (snapshot_time) in UTC, compared against non-UTC GETDATE()

1

**Describe the bug** `@last_action_time`, which comes from the most recent `snapshot_value` in `[dbo].[sqlwatch_logger_check_action]` for an action, is stored in UTC time. In the stored procedure `usp_sqlwatch_internal_process_actions`, to determine if it...

seanwhitent