I had troubles at a server on which I dont have direct access, so the sysadmin sended me the logs as *.evt file so I needed good viewer. Took me a bit, but here is a very nice free tool: http://www.eventlogxp.com/ In combination with MSACCESS and MSEXCEL I was able to produce a nice chart which gave me an inside vew on what was going on and when. (4 ur info, it looked like it was an overflooding connectionpool)


also always common handy to peek into the pool: sqlquery analyzer: EXEC SP_WHO