Login Events include Pooled Connections

Every now and then I stumble across something and say "I know I knew this before!"  In Profiler, the Audit Login event includes regular logins and connection pooling reuse.  If you run a trace and see a large number of logins you'll need to include the EventSubClass column to determine…

Read90Trace coming soon!

Bob Ward announced in his PASS pre-conference session that Microsoft will be releasing a SQL Server 2005 version of Read80Trace in roughly 30 days.  It's currently going through a security review.  They're planning to call it ReadTrace instead of Read90Trace though.  I don't know what this will do to my…

Upgrading to SAS drives

We were having some disk drive performance issues at a client recently.  They have a 6 drive array running RAID 10.  We spent some time running SQLIO against the array.  Our standard test was an 8KB random read with a queue depth of eight.  The array was giving us 370…

SQL Server 2005 SP2 Build 3054

The joy that is SP2 just keeps on giving.  Microsoft released a hotfix (KB934458) to bring it up to 3054: FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through…

Yet Another ClearTrace Update

These titles seem to be getting repetitive. I updated ClearTrace again. I'm also back to using a ClickOnce installer. Unfortunately if you switch from an unsigned to a signed ClickOnce installation the existing people can't upgrade. How annoying! That was half the reason I switched to an MSI installer. Creating…

ClearTrace Updated

Since I last posted here I've updated ClearTrace.  You can download it here.  There's also a ClickOnce installation if you just want to use the GUI version.  ClearTrace now supports moving the trace files to an archive directory after they're processed.  It also stores a summarized version of the trace…