SQL Server 2008 started reporting the statement duration in microseconds in scripted traces. That’s one millionth of a second. Previously they were reported in milliseconds. Profiler automatically corrects for this and always displays in milliseconds regardless of the version of SQL Server that generated the trace. However SMO reported…
Bill Graziano is a Kansas City-based SQL Server consultant [http://www.scalesql.com]. He provides performance tuning and part-time DBA services. Bill is a SQL Server MVP and serves on the Board of Directors of The Professional Association for SQL Server [http://www.sqlpass.org] (PASS). Bill is a regular…
TraceTune now shows a graphical view of logical reads for each SQL statement in a trace file. The width of the colored bar in the screen capture below is the percentage of logical reads for that statement. The absolute number of reads is shown to the right. [https://billg.sqlteam.…
I’ve been using the online version of ClearTrace [http://www.tracetune.com/] more and more lately. When I get to a new client it’s just much easier to upload a trace file rather than install ClearTrace. That means I’ve finally been adding more features to it. The…
Last year after the election, the PASS Board created an Election Review Committee [http://erc.sqlpass.org/]. This group was charged with reviewing our election procedures and making suggestions to improve the process. You can read about the formation of the group and review some of the intermediate work on…
[https://billg.sqlteam.com/content/images/61307-image_2.png]The latest release of ClearTrace [http://www.scalesql.com/cleartrace/download.aspx] (Build 38) now shows the execution history of a particular statement. You’ll need to save the trace files to a trace group instead of just using the default.…
Earlier this year we published preliminary fiscal year 2010 financials to the Governance page [http://www.sqlpass.org/AboutPASS/Governance.aspx] on the PASS web site. Please remember that FY10 runs from July 1st, 2009 through June 30th, 2010 and includes the November 2009 Summit. We do our fiscal year…
I’m going back to speak in St. Louis next month. I didn’t make it last year and I’m looking forward to it. You can find additional details on the St. Louis SQL Server user group web site [http://www.stlssug.org/calendar.html]. The meeting will be…
I wrote a small utility to script some key SQL Server configuration information. I had two goals for this utility: 1. Assist with disaster recovery preparation 2. Identify configuration changes I’ve released the application as open source through CodePlex. You can download it from CodePlex at the Script SQL…
[https://billg.sqlteam.com/content/images/61288-pass2_2.jpg]Register by March 31st and save $200. On April 1st we increase the price. On July 1st we increase it again. We have regular price bumps all the way through to the Summit. You can save yourself $200 if you register…