January 7, 2011 at 11:58 am
Hi, I have few critical production websites running on SQL 2005 Enterprise edition which I am planning to migrate to SQL 2008 R2 in the coming quarter. I am quite familiar with all native features of SQL Server but not sure whether any other third party tools would help me for a better administration. Any suggestions on this would be highly appreciated. This will help me to fix the budget for the coming year.
At present Performance is bit challange being a consumer product website.
Thanks!
January 7, 2011 at 1:41 pm
Honestly, I'd just take a look at the tools on Red Gate's site (link at upper right of this page, since they own SQL Server Central). They have a ton of high-quality DBA tools.
ApexSQL also has good tools for a variety of SQL/DBA tasks.
There are others, but you'll find those most easily by finding the specific tools Red Gate offers that you think you want, and searching for comparisons on those specific products. It's going to be easier to research "SQL Prompt" as a competitive product list, than to search for "SQL tools".
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 7, 2011 at 1:48 pm
Another vote for Red Gate tools. They're pretty amazing. They primarily will help in development and maintenance. In terms of performance, they have a new tool, SQL Monitor that will help you gather performance metrics and identify where your bottlenecks are, but won't give you a ton of guidance on what to do about them (they're working on that though).
The other tool set I've used is Idera, Diagnostic Manager and SQL Doctor. DM is roughly the same as SQL Monitor, but it's different in flavor & approach (better in some areas, worse in others). SQL Doctor on the other hand is a pretty good tool that will identify problems with your database and suggest possible solutions.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 7, 2011 at 4:39 pm
Follow the great advice from Grant and Gsquared. I agree with them.
The 3rd party tools help you mostly in Administration, Development and Monitoring part of SQL Server and not so much in the performance tuning.
Performance tuning is mostly a manual approach based on your expeience and understanding and by using SQL Server Native tools like Profiler, DTA, SSMS, DMVs, Perfmon etc.. and third party tools can help you only upto some extent.
Thank You,
Best Regards,
SQLBuddy.
January 10, 2011 at 7:26 am
Confio Ignite can help a LOT with performance tuning. Helps you narrow in on exact statements that are causing problems.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply