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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-09-30 : 15:54:22
|
| Hi,I have a stored procedure (does a lot of transaction processing) which successfully runs when executed from QA but the process manager indicates locks present after stored procedure completes success fully. When this stored procedure is called from ASP the proc hangs. Could anyone let me know where to start finding the transaction holding a lock.Where do I start to begin troublehsooting locks being held. Env: SQL Server 2000-SP2, ASPThank youByeRamdas NarayananSQL Server DBA |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-09-30 : 16:03:38
|
Here's a bit of light reading  These KB articles themselves contain links to further resources....Q271509 INF: How to Monitor SQL Server 2000 Blocking[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q271509[/url]Q224453 INF: Resolving SQL Server 7.0 or 2000 Blocking Problems[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q224453[/url]INF: SQL Blocking Due to [[COMPILE]] Locks[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263889[/url]INF: Reducing Lock Contention in SQL Server[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q75722[/url]HTHJasper Smith |
 |
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2002-09-30 : 16:39:15
|
Hi,Thank you. They are of light reading material  ByeRamdas NarayananSQL Server DBA |
|
|
|
|
|
|
TroubleShooting Locks