January 29, 2010 at 3:28 am
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......
January 31, 2010 at 9:02 pm
any opinions?
plz reply
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
January 31, 2010 at 9:19 pm
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?
January 31, 2010 at 11:36 pm
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......
February 1, 2010 at 9:46 am
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.
February 1, 2010 at 9:57 am
sanketahir1985 (1/31/2010)
OkLet 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...
February 1, 2010 at 9:58 am
Have you ever thought of Raplication?
February 1, 2010 at 10:08 pm
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