dbTalk Databases Forums  

script to find size of a cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss script to find size of a cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
sriram
 
Posts: n/a

Default script to find size of a cube - 02-23-2006 , 02:59 PM






Hi Gurus,

I have a situation where i have to make daily reports on the size of
the olap cube.
Do anyone of you have such kind of script.Can you please share it with
me.

And how can we find the size of a file from SQL 2000, is it possible?


Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: script to find size of a cube - 02-24-2006 , 04:54 AM






Basically you use the EstimateSize property of the MDStore object that
represents the Cube.

I have a working VBScript file that can be run from the command line
that will display cube sizes on my blog at:

http://geekswithblogs.net/darrengosb...les/70585.aspx

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1140728351.394590.177870 (AT) u72g2000cwu (DOT) googlegroups.com>,
sriram.ys (AT) gmail (DOT) com says...
Quote:
Hi Gurus,

I have a situation where i have to make daily reports on the size of
the olap cube.
Do anyone of you have such kind of script.Can you please share it with
me.

And how can we find the size of a file from SQL 2000, is it possible?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.