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 Optimization
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.
Help is Just a Click Away!
Tuning Step 1: Evaluate the current Plan and Stats
Tuning Step 2: Generate Alternatives
Tuning Step 3: Execute Selected Alternatives
Tuning Step 4: Evaluate Runtime Stats
Tuning Step 5 (Optional): Suggest and Test Indexes
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
Twitter
RSS
GooglePlus
[...] This post was mentioned on Twitter by Jeff Smith and John Pertell. John Pertell said: Just discussing this with manager, now I can show him RT @hillbillyToad: [Blog]: INTRODUCING TOAD FOR SQL SERVER PT II, http://bit.ly/dBTT67 [...]
[...] Up to this point, I have demonstrated my mastery of the Roman Numeral System, Toad’s IntelliSense and Group Execute technology, and Toad’s SQL Optimization technology. [...]