Monitoring Space Used by Query Store

Last week I presented a session on Query Store and when talking about the settings I mentioned that monitoring space used by Query Store is extremely important when you first enable it for a database.  Someone asked me how I would do that and as I provided an explanation I realized that I should document […]

AUTO_CLOSE and the SQL Server ERRORLOG

Today I opened up a SQL Server ERRORLOG and saw these two messages repeated every 20 seconds or so: Starting up database ‘AdventureWorks2014′. CHECKDB for database ‘AdventureWorks2014′ finished without errors on 2015-08-23 02:15:08.070 (local time).  This is an information message only; no user action required. When you initially see these two messages repeated over and […]