January 2011 Blog Posts
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...
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...
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...
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 TraceTune.com. It provides a simple way to upload a trace file and see exactly which stored procedures or SQL statements consume the most...