Name		Name	Last commit message	Last commit date
parent directory ..
stored-procedures		stored-procedures
README.md		README.md
function-stats.sql		function-stats.sql
parallelism_analysis.sql		parallelism_analysis.sql
query_stats.sql		query_stats.sql
sheduler-monitor.sql		sheduler-monitor.sql
trigger-stats-detailed.sql		trigger-stats-detailed.sql
trigger-stats.sql		trigger-stats.sql

README.md

Execution Stats

Scripts using DMVs like sys.dm_exec_query_stats to analyze query performance.

📝 function-stats

Displays execution statistics for scalar functions including caching time, execution count, and resource consumption.

📝 parallelism_analysis

Analyzes performance of queries using parallelism, showing execution statistics and degree of parallelism metrics for cached query plans.

📝 query_stats

Displays the heaviest queries in the plan cache with execution counts, logical reads, worker time, and execution timing metrics.

📝 sheduler-monitor

Monitors scheduler activity from the last 256 minutes using ring buffers to track CPU usage, page faults, and memory utilization.

📝 trigger-stats

Shows trigger execution statistics across databases with performance metrics and trigger type information.

📝 trigger-stats-detailed

Provides comprehensive execution statistics for database triggers including worker time, reads, writes, and execution plans.

Subdirectories

📁 stored-procedures

Stored procedure execution analysis scripts.