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 |
|
binto
Yak Posting Veteran
59 Posts |
 Posted - 2010-04-21 : 06:17:38
|
| I am doing an insertion with a procedure.All the tables inside procedure is heavilly weighted.Procedure contains following process.Table A contains 5m data - insertionTable Aa contains 14m data -- Child of Table A - insertionTable B contains 6m data -- UpdationTable C contains 13m data -- UpdationTables A,Aa,B have foreign key relationships6 users are accessing the procedure concurrently through application for inserting data.Some times server is showing Table lock on Table A while doing insertion.At that time no users can do the insertion process.I was forced to run the KILL(SPID) command to release Table lock.At the begining of procedure, I am using another simple procedure for getting primary key value.Is this a concurrent user request problem?Any solution for avoiding the issue?Please help meThanks & RegardsBinto Thomas |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-04-21 : 08:53:20
|
| Can you show your code, the DDL of your tables and maybe some sample input data?Terry-- The problem with socialism is that you eventually run out of other people’s money. -- Margaret Thatcher |
 |
|
|
|
|
|
Insertion Problem