Best Free Tool
Editors' Best
GOLD: SQL Sentry Plan Explorer • SQL Sentry • www.sqlsentry.com
SILVER: SQL Server Maintenance Solution • Ola Hallengren • ola.hallengren.com
BRONZE: SSMS Tools Pack • Mladen Prajdic • www.ssmstoolspack.com
Why It Won:
SQL Sentry Plan Explorer is a free tool that provides the ability to view plan details from seven perspectives, letting you more easily read SQL Server
execution plan details.
"You can use SQL Sentry's Plan Explorer to get faster performance and tuning information from SQL Server query plans," says SQL Server Magazine author Kevin Kline in his Tool Time article "Plan Explorer." In "Plan Explorer,"
Kline explains that this free tool's readability and usability features are efficient and easy to use, and they make analyzing SQL Server execution
plans a snap.
Community Choice
GOLD: SQL Server Maintenance Solution • Ola Hallengren • ola.hallengren.com
SILVER: SQL Sentry Plan Explorer • SQL Sentry • www.sqlsentry.com
BRONZE: CA ERwin Data Modeler Community Edition• CA Technologies • www.erwin.com
Other hot tools in this year's survey …
-
combit's List & Label Free Edition
-
Idera's SQL check
-
Adam Machanic's Who Is Active?
"Hands down, one of the best tools out there! If you’re responsible for a database, you should be using Ola's scripts. It’s very comprehensive, is efficient with resources, has numerous options, and is a brilliant piece of SQL coding!"