Israeli SQL Users Group May 2009

May 5, 2009

I spoke about SQL Trace and Profiler.  I talked about the differences between Server Side Tracing and Profiler and helped to clarify some mists and confusion related to both.  In addition I presented a practical scenario implemented using SQL Trace which traps exceptions that occur in the database engine along with the statement that caused the exception. To download the code: http://blogs.microsoft.co.il/blogs/yaniv_etrogi/TraceErrors.zip   And finally I presented a .NET utility I wrote that subscribes to SQL Server and listens to events. The utility reports of blocking locks and enables to receive notifications at real-time as well as get statistical reports.   To download...
tags: ,
no comments