Sql server performance tuning

Last Post 21 Mar 2013 06:30 AM by spiral98. 5 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
leon251280
New Member
New Member

--
31 Jan 2012 05:06 AM
I need to find a tool that help me to optimize sql server,queries,improve the performance and solve any bottlenecks.

can you tell me their experience or has other tools to advise me?

http://www.sqlserverlifestyle.com
http://www.red-gate.com/products/db...l-monitor/
http://www.idera.com/Free-Tools/SQL-check/

thanks

gunneyk
New Member
New Member

--
31 Jan 2012 08:45 AM
Well one that isn't on your list that I would highly recommend is the suite from SQLSentry.net. However you need to keep in mind that most of these tools are to find bottlenecks and poorly optimized code etc. They don't really solve or fix it, that is up to you. Some of the better tools can give advice and guide you but have to be part of the solution. Just keep that in mind.
Dan Fugett
New Member
New Member

--
05 Feb 2012 07:44 PM
I have used Quest Spotlight and now use Confio Ignite sometimes in conjunction with ManageEngine.  For the purposes the user stated, Ignite has been a better value for the cost.  It shows sql performance issues and provides an historical trend of the worse running queries.  Ignite even stores the sql code allowing us to do real deep dives into what is running days or weeks from the event.  Ignite is based on wait times so the focus is to tie poor performing queries to the highest wait times of the day by day, database, host,  user, program, wait type, ...  Then ManageEngine provides the sql/windows counter information tracking for the last x hour to 30 days allowing correlation of high wait types to poor runnig code to sql couters.

Thanks,

Dan Fugett
Gil Asherie
New Member
New Member

--
05 Feb 2012 10:49 PM
One free tool that will help you identify bottlenecks is Qure Analyzer:


It takes as input a trace file and runs a very deep analysis to zoom in on poorly performing SQL queries, for example by application, user, host, time or by multiple dimensions. Another nice feature is the ability to compare trace files -- very useful if you want to know how effective your tuning changes have been.

Qure Analyzer will help you find the problems, but won't tell you how to fix them. However, DBSophic also provides a (not-free) tool called Qure Optimizer that does exactly that: 


It will analyze the database workload (one or more trace files) and give you specific recommendations for improving performance (eg, add/modify indexes and rewrites to SQL syntax). The tool even uses a copy of the production database to benchmark its recommendations\, so that you know what performance improvement to expect when you deploy the recommendations to production. 

Hope that helps!
peter
New Member
New Member

--
23 Oct 2012 02:02 AM
can anyone brief me that which tool is having all needful specification with a minimum expenses
spiral98
New Member
New Member

--
21 Mar 2013 06:30 AM
Try out Lepide's product for SQL
for Performance monitoring and capacity management I prefer Lepide SQL Storage Manager over all of them
The reason is cost effectiveness & support services

Take a look

http://www.sqlserverperformancemonitoring.com/


Acceptable Use Policy
---