> 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 G:
> (500GB)). 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. The
> package is either executed manually on the server or
> scheduled to run from the server
>
> My problem is that the DTS package runs about 20% more
> slowly on the server above than it does on my desktop
> workstation (executed locally or as a job), 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 (again executed on the server) 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 theslowness problems.
>
> Thanks,