Number sequence database blocking

(0) Share

Report

Posted on by Community Member

Dear All,

From few weeks back, we experience a system slowness and also when checking the database we get a database blocking code as follows.

This is related to number sequence table.

SELECT TOP 1 A.NUMBERSEQUENCE, A.TXT, A.LATESTCLEANDATETIME, A.LATESTCLEANDATETIMETZID, A.LOWEST, A.HIGHEST, A.NEXTREC, A.BLOCKED, A.FORMAT, A.CONTINUOUS, A.CYCLIC, A.CLEANATACCESS, A.INUSE, A.NOINCREMENT, A.CLEANINTERVAL, A.DEL_LATESTCLEANDATE, A.DEL_LATESTCLEANTIME, A.ALLOWCHANGEUP, A.ALLOWCHANGEDOWN, A.MANUAL, A.FETCHAHEADQTY, A.FETCHAHEAD, A.MODIFIEDTRANSACTIONID, A.RECVERSION, A.RECID

FROM NUMBERSEQUENCETABLE A WITH ( UPDLOCK) WHERE ((DATAAREAID=@P1) AND (NUMBERSEQUENCE=@P2)) )

Can anyone please guide me how can I identify the issue and how to solve these blocking and slowness.

Thanks in advance.

Indrachapa.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Tommy Skaue Moderator on at

Like (0)

Report

I would strongly recommend going through the list of numbersequences and disable "Continuous" on all that does not have this strict business requirement. More often, users think the number sequences MUST be Continuous, while it isn't necessarily so. Any continuous numbersequence can cause degraded performance if not used correctly.

One clue to what numbersequences are being used the wrong way is to have a look at the table NumberSequenceList grouped by numbersequence. This list contains numbers in use and those waiting to be used in a continuous numbersequence.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Tommy. I will use your clue to check the issue. Also currently we have more than 180 continuous number sequences per company.

Was this reply helpful? Yes No
Suggested answer

Samadhi006 35 on at

Like (0)

Report

Hi,

it is also possible that the number sequence ran out of numbers.
You Need to check the number sequences if the next number is higher than the next number.

Best regads,

Petra

Was this reply helpful? Yes No