Query to Get SQL Job Info from sysprocesses
By Lori Brown | Helpful Scripts , SQL Administration , SQL Server , SQL Toolkit
We recently were troubleshooting an issue where one client reported that the SQL instance was suddenly very slow. One of the things we do is check to see what queries are currently running in SQL by using the following query: — Finds info on queries that are running NOW SELECT GETDATE() AS CurrentTime, SUBSTRING(text, CASE […]
Continue reading