DarlingData

DarlingData copied to clipboard

#187 - Update sp_PressureDetector.sql

1

Modify query for total memory to support Azure SQL DB

samplesty

sp_PressureDetector for Azure SQL DB

3

sp_PressureDetector currently fails on Azure SQL DB because of the following reference: ``` SELECT CEILING ( dosm.total_physical_memory_kb / 1024. ) FROM sys.dm_os_sys_memory AS dosm ``` Would it be possible to...

samplesty

**Version of the script** @version = '3.33', @version_date = '20220701'; **What is the current behavior?** @version = '3.33', @version_date = '20220701'; **If the current behavior is a bug, please provide...

genetsmartx

Hi Erik, I would like to thank you for the great stored procedure sp_HumanEvents which has been helping me a lot on my day by day job. Permit me to...

UriDimant

sp_humanevents

1

**Which script is your question about?** Script Name: sp_humanevents Is there a way to make this work in RDS SQL Server?

stefanwochen

Why are you so cute?

2

I'm having a serious issue with this.

drewfurgiuele

sp_QuickieStore: Add the ability to sort by total wait time and by plan count.

8

**Is your feature request related to a problem? Please describe.** At one point in my life, I had quite a good grasp of the official documentation for Query Store. Every...

ReeceGoding

sp_QuickieStore: Correct UTC offsets

2

Closes #449 by switching to use `SWITCHOFFSET` rather than our old arithmetic tricks with `@utc_offset_minutes`. I'll spin up some Docker containers on different time zones to provide more evidence that...

ReeceGoding

Is it misleading that first_execution_time returns a +00:00 DATETIMEOFFSET?

2

**Version of the script** Pretty sure this has always been the case. **What is the current behavior?** I spend most of my time in the GMT+0 timezone, which is the...

ReeceGoding

sp_QuickieStore: Add a way to check for queries that have recently changed in performance

1

**Is your feature request related to a problem? Please describe.** This is absolutely something that I would use. I frequently use Query Store to check how my instance/database/query has changed...

ReeceGoding