![]() ![]() Get deeper insights into trace files with the Qure Workload Analyzer– If any free product ever needed a better web page, it’s this one. Bill’s a consultant who gives away software to the community and gives his time, too. ClearTrace is a labor of love from Bill Graziano, the Executive Vice President of the Professional Association for SQL Server. It’s easy to use and helps me get to the bottom of performance problems fast. Slice and dice trace files with ClearTrace – ClearTrace is my go-to tool every single time I run a trace. When I’m tuning a server with slow IO, I can show the costs by IO only, not CPU – a big timesaver for me. Once the bad plan is open in Plan Explorer, just right-click on it and the fun starts. You do have to save the execution plan in SSMS to an XML file, then open it with Plan Explorer, but that’s the only awkward part of the process. SQL Sentry Plan Explorer opens execution plans and gives you much better visibility into the real problem. The scrolling sucks, the cost numbers are painful to read, and I can’t quickly get to the root of the problem. Understand execution plans with SQL Sentry Plan Explorer – I dunno about you, but viewing execution plans in SQL Server Management Studio is a pain in my rear. So you’re lazy and you’re company’s broke – what to do? Here’s my favorite free downloads to help manage SQL Server: ![]()
0 Comments
Leave a Reply. |