Doing a server-wide health check (sp_blitz)

1. Install latest First Responder Kit (firstresponderkit.org) probably in DbaTools
2. Run the following
   sp_Blitz @CheckServerInfo=1,@CheckUserDatabaseObjects=0; Change @CheckUserDatabaseObjects to 1, to include databases that you control
3. Inspect results 1 to 50 are things we really care about. URLs give a lot more info
4. Start taking notes, to summarise current issues. Brent uses Typora. Link]
5. INFO - Can write sp_Blitz to table to get a ongoing log: sp_Blitz @OutputDatabaseName=‘DbaTools’,@OutputSchemaName=‘dbo’,@OutPutTableName=‘Blitz’
   Only the database needs to be created.
   Useful to tell what has changed over the last year. e.g. on 1-Jan - 6 servers with 170 P1 issues. 31-Dec, 17 servers with 52 P1 issues.
6. INFO - Can get sp blitz to export to markdown
   sp_blitz @OutputType=‘markdown’ Markdown format, Nice for stackoverflow