Reviewing Max Server Memory and Lock Pages in Memory
A read-only query to review max server memory, min server memory and Lock Pages in Memory across many SQL Server instances, tested on 2019 and 2025.
THREADPOOL Waits: Reproducing Worker Thread Exhaustion in SQL Server
Reproducing THREADPOOL waits on SQL Server 2019: how max worker threads is sized, what new logins see, and finding the blocker through the DAC.
Proving the Restore, Part 4: Finding Backup Files Without xp_cmdshell
Everything so far assumed you already knew the path to a backup file. Automating any of it means the code has to find the files itself, and SQL Server gives you no documented way to…
What Reaches Outside Your Database? sys.dm_db_uncontained_entities
Every database likes to pretend it is self-contained. Then you restore it onto another instance and discover the stored procedure that queries a sister database, the synonym pointing at a linked server, the login-mapped user…
Can You Actually Downgrade to Standard Edition? Ask the Database First
Since SQL Server 2016 SP1, sys.dm_db_persisted_sku_features over-reports edition features. How to read it before downgrading to Standard.
Performance Counters Over Time: Making sys.dm_os_performance_counters Tell the Truth
Run this query on any SQL Server and look at the number it gives you for Batch Requests/sec:
|
1 2 3 4 5 6 7 |
SELECT [counter_name] , [cntr_value] FROM [sys].[dm_os_performance_counters] WHERE [counter_name] = N'Batch Requests/sec'; |
On a server that has been up for a few weeks you will get something like…