With the following query I can find processes on the dataserver
select *,db_name(rsc_dbid) as db_name from sys.syslockinfo (nolock)
Can I derive the SQL query from processes that are blocked?
Specifically, we get orphaned, blocking processes (with a req_spid of -2) but we don’t know why.
Have a look at sp_WhoIsActive from Adam Machanic. It tells you what’s running, what’s blocking, and it derives the SQL text from those queries.
- What is the best way to determine what’s locking up SQL Server using a query?
- does SQL server have the equivalent of MySQL query logs
- Run SQL query from cron
- T-SQL query to schedule the back-up by using Transactional logs!sql server 2008
- Hiding SQL Server 2005 system objects/schemas from Microsoft Query
Leave a comment
- What is the easiest way to upgrade my existing Perl 5.14 to Perl 5.16 on FreeBSD 9 using the ports system?
- Know if mysql has done its job
- Redirect https .com to https .co.uk without a valid SSL cert on .com without DNS change
- Why is it a bad idea to use customer email as from address
- 100% packets dropped on first RX queue on 3/5 raid6 iSCSI NAS devices using intel igb (resolved)