DB update taking hours


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: DB update taking hours

  1. #1
    Peter G Guest

    DB update taking hours


    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

  2. #2
    MarkN Guest

    Re: DB update taking hours


    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



  3. #3
    Peter G Guest

    Re: DB update taking hours


    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

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center