Alert me cube size by sql query

• Shanmuga Raj

  Ten Centuries

  Points: 1178

  More actions

  February 5, 2015 at 12:28 am

  #314920

  I need to write an query to fetch the size of the cube from SQL server.

  This will help me to send the daily cube size after processing and have an record. I dont want to go to manually right click the cube and see the properties for the size.

  In case of Database, i have the query as

  [font="Courier New"]

  SELECT CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2)) Size_MB ,

  CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))* 0.001 Size_GB FROM sys.master_files WITH(NOWAIT)

  WHERE database_id = 6 [/font]

  I need similar query for the cube size

• PB_BI

  SSCoach

  Points: 17461

  More actions

  February 10, 2015 at 6:18 am

  #1776601

  Install the ASSP assembly on the AS instance (http://asstoredprocedures.codeplex.com/)

  Then run the following:

  CALL ASSP.DiscoverXmlMetadataFull("\Databases\Database")

  That's the only way I know of to look at it programatically unless you start querying the file system from SQL.

  ---

  I'm on LinkedIn