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 |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2007-12-12 : 17:33:18
|
| I have a Orders table, this has a Primary key on one Column ( OrderID )We are using a Stored Proc to insert data into this table ( I am not starting the Transaction in the stored Proc ) as its controlled by the front end written in C++.when ever there is a update on this Orders table I move the record to the ordershistory table. ( I have a trigger in the CTOrders table on INSERT and UPDATE )The C++ App does an Async I/O. Offlate the App is experiencing a few dead locks during the day espicially at the market open and Close as this database is for the Trading System.I need a few pointers as to start debugging this.Thx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-12 : 17:40:41
|
| Please read the topics in BOL that discuss how to troubleshoot deadlocks. You can choose to do this via SQL Profiler or via the Error Log and trace flags.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
avmreddy17
Posting Yak Master
180 Posts |
Posted - 2007-12-13 : 12:13:13
|
| Is it good to contril the Transaction in the Insert Stored Proc ( I mean using BEGIN TRAN and COMMIT TRAN ). Here the Front End controls the Transaction. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-13 : 12:55:02
|
| As long as it is coded properly, it shouldn't matter. I prefer to put it all inside the stored procedure though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
DEAD LOCKS