I have a simple vb script based around

Set objSQLDMOApp = CreateObject("SQLDMO.Application")

Set objSQLList = objSQLDMOApp.ListAvailableSQLServers()

Once I had a list of all the servers I created a 'Central Management Server', in management...

R.P.

Thank you, your post was exactly what I was looking for.

Yea, sorry about not being more specific.

You can find / configure the location of the files through Management studio.

Connected to the SSAS server

Right click, scroll down to properties

Show Advanced...

mnDBA (10/5/2010)

---

From time to time, one of our SSAS databases disappears. I am trying to track down the who/when/how with regard to this happening.

I could trace all activity...

Well as it turns out, that process won't climb above the 1.6 mark, however, SSAS is indeed using all of the allocated memory. If you use the WMI to view...

Ignore what the other person said, not cleaning up backups is a waste of space. I stole part of your scirpt because cleaning up backups is important. Thanks! 🙂

We have a significantly smaller set of cubes on one server, when the users start pulling lots of data everything just crawls. Load times where significantly reduced by setting up...