Sql Server Tuning

[leon251280]

I need to find a tool that help me to optimize sql server,speed up queries,improve the performance and solve any bottlenecks.

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

http://www.sqlserverli festyle.com
http://www.red-gate.com/products/dba/sql-monitor/
http://www.idera.com/Free-Tools/SQL-check/

thanks

[ck9663]

You can do a lot by just analyzing the query and it's execution plan without all those. After you used all that and you think you need more, then go for the third party app.

Good Luck!!!


~~ CK

[kyleminor97]

To get accurate reports on SQL Server performance and database usage, Lepide SQL Storage Manager proves to be the ideal software. It facilitates you to work on the databases and schemas, tables and other sub objects to get full control on the administrative tasks and their properties. It also helps in improving database output and manages space utilization in more appropriate manner by switching the database objects.