Post reply

Using SEQUENCE - best practice for setting Cache value

  • May 23, 2016 at 4:43 am

    #326600

    Can anyone point me to some Best Practice documentation or share their experiences around setting a value for the Sequence Number Cache?

    We have a Sequence number generator which is serving multiple Databases, serving BIGINT values. This becomes very busy during the Data Load phase, and are experiencing SEQUENCE_GENERATION waits. The cache_size is currently set to 100.

    I am aware that the higher it's set, the more values would be lost in the event of an outage, I am just interested in suggestions around the Cache value, without us just increasing / monitoring for effect.

    Many thanks for your suggestions.

  • May 23, 2016 at 7:27 am

    #1880764

    this should help

    https://www.simple-talk.com/sql/learn-sql-server/sql-server-sequence-basics/

  • May 23, 2016 at 8:48 am

    #1880790

    Thanks for the Response. I have read Joe's article, but he does not go into details of setting up the Cache - to quote "I am not going to explain Cache management. This is an implementation detail and I do programming."

    I am looking to get more information about how the Cache is best set / monitored.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply