Home > Partitioned Tables Storage Info > How to get Partitioned Tables Storage Info

How to get Partitioned Tables Storage Info

I hope this will help DBA in getting information regarding Partitioned Objects and Storage Information

 USE <DatabaseName>

SET @Object_id=OBJECT_ID(‘Table Name’ ) 

SELECT OBJECT_NAME(si.object_id) TbName,si.name,si.index_id,si.data_space_id,sds.name,sp.index_id ,
sp.partition_id,sp.partition_number,sp.rows,sau.container_id,sau.total_pages,sau.used_pages,sau. data_pages
from sys.indexes si
         INNER JOIN sys.data_spacessds
si.data_space_id=sds. data_space_id
INNER JOIN sys.partitionssp
si.index_id=sp.index_id and si.object_id=sp. object_id
INNER JOIN sys.allocation_unitssau
sp.partition_id=sau. container_id
where si.object_id= @Object_id
GROUP By OBJECT_NAME(si.object_id) ,si.name,si.index_id,si.data_space_id,sds.name ,
sau.container_id,sau.total_pages,sau.used_pages,sau. data_pages
ORDER BY sp.partition_number  





  1. December 15, 2010 at 2:26 pm

    hello I was luck to approach your subject in google
    your subject is impressive
    I learn a lot in your blog really thanks very much
    btw the theme of you site is really fine
    where can find it

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: