Home Dashboard Directory Help
Search

SQL Analysis Services - Access to local disk from Clustered instance by John_Cas


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 770752
Opened: 11/11/2012 8:08:18 PM
Access Restriction: Public
0
Workaround(s)
view

Description

Our suggestion is to allow a clustered instance of SSAS to access a local physical disk (perhaps SSD) instead of shared disk allocated in the cluster.

We will maintain the sync of the cube files on the local disk manually.

In our environment, shared disk (SAN) is an expensive option, especially for the read IO that would benefit a cube. Our cubes are built in another environment and copied to the read environment for general access.

The benefit of local disk from the clustered instance gives us the benefit of cluster while allowing us flexibility in the storage section.





Details
Sign in to post a comment.
Sign in to post a workaround.