On Fri, Aug 10, 2012 at 5:32 AM, Sofija Blazevski < [email protected]> wrote:
> > This affected entire database (all generators actively in use), mostly > generators are used for Integer columns, some are used for varchar > columns in case like document number that has string prefix, the prefix > can vary within a table. > > I'm not sure how could type of column produce a problem like this? > > Values for generators are stored densely on a page - depending on the page size, somewhere between a lot and a whole lot fit on a page (4 bytes per generator, 4-16K bytes per page, less page overhead). Generator pages are written out when a transaction that changed them commits, so they should be written often. It's vaguely possible there's something going on with your disk... Good luck [Non-text portions of this message have been removed]
