October 23, 2014 at 1:55 pm
Using client tool to access server, first I started SSMS, opened ONLY 1 'New query' window when I ran "select * from sys.sysprocesses where spid > 50 order by loginame desc" It was showing 3 SPID with my login name. Am I missing something here? I thought only spid should be there!!! Any idea please.
October 23, 2014 at 2:50 pm
Don't use sysprocesses. It's deprecated, from SQL 2000.
Use the DMVs, sys.dm_exec_requests/sys.dm_exec_sessions
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2014 at 2:55 am
SSMS opens multiple connections:
1 for the editor window
1 for the object explorer
1 for the intellisense
-- Gianluca Sartori
October 24, 2014 at 5:08 am
Thank you guys.
October 24, 2014 at 5:48 am
spaghettidba (10/24/2014)
SSMS opens multiple connections:1 for the editor window
1 for the object explorer
1 for the intellisense
And sometimes a few more for no good reason.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply