posts - 230, comments - 423, trackbacks - 27

My Links



Follow billgraziano on Twitter

Article Categories


Post Categories


SQL Server

A new company and a new home for ClearTrace

It’s hard to believe I’ve been doing SQL Server consulting for nearly ten years now.  All that time I’ve been part of a firm called ClearData Consulting.  Over the summer we made the decision to disband the company.

scaleSQL Consulting My new firm is scaleSQL Consulting.  One thing I hope never to do again is try to come up with a name for a consulting firm.  That’s just not very much fun.  I’m going to continue to do performance tuning and database administration.  And I’m going to spend time working on SQL Server scalability issues.

This also means that ClearTrace has a new home.  If you visit the old pages on ClearData you’ll be redirected there automatically.  You can now find ClearTrace at

I’ve also posted two of my recent presentations to the new site.  These include the PowerPoint slides and all the demonstration files.  My SQL Server Administration presentation is really just a checklist of steps for a new installation and basic configuration.  It’s targeted at people that aren’t full-time database administrators.  I’ve given this presentation to .NET developers, SharePoint experts, Access developers and group of SQL Server DBAs.  This is my first attempt at a presentation that is 100% demos and no PowerPoint slides except for the introduction.

My second presentation is on Query Plan Usage.  Many of the interesting problems I find in performance tuning are related to odd query plans.  This presentation is an attempt to distill the knowledge down to a single hour.  This also includes over 1,000 lines of SQL for the demos.

If you use Profiler to find SQL queries to tune I’d encourage you to give ClearTrace a try.  It’s a great little utility designed to identify which queries use the most aggregated resources.

Print | posted on Tuesday, September 29, 2009 8:14 AM |



# re: A new company and a new home for ClearTrace

Wow, congrats on the new company! I pimp ClearTrace every time I talk about Perfmon & Profiler, and it's just a fantastic tool. Two thumbs up. I wish I'd have discovered it sooner, and from the looks of the faces of people in the audience, they always agree too.
9/29/2009 9:23 AM | Brent Ozar

# re: A new company and a new home for ClearTrace

Hello Bill
My congrats on the new company ,good luck. BTW your below script throws the error on my server

Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.

Easy to fix:-)))

-- Query for the buffer pages by database
SELECT LEFT(CASE database_id
WHEN 32767 THEN 'ResourceDb'
ELSE db_name(database_id)
END, 20) AS Database_Name
,count(*)AS Cached_Pages_Count -- Buffer Pool Pages
,count(*) * 8192 / (1024 * 1024) as Buffer_Pool_MB
FROM sys.dm_os_buffer_descriptors
GROUP BY db_name(database_id) ,database_id
ORDER BY cached_pages_count DESC
9/30/2009 4:02 AM | Uri Dimant

# re: A new company and a new home for ClearTrace

,count(*) * 8192 / (1024 * 1024) as Buffer_Pool_MB


,count(*) * 8 /1024 as Buffer_Pool_MB
9/30/2009 1:33 PM | noeldr
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET