Post reply

T-sql commands to find the pages

  • April 21, 2010 at 8:25 am

    #1155369

    Sumanta-1056020 (4/21/2010)

    Thank you all for the reply.

    Anybody knows T-SQL commands to get the data pages for a particular table.

    Take a look at:

    sys.dm_db_index_physical_stats

    sys.dm_db_partition_stats

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

  • April 21, 2010 at 8:35 am

    #1155375

    Stefan_G (4/21/2010)

    The only thing I am trying to say is that in some cases there can be serious performance problems with sys.dm_db_index_physical_stats. You probably already knew this, but the the OP and everyone else reading this might not.

    I don't think I disagreed with that at any stage (in fact, I started off saying 'it is true').

    I would just say:

    (a) we don't know what size of data we are dealing with;

    (b) we don't know whether the target objects would benefit from being rebuilt or reorganised; and

    (c) what's the alternative method to find fragmentation levels anyway?

    So it's late again. Off to bed.

    Paul

    Paul White
    All articles available on SQL.kiwi
    @SQL_Kiwi

Viewing 2 posts - 16 through 16 (of 16 total)

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