Re: Bulk insert slowing select in different DB?
From: Danny (istdrs_at_flash.net)
Date: 10/29/04
- Previous message: Jason Robertson: "DIFFICULT PROBLEM! SSL for SQL 2000 Server. MS Fix bulletin does not help at all."
- Maybe in reply to: Danny: "Bulk insert slowing select in different DB?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 29 Oct 2004 11:29:00 GMT
Greg,
Thanks for responding. How would this make a difference when the two
processes run against different databases?
"Greg D. Moore (Strider)" <mooregr_deleteth1s@greenms.com> wrote in message
news:Ocjgd.339626$bp1.318672@twister.nyroc.rr.com...
>
> "Danny" <istdrs@flash.net> wrote in message
> news:uQXfd.18803$Ym1.2760@newssvr31.news.prodigy.com...
>> 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?
>
> Check recovery type.
>
> Simple vs. bulk logged vs full will make a large difference.
>
>
>>
>> Thanks,
>> Danny
>>
>>
>
>
- Previous message: Jason Robertson: "DIFFICULT PROBLEM! SSL for SQL 2000 Server. MS Fix bulletin does not help at all."
- Maybe in reply to: Danny: "Bulk insert slowing select in different DB?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
