Database Performance Analyzer

Alerts with Assigned Contacts Report
Azure Elastic Pool CPU and Memory Metrics for SQL Database
Azure SQL Database Metrics (Additional)
Blocking from Specific Machine
CONSW Column Definition
CPU Alert with Top 10 Memory/CPU consuming queries
CPU Utilization for Azure SQL Database using vCore Purchasing Model
CPU Utilization for Postgres on Linux/Unix
Collect Azure SQL Elastic Pool Metrics
Current Alert Status
Current Blocking Sessions Query
Custom Alert - AG Data Loss Alert
Custom Alerts
Custom Metric - Oracle Standby Database Log Apply Drift Metric
Custom Metrics
Custom Queries
DB2 Database Growth
DB2 Database Size (MB)
DB2 Error Log
DPA Metric query collector report Day tables.
DPA Metric query collector report Detail tables.
DPA Repository Query to find Blocking Sessions
Database File Growths Query
Database Instance Availability Report
Database Job Status Query
Database Performance Analyzer
Database SQL Alert
Database Wait Time Anomaly
Db2 Diag Log Errors
Disk Free Space Monitor for SQL Server
Error from error log containing actual error text
Execution Plan Change
Execution Plan Change with Worse Performance
Global Deadlock Report
Global Index Advisor with Time Savings
Global Instance Health Check
Global Missing Indexes Alert by Time Savings
Global Monitoring Overview
Global Resource Metric Report
Global SQL by Top Root Blocker Impact
Global Search and Display of Queries
Global Top SQL Across All Monitored Instances
Global Top SQL by any Metric
Global Top Waits Across All Monitored Instances
High Wait Time
Historical Wait Times for All Instances
Job Failures (Last 24 Hours) Query
Last 10 Login Failures Query
Long Running Queries
Long Running Queries Alert
MySQL Blocking
MySQL CPU and Memory Utilization
MySQL Database Growth
MySQL Database Size Collector
MySQL Instance is in Read Only Mode
MySQL Long Running Query
MySQL Max Connection Percent
MySQL Table Growth
MySQL Table Size Collector
Oracle - Collect Bind Value Samples
Oracle - Collect Tablespace Sizes
Oracle ASM Disk Free Space
Oracle Archive Log Destination Status
Oracle Archiver Errors
Oracle Block Corruption
Oracle Data Guard / Standby Database Lag
Oracle Data Guard Log Apply Gap Metric
Oracle Database not open Read Write
Oracle Flash Recovery Area Free Space
Oracle Hard Parses per Second
Oracle Invalid Materialized Views
Oracle Invalid Objects
Oracle Job Failures
Oracle Locking Problems
Oracle Login Failures
Oracle Long Running Jobs
Oracle Long Running Query
Oracle Max Locks
Oracle Max Sessions
Oracle Monitoring - Collecting Service Name (and others)
Oracle PGA Utilization
Oracle RMAN Backup Failure
Oracle Table Fragmentation
Oracle Tablespace Freespace
Oracle Tablespace Growth Percent
Page Life Expectancy (PLE) Alert - Ignore timeframe with UPDATE STATS or BACKUP running
Plan Change Caused More Wait Times
PostgreSQL Deadlock Alert
PostgreSQL Transaction Wraparound Alert
Postgres CPU and Memory Utilization
Postgres Database State
Postgres Dead Tuple Percentage (Table Bloat)
Postgres Disk Space for Linux/Unix O/S
Postgres Instance is in Read Only Mode
Postgres Max Connection Percent
Postgres Replication Lag
Postgres Total WAL Files
Postgres Unarchived WAL File Percent
Postgres Unarchived WAL Files
Power BI Templates
Query Execution Anomaly (Regression)
Query Execution Count Anomaly
Query Hash Execution Percent Increase
Query Regression based on Logical Reads per Execution
Remove Future Data from DPA Repository
Resource Metric Baseline
Resource Metric Report
Resource Metric Report (Min, Max, Avg)
SQL SERVER - Deadlock Full Report
SQL Server - Alert for when an object gets created, modified or dropped
SQL Server - O/S CPU Utilization on Linux Server
SQL Server Agent Not Running
SQL Server Alert Starter Set for DPA
SQL Server Custom Error Log Alert
SQL Server Database Corruption
SQL Server Database File Size Changes
SQL Server Database Free Space
SQL Server Database Growth
SQL Server Database Job Status
SQL Server Database Offline
SQL Server Database Size Collector
SQL Server Error Log Size Check and Cycle Option
SQL Server File Auto-Growth Exceeds Drive Free Space
SQL Server Fragmentation
SQL Server Free Disk Space Alert using PowerShell
SQL Server Indexes Not Used
SQL Server Job Failure
SQL Server Locking Problems
SQL Server Long Running Query (optional kill session)
SQL Server Object Changes (Detailed Auditing)
SQL Server Object Changes (Simple)
SQL Server Oldest Open Transaction
SQL Server Page Splits per Second
SQL Server Plan Search - Find CONVERT_IMPLICIT Issues
SQL Server Replication
SQL Server Replication Metrics (11 metrics)
SQL Server Restart Alert
SQL Server Sleeping Sessions with Open Transactions
SQL Server Table Growth
SQL Server Table Size Collector
SQL Server Table Sizes
Script to Modify DPA Repository Cleaning/Purging Times
Sessions Blocking for More Than X Minutes
Sybase Disk Space Monitoring
Sybase Max Locks
Sybase Spinlock Contention
Synthetic Transaction to Measure Application Performance
TempDB Contention
TempDB Contents
Top 10 CPU Consuming Queries
Top Databases by Size Query
Top Databases by Wait Time
Top New Queries by Total Wait Time
Top SQL by Any Dimension
Top SQL by Database
Top SQL by Database User / Login
Top SQL by Program
Top SQL by any Metric - Logical Reads, Executions and more
Top Stored Procedures by Execution Time
Top Tables by Row Count Query
VMware Event History
VMware Resource Metric Detail
VMware vMotion and Power Off Events
Wait Times by Database

Current Blocking Sessions Query

Current Blocking Sessions.sql

Shows sessions blocking other queries. Useful for troubleshooting live blocking issues.