SQL Server Current Activity SuperCheck

This gives a quick check of the current activity on a SQL Server. I developed this after getting continually frustrated with "Current Activity" in SQL/EM getting blocked by processes when I needed to see blocking issues on the server. It has been immensely valuable to me in quickly identifying production-stopping issues on the database. It […]

4.2 (5)

2001-08-13

4,834 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Daily Coping 14 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Why doesn't the Secondary failover?

By FrankFarquar

Hi, I hope someone can help. I will try to summarise as best as...

How to rewrite sql query after where condition with another query ?

By ahmed_elbarbary.2010

I work on sql server I need to rewrite statement after where statement so...

Incorrect syntax near the keyword 'AS'

By basmster

Hi Everyone. I'm hoping someone can take a look at my code here to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers