Event to trace the dropped connections?

saratcm
saratcm used Ask the Experts™
on
Hi All,
What kind of trace I should run to check for 2 find any dropped connections or # of user connectiond dropped?
Which event should I select?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
All connections either dropped or closed by either user or any kind of events would be considered as Logout Events internally by the server.
And hence you can monitor Security Audit: Audit Login and Security Audit: Audit Logout events especially Logout event is what you require..

Author

Commented:
Thanks!!!
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Welcome..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial