• vk-kirov (12/14/2010)


    The bad news is that, according to BOL, "this view is applicable only to the tempdb database".

    I would not expect much change in SGAM pages in a normal database. Table creation rates should be low compared to tempdb, so frequent changes in SGAM page allocation is unusual.