Read running, runnable, and suspended SQL Server requests, inspect task states, and compare scheduler queues before diagnosing CPU pressure.
SQL SERVER – Performance Statistic Collection – Notes from the Field #018
Good tuning starts with good numbers. In Notes from the Field #018, David Klee explains Performance Statistic Collection and how DBAs should gather server data.
SQL SERVER – 28 Links for Learning SQL Wait Stats from Beginning
Is my SQL Wait Stats series still relevant? Yes. I answer reader questions and share 28 links for learning SQL Wait Stats from the very beginning.
Indexing JSON Properties With Computed Columns
Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.
SQL SERVER – SafePeak SQL Server Acceleration Software Gets an Upgrade
SafePeak, the SQL Server acceleration software that caches queries without code changes, gets a new version and launches on Amazon Cloud Marketplace.
DOP Feedback: Letting SQL Server Lower Parallelism by Itself
Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.
Big Data – Real-Time Analytics Performance with ClustrixDB
I ran a join and aggregate workload on ClustrixDB to see how much real-time analytics performance a scale-out NewSQL database can really deliver.