Archive

Posts Tagged ‘Utilities’

SSAS Free drive space command

October 19, 2012 3 comments

Today i was reviewing some traces and saw 2 commands i had never noticed before which had been issued by SSMS, these are shown below.

SystemGetLogicalDrives

SystemGetAllowedFolders

The commands can be executed in a MDX query session.

SystemGetLogicalDrives returns the free space in MB for the disk drives that are contained within the server property  “AllowedBrowsingFolders”, see below for an example.

clip_image001

I have checked and the commands work in all versions of SSAS back to 2005 and anyone can run them.

Personally i think this is really useful and here a few reasons why.

  • Cut sysadmins out of the loop when maintaining space (this is a good thing Smile).
  • If your managing a remote dedicated SSAS server and have no access to the OS its a quick way to check space just like SQL Servers xp_fixeddrives & fn_fixeddrives()
  • You might use it when collecting space stats or alerting.
    SystemGetAllowedFolders gives you the directories configured in “AllowedBrowsingFolders”.
    I hope you find this useful! I passed the info onto one of the Dev teams i work with and they certainly will make good use of it.

SSAS Deployment essentials

March 30, 2011 Leave a comment

Over the recent years i have enjoyed the privilege of working on a number of different SSAS deployments. Some are huge, some are complex and some of them are huge and complex and most interestingly they all behave differently.

What i want to share today is what i consider to be essential for an SSAS installation. This covers what i expect to see installed to compliment SSAS, configuration settings to be changed and the literature that should be at your finger tips.

Read more…