Thanks so much Grant, I will definitely explore the tools that you have mentioned.

Also, has anybody used SQ Sentry PowerSuite tool ? I would like to compare few tools...

Its for SQL Server 2008 R2.

We will be needing for DBA monitoring which should include administration, performance and diagnostics.

We also need designing features as well.

Thanks

Thanks for your suggestion. I would like to get some recommendation about some third party tools like Redgate or Idera. Please let

me know if any of you using these...