May 20, 2010 at 4:20 am
Trying to understand what Sql Profiler means by emitting "sp_reset_connection".
I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed,
RPC:Completed exec sp_reset_connection
SQL:BatchStarting SELECT [c].[TestID] AS [TestID], [c].[Description] AS [Description] FROM [dbo].[Test] AS [c]
SQL:BatchCompleted SELECT [c].[TestID] AS [TestID], [c].[Description] AS [Description] FROM [dbo].[Test] AS [c]
Basically does first line "exec sp_reset_connection" mean the whole process (my connection was opened, the select stmt is run, then the connection is closed and released back to pool) just take place? Or my connection is still in open stage.
And, why does the sp_reset_connection executed before my own select statement, shouldn't it the reset come after user's sql?
I'm trying to know is there a way to know in more detail when a connection is opened and closed?
By seeing "exec sp_reset_connection", does that mean my connection is closed?
please reply
Thanks in advance
May 24, 2010 at 12:10 am
please reply
May 24, 2010 at 5:51 am
see if this link can help you http://stackoverflow.com/questions/596365/what-does-sp-reset-connection-do
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 27, 2010 at 3:07 am
Thanks for the reply, i checked that link
Is there any setting need to be change in database sideor level for reset_connection timeout (sid) or for to avoid spid blocking itself
Thanks in advance
May 27, 2010 at 3:32 am
At server/databae level , no idea about that additionally didnt that issues resolve from that link ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply