Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-06-16 : 11:44:03
|
| Hi,We have 2 databases and same table in both databases. On database1 this table is heap with no indexes and on database2 it has primary key index on 1 int column and 1 unique index on varbinary column.If we insert 2 Millions rows into table in 2nd database while selecting 1000 rows at a time from table in database1 the tps is about 25000….database2 have 55 million rows in a table……If we try to insert from 2 session into database2 the tps only scale to 30000 that is very less scaling…….Now if we add a non-clustered index of 5 column on table in database2…..with I session inserting tps drops to 15000 but that is ok since it has more work to do but with 2 sessions tps drops to 5000 that is highly unacceptable as we are adding more sessions to increase tps and not decrease…….There is no locking issues….IO is not an issue…….no high cpu……..only high are latches that are 1500 (not that high)……….What can be the possible reason for degradation in tps with 2 sessions as compare to 1?Thanks--Harvinder |
|
|
|
|
|
Insert Performance issue