MS SQL2005 server running slow?

Question

Dear all

Our MS SQL 2005 Server is running very slow can u give some tips ... for speedup.. hardware is best ... but the problme with Databse.. ..

Answer 1

Identifying & eliminating bottlenecks is both an art and a science.

So now you know that your data tier is the bottleneck. Thats a good start. The next thing you should do before upgrading your hardware is figure out which hardware is the bottleneck.

To identify which hardware is causing the sluggishness in performace, you can use a program like System Monitor. Here is a link on how to use counters using System Monitor
http://support.microsoft.com/kb/305610

Here's a important link to get you started with analysing counter info
http://www.pcworld.com/article/id,126461-c,utilities/article.html

Now that you know which hardware part is the problem proceed as follows:

1) Is it the hard disk? Are your queries generating too much I/O operations which are slow? If that's the case, you should add another disk and consider using filegroups for example to place tables that are joined together on different hard disks

2) Is your system reverting to disk swapping because your RAM is not enough? If this is the case, you should increase your RAM

3) Is your CPU usage very high (above 70% most of the time). If that's the case check out what's taking too much processing. If its the SQL Svr, then you should consider upgrading your CPU

Hope this helps.

Answer 2

well, to use sql 2005 u need to have a fast computer or server, if it's slow on your computer it means that u don't have ebugh ram so u should upgrade or buy a new computer with 1gb or 516 ram.