Microsoft SQL Server 2005

Hi,

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
mogoloAsked:
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.
0
 
RiteshShahCommented:
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
0
 
Om PrakashConnect With a Mentor Commented:
0
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:
Hi

Sorry I a bit of a novices on this how do I do that?
0
 
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
0
 
mogoloAuthor Commented:
Is there like a utility than one can use with a wizard to do all the optimization?
0
 
dhlotterConnect With a Mentor Commented:
database engine tuning advisor is most definitely the way to go.

http://msdn.microsoft.com/en-us/library/ms166575.aspx
http://msdn.microsoft.com/en-us/library/ms173494.aspx

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.
0
All Courses

From novice to tech pro — start learning today.