August 1, 2008 at 4:16 am
I Brad McGehee gets this I would like him to respond. I downloaded an e-book from SQL Server Central written by Brad McGehee and it helped me immensely because I am busy with self-training as a DBA. The book's name is something like DBA Best Practices but the first part of the book explains daily tasks for a DBA and one of them is:
"User Enterprise Manager/Management Studio to monitor and identify blocking issues"
I am not sure what these blocking issues mean. Could anyone please help me on this and Brad if you see this can you pleeeaaaase respond?
:w00t::w00t::w00t::w00t::w00t:
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
August 1, 2008 at 5:39 am
You probably have to look for a more basic book and read about locking. Blocking is a extreme case of locking; in the RDBMS world locking is a fact of life -no RDBMS would work without resorting to locking.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 1, 2008 at 7:16 am
Hello,
Although not exactly what you are after, this article might be an interesting quick read, as background information on Database locking: http://www.devx.com/gethelpon/10MinuteSolution/16488/0/page/1
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply