August 3, 2006 at 11:54 am
I have about 10 databases on one server.
I'm running the same update in 5 databases, but see via sp_who that only 3 of them run and only when those are finished do the other two start up.
For example, 3 updates were about 60K rows, the ones that took forever were 4K.
Any configuration setting I'm missing?
August 3, 2006 at 1:44 pm
Which version of SQL Server are you using ? Are your updates in the same database or in different databases. In the first case it could be that the first 3 update sessions place locks and the other sessions have to wait until the locks have been released. That would explain the behaviour your seeing.
Combine sp_who and sp_lock to see what type of locks are used (row, page or maybe even table locks).
Markus
[font="Verdana"]Markus Bohse[/font]
August 3, 2006 at 6:43 pm
We are running 2003/2005, the updates take place in different databases.
I didn't see any blocking via sp_who, but will take a look at the locks.
Thanks for your help
Susan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply