March 6, 2008 at 10:31 pm
Hi,
I'm just wondering if it is possible to find out when a client lost their connection to a database from the server side.
A user had temporarily lost their connection to the database for about 30 seconds before their connection came back while viewing/or was in the process of viewing tables. This occured after they killed a logical host in the testing environment when messages were running through.
sql server error logs and the sql agent error logs doesn't seem to have reported anything unusual, so i'm not sure why the connection was lost.
Kathy
March 7, 2008 at 1:54 pm
You can turn on Security Audit in the Profiler.
March 8, 2008 at 7:06 pm
Nothing in event viewer as well?
_____________
Donn Policarpio
March 9, 2008 at 6:23 pm
i checked the event viewer but there wasn't anything unusual there either.
Well, thank you both for your suggestions. I'll just put this aside as a strange case.
Cheers.
March 18, 2008 at 8:55 pm
There are two levels of monitoring. One is on SQL database server. Another is on the OS level.
To check the connection to an SQL Server, you can build SQL Profiler, save it either in a file or in a table. Then, read the saved data.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply