Does SQL Server 2000 clean up broken or orphan connections
and lease their corresponding memory?
Is there a Microsoft Article that goes into this topic.
Thanks,
Mark P.
Basically yes. When a connection is broken SQL Server will rollback any
open transactions for that connection and any memory used as such will be
available for use by other connections.
Andrew J. Kelly SQL MVP
"Mark P." <anonymous@.discussions.microsoft.com> wrote in message
news:34f501c49cfc$55623e50$a601280a@.phx.gbl...
> Does SQL Server 2000 clean up broken or orphan connections
> and lease their corresponding memory?
> Is there a Microsoft Article that goes into this topic.
> Thanks,
> Mark P.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment