Post reply

Performance Issue On Insert But Select Is Fine.

  • September 15, 2009 at 11:43 pm

    #226146

    We have a Sql server with round about 60 databases on it. The server performance is fine if all of them is not attached.

    But the moment we attach all of them the server insert statements take n major performance down fall.

    With the most of the databases detach i can insert a million rows in round about 1 min 14 sec. but the moment we attach the rest of them again performance is gone again. Just the select queries performs still.

    With all the databases attached when i try to insert 20000 rows it is still quick but 30000 rows just hangs and doest look like the server is doing anything.

    The io is low the ram look ok and the processors is fine as wel. Any suggestions would be appreciated. On why would it do this the moment we attach the other databases this is all done with no users connected. So it is not that the users are taking the server resources. Me personally thinks its got something to do with internal memory or a page file of some sort that needs to be bigger.

    Thanks In Advance

  • September 16, 2009 at 2:28 am

    #1054291

    Hallo

    We came right we disabled all the change tracking on the database tables. Looks like there was some errors in there and when we disabled it. The performance was back up and running.

    Thanks 🙂 .

Viewing 2 posts - 1 through 2 (of 2 total)

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