Reduce SQLServer Wait Time

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: kris (kpxus_at_yahoo.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 12:07:31 -0700

Hi,

I ran waittype procedure to for 10 mins to check the sqlserver waittype and
time and got the following result

wait type
wait time percentage
----------------------------------------------------------------------------
---- ---------------------- ----------------------
***total***
7086.0 100.0
CXPACKET
3254.0 45.9
LATCH_EX
3034.0 42.8
.
..
I just want to reduce the above wait types,any idea. Currently the max
degree of parallelism is 0 .
SQL BOX has 2GB Memory and SQLServer is configured to use 1032MB fixed.

Env:
SQL2000 + SP3 /Windows 2000 Advance Server 2 Processors with Hyper-Threading
Technology.

thanks