Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 11 Apr 2008 14:30:49 -0700
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
.
- Follow-Ups:
- Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- From: Cranfield
- Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- References:
- Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- From: Cranfield
- Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- Prev by Date: Troubleshooting with Dashboard Reports and DTA
- Next by Date: Re: migrate ORACLE TO SQL
- Previous by thread: Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- Next by thread: Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
- Index(es):
Relevant Pages
|
