• DBA

    How to use Blitz Brent Ozar First Responder Kit

    How to use Blitz Brent Ozar First Responder Kit This post is in my draft very long time, I have not get good time to write in better way. I will be updating this periodically. You can download it from website https://www.brentozar.com/first-aid/, unzip it and run all SP starts with SP*. I have learnt most from GitHub https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit I have used DBAData database to create all scripts and load data. ====================== SP_Blitz — Easy way to get server level setting and health check   --sp_Blitz use DBAData go /*Check only the priority id up to 50*/ exec sp_Blitz @IgnorePrioritiesAbove = 50-- Default Important parameters –@Help = 1 — explains the…