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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-22 : 07:25:48
|
| Sachindra Tomer writes "Dear Sir/MadamI have Sql server 2000 on windows 2003 server.i have a table that have appx 6 inserts per sec i think this is not too much in future it would be more.now we are facing a problem with this Inserts makes system as slower as its hangs.we follow three tier modle.we are not inserting data in bulk,actually we get 6 to 7 request in a Single second on our database server.on that perticular table selects are faster.we have a cluster index on that table.no other index's is their.is their are any other Possibility.Business logic is with ASP.Net.Please help me why this problem is coming.ThanksRegardsSachindra Mohan Tomer" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-22 : 07:28:08
|
| Try doing the inserts from query analyser to see if the problem is with the table or the application.Have a look wit the profiler to see what is happenning too.Using stored procedures for all access will make things easier to diagnose and maintain.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Insertion is too slow with sql server 2000 on win 2003 server