nice topic for debate

  • Can you explain the diff. in Performance of write operation in sql 2000 vs sql 2005?

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • any opinions?

    plz reply

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • I don't think we know what you mean. There are different types of writes for different things. What are you trying to learn or what are you working on?

  • Ok

    Let me tell u my scenario.

    we hav 1 sql server 2000(srv1) on which database db1 is located which is OLTP DB,

    in that there is table tb1 in which frequent inserts happens on every second thru OLTP.

    another server is located in different city which is SQL server 2005 (srv2)on which databse DB2 is located.

    here 6 SPs are called after every 5 sec. those sps fetches data(updated) from above tb1 table (sql 2000 server srv1 ) thru linked server.

    this causes performance issue as data increases in tb1 , so we are planning to move DB1 on sql server 2005.

    (to avoid data fetching thru linked server).

    but after testing on UAT server (sql 2005) developer team has come to the conclusion that, inserts are very slow on sql server 2005 as compare to sql server 2000.

    so i just have to confirm whether really insert (Write) operation is slow in sql 2005 as compare to sql server 2000?

    thanx in advance

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • They are not slower. Not for standard inserts. It is likely that your test setup is not properly simulating things. Perhaps statistics are not up to date, the I/O subsystem is slower, something else.

    In 5 years, I have seen performance problems in places where upgrades have taken place, and in cases code needs to be rewritten. But often it is that statistics aren't up to date, or that the methodology is incorrect for testing.

    However if you are changing the way the application works, it's likely that change that needs to be worked on. SS2K5 is not slower in terms of adding data to a database.

  • sanketahir1985 (1/31/2010)


    Ok

    Let me tell u my scenario.

    we hav 1 sql server 2000(srv1) on which database db1 is located which is OLTP DB,

    in that there is table tb1 in which frequent inserts happens on every second thru OLTP.

    another server is located in different city which is SQL server 2005 (srv2)on which databse DB2 is located.

    here 6 SPs are called after every 5 sec. those sps fetches data(updated) from above tb1 table (sql 2000 server srv1 ) thru linked server.

    this causes performance issue as data increases in tb1 , so we are planning to move DB1 on sql server 2005.

    (to avoid data fetching thru linked server).

    but after testing on UAT server (sql 2005) developer team has come to the conclusion that, inserts are very slow on sql server 2005 as compare to sql server 2000.

    so i just have to confirm whether really insert (Write) operation is slow in sql 2005 as compare to sql server 2000?

    thanx in advance

    Use OpenQuery(). We had similar issue and using openquery() for linked server saved us hours...

    http://technet.microsoft.com/en-us/library/ms188427.aspx

  • Have you ever thought of Raplication?

  • but i haven't seen replication from sql 2000 to sql 2005

    also there is no primary key on that table so its a difficult option

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

Viewing 8 posts - 1 through 7 (of 7 total)

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