First Responder Kit
Job details
| Name: | First Responder Kit | |
| Platform: | Sqlserver | |
| Category: | Performance | |
| Description: | Checks if and where the procedures sp_BlitzBackups, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock and sp_BlitzWho (related to Brent Ozar First Responder Kit scripts) are installed (Install-Core-Blitz-No-Query-Store.sql). | |
| Long description: | Checks if and where the procedures sp_BlitzBackups, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock and sp_BlitzWho (related to Brent Ozar First Responder Kit scripts) are installed. | |
| Version: | 1.4 | |
| Default schedule: | 0 6 6 * | |
| Requires engine install: | Yes | |
| Compatibility tag: | .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005′ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ | engine_edition = ‘Azure SQL Managed Instance’)] |
Parameters
| Name | Default value | Description |
|---|---|---|
| ignore databases | model | List of databases (separated by comma) which will be ignored. You can use % (percent sign) to represent wild card characters. |
| return status when not installed | 0 | Return status value (ALARM – 2, WARNING – 1, or OK – 0) when First Responder Kit procedures (related to Brent Ozars scripts) are not installed. |
| return status when multiple installations | 1 | Return status value (ALARM – 2, WARNING – 1, or OK – 0) when multiple First Responder Kit procedures are installed. |
Job Summary
- Purpose: This monitoring job is designed to check the installation and distribution of the First Responder Kit by Brent Ozar in Microsoft SQL Server instances.
- Why: The job ensures that essential performance tuning procedures, such as sp_BlitzBackups, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, sp_BlitzLock, and sp_BlitzWho, are installed correctly and not duplicated within the system. These procedures are critical for identifying performance issues, security risks, and overall system health diagnostics.
- Manual Checking: Although specific SQL commands are provided within the job’s implementation, a manual check can be carried out using the following query, which lists all instances of the mentioned procedures:
bc. select db_name as “Database”, sch_name as “Schema”, obj_name as “Object Name”, obj_type as “Object Type”, create_date as “Creation Date”, version as “Version”, versiondate as “Version Date” from tab_inst_check_blitz order by obj_name, create_date desc;
Job Details
Target Instances
- This job targets SQL Server instances with major version later than 2005, including both Microsoft SQL Server and Azure SQL Managed Instances having SQL Engine installed.
Dependencies
| Object | Object Type | Description | Clean-up on Fail |
|---|---|---|---|
| proc_inst_check_blitz | Main procedure | Ensures core functionalities | true |
| tab_inst_check_blitz | Configuration statistics table | Stores procedure installation details | true |
Job Execution
- The job involves creating tables and stored procedures to check and record instances of performance procedures installation as part of Brent Ozar’s First Responder Kit.
- If the Blitz procedures are found to not be installed or multiple installations exist, appropriate warning statuses are returned.
- The job also involves data cleaning steps to manage data and execution flow effectively.
Reporting
- Report Title: Installation check for sp_BlitzLock
- Shows detailed information regarding the Blitz procedures installed across databases, including schema, object name, type, creation date, and version details.
- Report Query:
bc. select db_name as “Database”, sch_name as “Schema”, obj_name as “Object Name”, obj_type as “Object Type”, create_date as “Creation Date”, version as “Version”, versiondate as “Version Date” from tab_inst_check_blitz order by obj_name, create_date desc;
Job Configuration
- Default Schedule: Runs monthly
- Dependencies are managed to ensure complete and accurate execution, with cleanups on fail enabled for safety and data consistency.
In conclusion, this monitoring job by dbWatch Control Center is essential for ensuring that performance tuning tools in SQL Server environments are properly installed and monitored to prevent and address issues proactively.