Microsoft SQL Server 2005


I am currently running an SQL server 2005 waht can I do to improve the performance it's bit slow upgrading the hardware is out of the question
Who is Participating?
Anthony PerkinsConnect With a Mentor Commented:
>>Is there like a utility than one can use with a wizard to do all the optimization?<<
Yes.  They are called DBAs :)

Alternatively, you should be able to run the Database Engine Tuning Advisor.
well, you can maintain your indexes. if you don't have index,  create proper indexes. Apart from that keep your stats up to date. assign proper memory to SQL Server
Om PrakashConnect With a Mentor Commented:
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

mogoloAuthor Commented:

Sorry I a bit of a novices on this how do I do that?
RiteshShahConnect With a Mentor Commented:
optimizing query means writing query in a better way so that it takes less time in execution. before you optimize all query, you should give a try to index and stats
mogoloAuthor Commented:
Is there like a utility than one can use with a wizard to do all the optimization?
dhlotterConnect With a Mentor Commented:
database engine tuning advisor is most definitely the way to go.

DTA works in conjunction with SQL Trace output. First, a trace is captured that contains the
queries that you want DTA to analyze. The trace output is read and evaluated by DTA against
a database. The recommendations that DTA can make are :
- Adding indexes
- Dropping indexes
- Partitioning tables
- Storage aligning tables

The source of a DTA workload can be a trace fi le, Transact-SQL (T-SQL) script, or a table
that contains T-SQL commands. Although Profi ler is capable of capturing a wide range of
events, the only events that DTA is concerned about are :
- RPC:Starting
- RPC:Completed
- SQL:Batch Starting
- SQL:Batch Completed

An analysis is accomplished with four steps:
1. Generate a workload for analysis.
2. Start DTA and connect to a server running SQL Server that contains a database to
analyze the workload against.
3. Select the workload to use.
4. Specify tuning options.
All Courses

From novice to tech pro — start learning today.