DBCC SQLPERF can report log usage or reset cumulative wait and latch statistics. I separate reporting from resetting the baseline.
SQL SERVER – Cluster Patching: The RPC Server is Too Busy to Complete This Operation
A cluster patch failed with The RPC server is too busy. The real cause was a stopped Remote Registry service on the other node, and why it was off.
Azure SQL Hyperscale: When the Database Outgrows One Server
Evaluate Hyperscale by separating compute and storage needs, testing read replicas, and checking migration, recovery, and current limits.
SQL Server – Configuration Manager Console Running Very Slow and Time Out
A Compatibility Level change helped one customer’s Configuration Manager Console. I keep that incident separate from a universal repair recommendation.
SQL SERVER – SQL Agent Not Starting. The EventLog Service has Not Been Started
After a server hardening script, a client’s SQL Agent would not start because the Eventlog Service had not been started. Here is how we traced and fixed it.
How to Show Results of sp_spaceused in a Single Result? – Interview Question of the Week #135
How do you show results of sp_spaceused in a single result? My co-interviewer asked this. I think it is a poor interview question, but here is the answer.
SQL SERVER – How to Clear Plan Cache with Database Scoped Configuration?
I can Clear Plan Cache for the current database through database-scoped configuration. I verify the context before considering eviction.