DB update taking hours

[Peter G]

Hello all,

Our company have MSDE database deployed around the country in our application.
I've run into a problem that I can't figure out.
At the end of the day, a large transaction is run to update about 10 tables.
Normally this takes a few minutes, database size is about 70megs. I have
one till where this takes over 2 hours, all the PC's are the same. I have
run a few DBCC commands to check the integrity of the database and it looks
OK, so why does it take so long? There's nothing particularly different on
this PC, maybe its a disk error? Can anyone suggest some things to try, in
order to narrow down the problem please.

Thanks,
Peter Gibbins

[MarkN]

Does each location have their own database?



"Peter G" <peter.gibbins@travelex.com> wrote:
>
>Hello all,
>
>Our company have MSDE database deployed around the country in our application.
>I've run into a problem that I can't figure out.
>At the end of the day, a large transaction is run to update about 10 tables.
>Normally this takes a few minutes, database size is about 70megs. I have
>one till where this takes over 2 hours, all the PC's are the same. I have
>run a few DBCC commands to check the integrity of the database and it looks
>OK, so why does it take so long? There's nothing particularly different
on
>this PC, maybe its a disk error? Can anyone suggest some things to try,
in
>order to narrow down the problem please.
>
>Thanks,
>Peter Gibbins

[Peter G]

Yes.
Each site has a master PC with the MSDE database. There will be no more than
5 PC's attached.

"MarkN" <m@n.com> wrote:
>
>Does each location have their own database?
>
>
>
>"Peter G" <peter.gibbins@travelex.com> wrote:
>>
>>Hello all,
>>
>>Our company have MSDE database deployed around the country in our application.
>>I've run into a problem that I can't figure out.
>>At the end of the day, a large transaction is run to update about 10 tables.
>>Normally this takes a few minutes, database size is about 70megs. I have
>>one till where this takes over 2 hours, all the PC's are the same. I have
>>run a few DBCC commands to check the integrity of the database and it looks
>>OK, so why does it take so long? There's nothing particularly different
>on
>>this PC, maybe its a disk error? Can anyone suggest some things to try,
>in
>>order to narrow down the problem please.
>>
>>Thanks,
>>Peter Gibbins
>