Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- From: Cranfield <alan_cranfield@xxxxxxxx>
- Date: Mon, 14 Apr 2008 02:13:02 -0700
thanks. I will let MS know about our problem.
--
-- cranfield, DBA
"Erland Sommarskog" wrote:
Cranfield (alan_cranfield@xxxxxxxx) writes:.
My apologies for the late reply - I have only just seen the responses (I
never enbaled the "Notify me of replies")
Thank yuo for the info. We have mostly fixed this problem by brute force.
What we did was put a lock timeout in the job step that runs the merge:
SET LOCK_TIMEOUT 30000
We also put a 5x retry in the job step. Now the MERGE job step, which
we run daily, always goes through. Sometimes it timesout and retries a
few times but eventually goes through.
I hope MS fix this livelock problem in the next service pack.
I'm not sure that I see this as a bug, but I can agree there may be a
problem that needs to be addressed. I would not really expect it to be
addressed in a service pack though, as it may require fundametal changes.
If you think that MS should something file a suggestion on
http://connect.microsoft.com/SqlServer/Feedback.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
- References:
- Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- From: Cranfield
- Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- From: Erland Sommarskog
- Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- Prev by Date: Re: migrate ORACLE TO SQL
- Next by Date: Using MS SQL Server Mangement Studio to Copy Table
- Previous by thread: Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- Next by thread: RE: SQLH2
- Index(es):
Relevant Pages
|
