Skip to content

Files

Latest commit

 

History

History
 
 

BlitzQueries

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Blitz.sql
Blitz.sql
 
 
BlitzCache.sql
BlitzCache.sql
 
 
BlitzIndex.sql
BlitzIndex.sql
 
 
BlitzQueries.ssmssqlproj
BlitzQueries.ssmssqlproj
 
 
Blocking Tree.sql
Blocking Tree.sql
 
 
Buffer-Pool-Analysis.sql
Buffer-Pool-Analysis.sql
 
 
CREATE TABLE [dbo].[whatIsRunning].sql
CREATE TABLE [dbo].[whatIsRunning].sql
 
 
Configure_PSSDiag.sql
Configure_PSSDiag.sql
 
 
Db-Design-Analysis.sql
Db-Design-Analysis.sql
 
 
Detect n Reduce High VLFs - All Dbs.sql
Detect n Reduce High VLFs - All Dbs.sql
 
 
Detect n Reduce High VLFs.sql
Detect n Reduce High VLFs.sql
 
 
DiagManager13.0.1600.32.zip
DiagManager13.0.1600.32.zip
 
 
Find-Indirect-Connections.sql
Find-Indirect-Connections.sql
 
 
Find-Statistics.sql
Find-Statistics.sql
 
 
Fragmentation-Analysis.sql
Fragmentation-Analysis.sql
 
 
Other queries.sql
Other queries.sql
 
 
PerfmonCounters_Disk_CPU_Memory_Network.PerfmonCfg
PerfmonCounters_Disk_CPU_Memory_Network.PerfmonCfg
 
 
Plan-Cache-Analysis.sql
Plan-Cache-Analysis.sql
 
 
Querying Deadlocks From System_Health XEvent.sql
Querying Deadlocks From System_Health XEvent.sql
 
 
README.md
README.md
 
 
RingBuffer-PerfMon-CPU-Memory.sql
RingBuffer-PerfMon-CPU-Memory.sql
 
 
SQL Server 2008 R2 Diagnostic Information Queries.sql
SQL Server 2008 R2 Diagnostic Information Queries.sql
 
 
SQL Server 2012 Diagnostic Information Queries.sql
SQL Server 2012 Diagnostic Information Queries.sql
 
 
SQL Server 2014 Diagnostic Information Queries.sql
SQL Server 2014 Diagnostic Information Queries.sql
 
 
SQL Server 2016 Diagnostic Information Queries.sql
SQL Server 2016 Diagnostic Information Queries.sql
 
 
SQL Server 2017 Diagnostic Information Queries.sql
SQL Server 2017 Diagnostic Information Queries.sql
 
 
SQLNexus.6.0.0.8.zip
SQLNexus.6.0.0.8.zip
 
 
SQLPerf_General.xml
SQLPerf_General.xml
 
 
Very-Large-Databases-Optimization.sql
Very-Large-Databases-Optimization.sql
 
 
WaitStats-Short-Period.sql
WaitStats-Short-Period.sql
 
 
WhatIsRunning.gif
WhatIsRunning.gif
 
 
WhatIsRunning.sql
WhatIsRunning.sql
 
 
WhatIsRunning2.gif
WhatIsRunning2.gif
 
 
__DiagManager-PssDiag-SqlNexus.sql
__DiagManager-PssDiag-SqlNexus.sql
 
 
blitzFirst.sql
blitzFirst.sql
 
 
pssd.zip
pssd.zip
 
 
sp_whoIsActive.gif
sp_whoIsActive.gif
 
 
whoIsActive.sql
whoIsActive.sql
 
 
who_is_active_v11_32(Modified).sql
who_is_active_v11_32(Modified).sql
 
 

README.md

BlitzQueries - Project

1) What's Running

Latest Code of WhatIsRunning Script

I have created this TSQL Query that provide almost all information regarding running queries. This code gives query at Batch Level and at individual TSQL query within that Batch. Incase the running session is SQL Agent job, then [Program_Name] column data would be shown like 'SQL Job = < job name >'. Below is sample screenshot.

2) Adam Mechanic's [sp_WhoIsActive] - Modified

Latest Code of Modified [sp_WhoIsActive] Script

I am big fan of Adam Mechanic's [sp_WhoIsActive]. I have modified the latest script v11.30 to provide the job name in case the running session belongs to sql agent job. Below are sample screenshots.