Tyler Samples

#187 - Update sp_PressureDetector.sql

1

Modify query for total memory to support Azure SQL DB

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

Capture Metrics from Readonly Replica on Azure SQL DB

4

Some tiers of Azure SQL DB come with a read-only replica which appears to share the same server and DB name as the primary and is only connected to via...

Write-SqlTableData doesn't clear Write-Progress bar

1

Writing data to a table with Write-SqlTableData creates permanent Write-Progress bars that never clear. There is likely a missing call to Write-Progress with the -Complete flag in order to close...