Posts
First Responder Kits Notes
SQL2019A Health Check By User, Date
sp_Blitz Results The server hasn’t had backups recently Someone’s using the Administrator account and freeing the plan cache No alerts of failsafe operator set up This server hasn’t felt the love of a database adminsitrator recently
Posts
First Responder Kits Notes
Doing a server-wide health check (sp_blitz) Install latest First Responder Kit (firstresponderkit.org) probably in DbaTools Run the following sp_Blitz @CheckServerInfo=1,@CheckUserDatabaseObjects=0; Change @CheckUserDatabaseObjects to 1, to include databases that you control Inspect results 1 to 50 are things we really care about. URLs give a lot more info Start taking notes, to summarise current issues. Brent uses Typora. Link] INFO - Can write sp_Blitz to table to get a ongoing log: sp_Blitz @OutputDatabaseName=‘DbaTools’,@OutputSchemaName=‘dbo’,@OutPutTableName=‘Blitz’