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 |
|
hspatil31
Posting Yak Master
182 Posts |
 Posted - 2011-11-15 : 04:39:06
|
| Dear All,I am handeling 20GB database in SQL server 2008. I have done lot of operation on table but some times its not COMMIT or ROLLBACK. So I think in my DB there is a lot of open transaction because of that my SQL server performance is very less.Can anybody please tell me how to find the OPEN Transaction and how to kill that OPEN transactions ?Thanks and Regard'sHarish Patil |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-11-15 : 04:46:05
|
| Run this code to know themDBCC OpentransMadhivananFailing to plan is Planning to fail |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-11-15 : 04:48:28
|
DBCC OPENTRAN without s
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
hspatil31
Posting Yak Master
182 Posts |
Posted - 2011-11-15 : 05:03:14
|
| Hello Friend,I can see the now OPEN transaction in my DB.But how to kill that transaction ? So my DB performance will be fast.Is there any way to COMMIT or ROLLBACK or CLOSE that transactions ?Thanks and Regard'sHarish Patil |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-11-15 : 05:14:26
|
| To kill that transaction, kill sp_idMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-11-15 : 05:14:57
|
quote:
Originally posted by webfred
DBCC OPENTRAN without s
No, you're never too old to Yak'n'Roll if you're too young to die.
Thanks. MadhivananFailing to plan is Planning to fail |
|
|
|
hspatil31
Posting Yak Master
182 Posts |
Posted - 2011-11-15 : 05:41:47
|
| Thnks. |
|
|
|
|
|
|
How to find the open transaction.