Hi,
I'm running SQL2k sp3 on a dual Xeon w/four drives/arrays (SCSI)(OS on
C:, Logs on E:, tempdb on F:, Data on G500GB)). I have a large DTS
package for processing text files for billing and reporting purposes.
The input file averages 400,000 rows per day and ends up creating a
dozen tables that average 300k rows per file. Various data is exported
and zipped to disk with WinRAR.

My problem is that the DTS package runs about 20% more slowly on the
server above than it does on my desktop workstation, which is a plain
old 1.8 P4 with a standard drive. When I check the process both
processors are running around 80%.

Another example is a single column update on a 1 million row table with
a single join to an indexed table with 8,000 rows. This update took
over 2 1/2 hours.

I'm looking for advice and hints about how to start researching the
slowness problems.

Thanks,





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!