Right now our main limitation is disk. We need to put separate databases
onto different disks. Is this something you can do with SSAS2005? I haven't
been able to find it yet.

We're basically looking to use File Groups.

I don't know what you want.

But you can put partition onto different position.

For example, after adding C:\ to AllowedBrowsingFolders server property, you
can select any folder of C: drive for partition.

Ohjoo


"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

We're coming up on disk speed issues. Memory isn't an issue nor is
processor, disk is out bottleneck right now. We need to put databases on
different drives in order to fix this.

Can this be done in SSAS2005?


"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote

Although we have to create a database on the same driver, is not almost the
same effect expected
if all partitions of the database are put on different drive?

Ohjoo


"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

No because we process Several databases at the same time and they all
compete for disk.


"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote

Does anyone know if this can be done?


"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote

open the property pages of your SSAS server.
add in the allowed folders list the list of drives\folders you want to
access.
like:
c:\|d:\|e:\|...
not the pipe (|) character as a separator. (there is a default list of
folders defined)
close the property page and open it again, now you can setup the default
folder for a new database.

to spread your databases in multiple drives, you can select for each
partition where to store the data or set the storage location of each cube
in a database in a different folder.

I think you can't change the dimension and metadata location. (I don't see
any option for this in the interface, but maybe there is other options not
available into the management console)

but if you can, try to create a Raid 0+1 array (specially if you have only 1
controller)
you'll improve the performance of all the databases.

but can you describes when you suffer disk issues?
and: how many disks you have? which Raid? and partition sizes?


"Jesse O." <jesperzz (AT) hotmail (DOT) com> wrote