October 4, 2011 at 7:02 am
Hi Guys
Wondering if anyone could shed some light on the below SQL batch.
The master database is running this query from an anonymous login:
(@P1 varchar(30),@P2 int,@P3 varchar(40))SELECT "timestamp","Profile ID","Page ID","Personalization ID","Date","Time",DATALENGTH("Page Metadata Delta") FROM "VUNA_LIVE"."dbo"."Profile Metadata" WHERE "Profile ID"=@P1 AND "Page ID"=@P2 AND "Personalization ID"=@P3
Is this something to be cautious about?
Regards
October 4, 2011 at 7:26 am
Looks like application code. What are you worried about exactly?
-- Gianluca Sartori
October 4, 2011 at 7:28 am
I'm not, the Manager of the client is "worried" the the master database has a process running now for a few days :\
October 4, 2011 at 7:50 am
Running? I suppose it's not.
What does
SELECT status FROM sys.dm_exec_requests WHERE session_id = [session_id of the process]
return?
-- Gianluca Sartori
October 4, 2011 at 8:21 am
No rows returned.
I know it's not running anything, but why is it still there though?
October 4, 2011 at 8:25 am
Is it in sys.dm_exec_sessions?
-- Gianluca Sartori
October 4, 2011 at 8:27 am
No, but I'm picking it up in the activity monitor
October 4, 2011 at 8:44 am
The command you posted comes from the "Details" window? Is the "Command" column empty or does something show up?
In the first case, it's the last command run from that connection but not running now, in the latter the session is actually running something. There's a big difference between the two.
If it's an idle connection, probably an application left it open and forgot to close.
-- Gianluca Sartori
October 4, 2011 at 8:46 am
Thanks so much! Makes sense 🙂
October 4, 2011 at 8:46 am
It was the latter
October 4, 2011 at 9:20 am
ruan.keyser (10/4/2011)
It was the latter
Perfect. Glad I could help.
-- Gianluca Sartori
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply