December 10, 2009 at 8:56 am
We have an application, the application is insert a value into the database. While inserting it cause to blocking. we found it was blocked by SQL-DMO application what is SQL DMO.? and how to avoid it.
Please advice me ASAP
December 11, 2009 at 6:37 am
DMO is a method of manipulating SQL Server objects using .NET. This is pre-SQL Server 2005. You would need to determine what is being done by the application using DMO that is causing the blocking in order to fix the situation. What version of SQL Server are you using?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 14, 2009 at 2:48 am
Hi thanks for your reply. i am using SQL server 2000 and dbcc reindex is running from the sql-DMo application.
December 14, 2009 at 5:30 am
DBCC REINDEX is a blocking operation. From BOL:
DBCC DBREINDEX is an offline operation. While this operation is running, the underlying table is unavailable to users of the database.
This is a maintenance operation that should be run regularly, but during non-business/off peak hours.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 14, 2009 at 6:06 am
Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply