1 Level
1258 Review
45 Karma
Review on SQL planner by David Romo
Intuitive yet effective tool!: SQL planner
I liked how it could generate queries that would be useful in terms of performance optimization, especially when combined with other tools such as Redgate ANTS or SQL Sentry.
It can also work well with SSMS itself if you're familiar with using the query editor. The price tag is high compared to similar products available out there but I have no issues paying for something that has potential to help me solve my problems at times like these. Currently we use SQL planer mainly for generating scripts that will enable us to tune our databases once they are online.
Pros
- Easy integration within Visual Studio
- Ability create scripted execution plans without writing complex code.
- Can leverage existing knowledge about database tuning techniques (such KILLs) from previous experience working under TSQL environment
- They know their stuff!! And very helpful too
Cons
- Will fit
