Max server memory set too low can stop SQL Server from answering normal connections. This post shows how to connect through the Dedicated Administrator Connection, raise the value with sp_configure and start the service when it will not start.
Snowflake – Query Result from Cache or Disk
Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.
Reading Performance Counters in T-SQL Without Misreading Them
Read SQL Server performance counters with two timed samples, a proper ratio base, and a concise workload and memory dashboard.
MySQL Performance – Five Configuration Topics with Version Limits
A MySQL Config File needs settings matched to its server version and workload. I measure pressure before changing a parameter.
MySQL Performance – Slow Query and innodb_buffer_pool_size
A small innodb_buffer_pool_size contributed to one customer slow MySQL query. The comparable SQL Server workload ran quickly.
SQL SERVER – Dirty Pages Clean Pages and the Correct Cache Commands
Clean Pages have no outstanding data-file write, while dirty pages contain unwritten changes. A customer asked which state was better.
Get Memory Details – SQL in Sixty Seconds #165
My blog post SQL SERVER – 3 Queries to Detect Memory Issues. Lots of people wanted me to create a video on this topic – get memory details.