October 11, 2011 at 4:26 pm
Hi,
I got a package which takes the destination connection strings from a variable. When i run my package it stays in validation phase. So i wheni execute sp_who2 on the database that will be populated i found an SPID in the following situation
SPID----Status------Login-----HostName---BlkBy---DBName------Command
59------suspended--mylogin--servername --(-2)----mydabname---SELECT
I'm not knowing why it's blocking that and why i'm getting -2 . If i run my package firectly without getting connection string form variables then its running fine.
I'm using Sql Server 2008R2 Sp1 version
Can some one help me out with this please
October 12, 2011 at 2:34 am
You could issue
SELECT text
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle)
WHERE session_id = [SPID causing trouble]
to find out what command the session is running.
Or, even better, you could download and run sp_WhoIsActive by Adam Machanic.
It gives a lot of insight on what is going on on your instance.
Hope this helps
Gianluca
-- Gianluca Sartori
October 13, 2011 at 2:05 pm
Do you have any linked servers? Normally when I see SPID -2, that's DTC. I've never seen it as a blocking SPID, but I've seen it as a hung SPID.
Todd Fifield
October 13, 2011 at 3:00 pm
Hi
No linked server. We are just trying to pull data from another server to my local machine.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply