开发者

What is the relationship between a SPID and a Connection in SQL server?

Can a SPID be used by two connections, while both connections are open?

If a connection is returned to a connection pool, will开发者_StackOverflow it hold on to the SPID?


Can a SPID be used by two connections, while both connections are open?

No, each open connection will have its own SPID.

If a connection is returned to a connection pool, will it hold on to the SPID?

Yes, as long as the connection is open, it will be associated with one SPID.

You can test this yourself by querying sys.sysprocesses. Rebooting a client machine should clear its connection pool.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜