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

Status : 


Sign in
to vote
ID 770752 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 11/11/2012 8:08:18 PM
Access Restriction Public


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.

Sign in to post a comment.