Query or Automated process to Determine Size of Analysis Service Databases

Last Post 19 Mar 2008 07:59 AM by bemall. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
bemall
New Member
New Member

--
14 Mar 2008 01:43 PM
I need a query or means for determining the sizes of all analysis service databases. This will run periodically and produce a report for the managers. the only way for dinding out the size so far is by going through the properties window and or looking at the file sizes in windows. Any ideas
bemall
New Member
New Member

--
18 Mar 2008 06:35 AM
The query provided will only work in SQL Server. My question is with regard to SQL Server analysis services database sizes.
SQLUSA
New Member
New Member

--
18 Mar 2008 06:26 PM
You can take a look at the folder sizes for OLAP space estimates:

C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC SSAS, SSIS, SSRS - April 21-24: http://www.sqlusa.com/
bemall
New Member
New Member

--
19 Mar 2008 07:59 AM
Thank you for the suggestion however that does not answer my question either.
bemall
New Member
New Member

--
31 Mar 2008 09:15 AM
The solution for this can be implemented using interacting with AMO (Analysis Management Object)via Windows powershell, VB.NET or C# to query the analysis server object.


Acceptable Use Policy
---