Bulk insert slowing select in different DB?

From: Danny (istdrs_at_flash.net)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 01:21:30 GMT

We have a SQL 2K standard sp3a box with 4 procs, 4GB ram, and IO on a good
SAN. We had a situation where there were only two processes running on
server. Process one is a bulk insert into DB1. Process two is a simple
select in DB2 with join of 2000 rows with 3.5 million rows. The select
query plan is scan of the small table and a nested loop to an index seek on
the large table. Process two runs takes minutes where without the bulk
insert running takes seconds. Same query plan. CPU at 25%. Avg. Disk
Queue at fluctuating but averaging about 17.

Any thoughts on how a bulk insert into a separate DB on the same server
could cause a 20 fold decrease in query performance?

Thanks,
Danny

Relevant Pages

  • Re: Bulk insert slowing select in different DB?
    ... We had a situation where there were only two processes running on ... Process one is a bulk insert into DB1. ... Same query plan. ... >> Any thoughts on how a bulk insert into a separate DB on the same server ...
    (microsoft.public.sqlserver)
  • Bulk Import Fails on Remote SQL Instance
    ... When using the Bulk Import cocmponent in an SSIS package, ... instance of SQL Server, fails. ...
    (microsoft.public.sqlserver.dts)
  • Re: VBA - Create a recordset with no records for inserting
    ... directly into the server, I can run a PROC that gets files from my desktop. ... The ServiceBroker will construct the dynamic SQL statement to BULK INSERT the ...
    (microsoft.public.data.ado)
  • Re: Email Help
    ... Some organizations use subdomains as an option for bulk mailing to ... IP address so if we don't run into the issue of having our main server ...
    (microsoft.public.exchange.admin)
  • Re: Access2SQL Performance Probleme
    ... >> SQL Server Schnittstelle wie bcp / BULK INSERT. ... die bereits in ODBC/DB-Library als bcp API existierte ...
    (microsoft.public.de.sqlserver)
Loading