Hello,

We are experiencing some lag on our SQL Servers, and have determined that a small portion of the lag is probably due to the MM_NewID stored procedure. We have a large number of tables referenced in ID, some getting new IDs almost constantly. The first SELECT statement in the transaction looks like this:

SELECT @cId = Value,
@cIncProc = IncrementProcedure,
@nMaxLen = MaxLength,
@cType = type
FROM Id (UPDLOCK)
WHERE keyname = @tcKeyWord

I was wondering if there was any reason not to change the locking hint from UPDLOCK to ROWLOCK? This would at least eliminate any lag associated with generating new IDs for one of the other rows in the ID table, leaving only new ID requests for the same row to be queued up.

TIA,

-Justin