posts - 230, comments - 423, trackbacks - 27

My Links



Follow billgraziano on Twitter

Article Categories


Post Categories


SQL Server

January 2011 Blog Posts

PASS: The Budget Process

Every fiscal year PASS creates a detailed budget.  This helps us set priorities and communicate to our members what we’re going to do in the upcoming year.  You can review the current budget on the PASS Governance page.  That page currently requires you to login but I’m talking with HQ to see if there are any legal issues with opening that up. The Accounting Team The PASS accounting team is two people.  The Executive Vice-President of Finance (“EVP”) and the PASS Accounting Manager.  Sandy Cherry is the accounting manager and works at PASS HQ.  Sandy has been with...

posted @ Tuesday, January 25, 2011 7:30 AM | Feedback (1) | Filed Under [ PASS ]

TraceTune: Larger Files and History

I updated TraceTune over the weekend.  I increased the trace file upload size to 20MB.  We’ve processed over half a million rows of trace data so far and I’m confident this won’t kill the server. I added average CPU and average disk reads to the screen that lists the SQL statements in a trace file. I only added these two.  I’m pretty sure average writes isn’t that import.  I’m still thinking about average duration.  I’m trying to balance showing you what you need with a clean, simple interface.  Plus I have a way to see the...

posted @ Monday, January 24, 2011 7:59 AM | Feedback (0) | Filed Under [ Utilities ]

ClearTrace Supports SQL Server 2008 R2

It was a long time coming and I hope worth the wait.  If you have SQL Server 2008 R2 installed on the same box as ClearTrace and you download the latest ClearTrace build (36) you’ll be able to read SQL Server 2008 R2 traces.  I also fixed a bug handling very, very large SQL statements.  I encountered an INSERT statement that was 12MB in size.  It was storing XML in a database.  ClearTrace uses regular expressions to clean up the SQL it finds.  Running two dozen regular expressions over this 12MB string caused the application to crash.  In...

posted @ Friday, January 07, 2011 11:51 AM | Feedback (0) | Filed Under [ ClearTrace ]

An online version of ClearTrace

When I visit clients for the first time and conduct a performance review I introduce them to ClearTrace. It’s still the best way I know to identify exactly which queries are consuming the most resources.  The downside is that it needs to be downloaded and create a database to store the results.  I finally decided it would be easier if I could just upload a trace immediately. You can find the online version of ClearTrace at  It provides a simple way to upload a trace file and see exactly which stored procedures or SQL statements consume the most...

posted @ Friday, January 07, 2011 9:05 AM | Feedback (0) | Filed Under [ ClearTrace ]

Powered by:
Powered By Subtext Powered By ASP.NET