title: How can I check the size of MS PDW table?
body: <p>The way of checking the table space size in MS SQLServer I've known is </p>
  
  <pre><code>sp_spaceused [tablename]
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>SELECT 
      t.NAME AS TableName,
      p.rows AS RowCounts,
      SUM(a.total_pages) * 8 AS TotalSpaceKB, 
      SUM(a.used_pages) * 8 AS UsedSpaceKB, 
      (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
  FROM 
      [sys].[tables] t
  INNER JOIN      
      [sys].[indexes] i ON t.OBJECT_ID = i.object_id
  INNER JOIN 
      [sys].[partitions] p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
  INNER JOIN 
      [sys].[allocation_units] a ON p.partition_id = a.container_id
  WHERE 
      t.NAME NOT LIKE 'dt%' 
      AND t.is_ms_shipped = 0
      AND i.OBJECT_ID &gt; 255
  GROUP BY 
      t.Name, p.Rows
  ORDER BY 
      t.Name
  </code></pre>
  
  <p>But I can't find the [sys].[allocation_units] table in MS PDW (SQL Server 2012 Parallel Data Warehouse).</p>
  
  <p>So it is hard to check the table size.</p>
  
  <p>How can I know the table space size ??</p>