Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2010-10-07 : 01:23:48
|
| Hi,My current system as follow1. Windows 2003 Server Enterprise Edition 32 bit2. SQL Server 2005 Enterprise Edition 32 bit3. Strengthen by RAID 54. SQL Server now hosting 5 different application database5. All DBs resided in SAN (connected via high speed fiber channel)My current problem as follow1. At this level, SQL Server looks have an extra overhead that hurts performance. Transactional activities which usualy requiring few seconds now requiring few minutes and this is unreasonably slow from user experience perspective.Simptom1. In monitor performance, SQL Disk average queue length sometimes hit to 100%My question is,1. Before upgrade the server, Windows Server, SQL Server, what steps need to be taken2. As a result, we will know this is because of the server, Windows Server and SQL ServerNeed advice |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-07 : 02:21:43
|
| Optimise queries.If they cannot be optimised any better, and performance is still slow, improve hardware or upgrade to newer version.Optimizing queries will save you CPU forever. Throwing hardware at the problem is something you will have to keep doing .... hence Optimise is my first choice. |
 |
|
|
pphillips001
Starting Member
23 Posts |
Posted - 2010-10-07 : 04:32:38
|
| Check your indexing, make sure the queries utilise Index Seeks rather than table scans.Also - check your database isolation level. One of our databases nearly doubled in speed when we switched it from optimistic to snapshot.Make sure you have a separate TempDB files for each processor.Of course all of the above is relative as all SQL 2005 dbs need to be tailored to suit their own purpose.Hope this helps.===========================There is no reality - only perspective. |
|
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2010-10-07 : 10:14:09
|
| tq. you all my inspiration |
|
|
|
|
|
|
|
|
Need advice on SQL Server Performance