Post reply

Database Problems after Moving to other Server

  • March 14, 2007 at 9:38 am

    #694987

    The inserts sound strange. Does the query plan give you an idea on where the reads are occurring? Are there perhaps triggers or extra keys on the slow system?

  • March 14, 2007 at 2:17 pm

    #695074

    also, I'm assuming you've run sp_configure on both servers and compared the two? are there any differences? (with show advanced enabled?)

  • March 15, 2007 at 1:34 am

    #695148

    I compared the results from sp_configure advanced. Both servers are configured exactly the same.

    The tables, keys and indexes are created on both servers with the same stored procedure. So there is no difference.

    Both servers have no realy workload. They are just there for hosting the sql server and i'm the only one who is currently connecting to them.

    This drives me crazy, i've got no idea...

  • April 3, 2007 at 2:26 am

    #698234

    Problem solved....

    It looks as if the INSERT takes more time to process because of the hardware raid controller cache. Now i encapsulate the queries (always 100) in transaction blocks and performance increased by 2000%.

    Maybe this helps someone with the same problem...

     

  • April 3, 2007 at 8:19 am

    #698290

    Wow, that is interesting and thanks for the update.

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply