patternsqlModerate
Are SQL Server statistics stored in database or buffer pool?
Viewed 0 times
storedaresqldatabasestatisticsserverpoolbuffer
Problem
Just wondering are statistics kept in the database but not in the memory? If I backup/restore the database from a prod server to a development server, would it keep the same statistics so that execution plans won't be much different if I do it on the development server?
Solution
The buffer pool is a cache of the database. There is never an 'or', things that are in the buffer pool are also in the database, always. And anything read from the database must be, even temporarily, present in the buffer pool.
As for the question: statistics are in the database so a backup/restore will preserve the statistics.
Note though that preserving statistics is not a guarantee to plan reproducibility. Other factors influence plan generation, like number of CPUs and amount of RAM.
As for the question: statistics are in the database so a backup/restore will preserve the statistics.
Note though that preserving statistics is not a guarantee to plan reproducibility. Other factors influence plan generation, like number of CPUs and amount of RAM.
Context
StackExchange Database Administrators Q#41789, answer score: 16
Revisions (0)
No revisions yet.