When a database file keeps getting smaller after you set its size, check Auto Shrink first. This post shows why a size you set later isn’t protected, then gives three checks: the database flag, jobs that shrink, and the default trace. It ends with the fix and the reason shrinking costs more than it saves.
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.
SPID, KPID and ECID in sys.sysprocesses: What They Mean
SPID, KPID and ECID are the three ID columns of sys.sysprocesses: the session, the Windows thread and the part of a parallel query. This post reads them for an idle session and for a query running in parallel, explains why KPID can be negative, and names the DMVs that give the same answers today.
SQL SERVER – Database Scoped Configurations – Query Optimizer Fixes
During recent SQL Server Performance Tuning Practical Workshop I receive following question about Query Optimizer Fixes.
SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard
The latest SQL Server Management Studio now includes the Performance Dashboard by default. Here is the free SSMS download link and a quick look at it.