SQL Server Trace Events

Feb 11, 2010 | Trace | 0 comments

I answered a forum post the other day over on SSC on the differences between  the trace events stmtcompleted and batchcompleted. In hindsight I’m not sure that I made a very good job of it, so I thought I would write a blog post to re-enforce and confirm my...

SQL Server Default Trace

Feb 4, 2010 | Performance, Performance Monitoring, Trace | 4 comments

The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in SQL Server 2005 and beyond and it is enabled by default when you install SQL Server. It has a number of uses from auditing to capacity planning and I will...