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 |
|
dbthj
Posting Yak Master
143 Posts |
 Posted - 2011-05-18 : 15:00:37
|
| The clever people in Marketing created a monster based on Microsoft Access and spreadsheets and Who-Knows-What-Else and it got too big for Access, so they put in on SQL and, as DBA, it's my headache now. I know zilch about Access. ANYHOW, a simple select against a 5,000 row table frequently shows up holding IS locks for hours. Any guesses on what kind of process would do that (asking the Marketing guys is a waste of time) ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-18 : 15:25:06
|
Look for open transactions in that database, using either DBCC OPENTRAN or querying the sys.dm_tran_* DMVs. Someone may have implicit transactions set on their connection properties. |
 |
|
|
|
|
|
Simple query on small table holds IS locks forever