July 16, 2013 at 8:02 am
can i know the difference b/w latch vs lock ?
July 16, 2013 at 8:10 am
http://www.google.com/search?q=sql+server+locks
http://www.google.com/search?q=sql+server+latches
Lots and lots of info there
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 16, 2013 at 10:11 am
I know it's an old post but it's still relevant, I believe.
http://www.dotnetobject.com/Thread-difference-between-latch-and-lock
July 16, 2013 at 1:39 pm
ramyours2003 (7/16/2013)
can i know the difference b/w latch vs lock ?
Latch = is a type of lock you place in buffer cache
locks = are placed against resources.
Correct me if I am wrong.;-)
Regards,
SQLisAwe5oMe
Regards,
SQLisAwe5oMe.
July 16, 2013 at 2:29 pm
SQLisAwE5OmE (7/16/2013)
Latch = is a type of lock you place in buffer cache
No.
locks = are placed against resources.
No.
Maybe take a read through the search links I posted above.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 16, 2013 at 2:53 pm
GilaMonster (7/16/2013)
SQLisAwE5OmE (7/16/2013)
Latch = is a type of lock you place in buffer cacheNo.
locks = are placed against resources.
No.
Maybe take a read through the search links I posted above.
Okay, Thanks for clarifying....will do.
Regards,
SQLisAwe5oMe.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply