June 21, 2012 at 2:19 pm
Hi,
We have SQL Server 2008 R2. I want to diagnose some connectivity issues from application to database
Does the SQL server logs its requests and responses? If yes, how to setup the logging for it's requests and responses?
Thanks
June 21, 2012 at 2:53 pm
If you mean login requests, you can do that through what's called a Login Trigger. Data on those is here: http://msdn.microsoft.com/en-us/library/bb326598.aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 21, 2012 at 3:29 pm
It seems like you should be looking to do a traffic analysis using something like wireshark.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply