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 |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-06-26 : 16:46:23
|
| Hi Guys.I have a DB it's about 3GB. and all of a sudden it starts using more memory.In Activity monitor i notice a lot of things running in it with Wait Type.lck_m_u what is this and what can i do to stop it.I think one of the developers ran a update script. he said he stop / canceled it but i dont think so.Can anyone help me here this is on SQL 2005 STD Edition.Cheers |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-26 : 17:11:56
|
google says: Lck_M_U is an update lock
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
mvanwyk
Yak Posting Veteran
99 Posts |
Posted - 2009-06-26 : 17:36:17
|
| Hi Thanks i know it's an Update lock but how can we stop it from updating or find out who or what is doing the update. |
|
|
|
|
|
|
SQL Wait Type