That’s right folks! Toad for SQL Server has been recognized AGAIN as the best development tool for SQL Server. In a previous post I talked about Toad’s IntelliSense and Group Execute features.
Let’s continue the conversation now with a quick introduction on our SQL Tuning feature.
SQL tuning, SQL optimization, SQL plan evaluation, SQL-go-faster: pick your poison, we just want to make your T-SQL more efficient and improve it’s performance profile.
Toad makes this task much more enjoyable. You can concentrate on getting your query ‘right’ in terms of it returning the correct data. Toad then destructs the query and re-builds it using different syntax methods to find the optimal plan.
Toad then gives you the option of testing one or more of these alternatives so you can choose the one best fit for your application.
While in Toad, you can just hit the ‘Optimize the Current Statement’ button, and this will launch you into the Optimizer window.
Tuning Step 1: Evaluate the current Plan and Stats
Scale Test Your Alternatives
With another click, you can also put your queries under load to see which one passes muster. For example, your query might run fine for a single user, but start to break down once you have 10 concurrent sessions running it continuously over a period of time.
Coming Soon: Toad’s Compare and Synch Feature