Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Partition Sizes

Author  Topic 

krishshankar
Starting Member

1 Post

Posted - 2009-08-18 : 04:30:41
I’m a SQL Server newbie and currently I’m trying to document the Partition information, i.e., partitions available, the objects residing in the partitions along with the partition data size for a SQL Server 2005 environment.

I have looked at the available tables and DMVs(sys.partition_functions, sys.partition_parameters, .partition_range_values, sys.partition_schemes, sys.partitions, sys.dm_db_partition_stats) but this are not providing the information I require.

Request you to let me know how I can achieve this.

TIA
   

- Advertisement -