SQLAuthority News – Scale-Out Querying with Analysis Services Using SAN Snapshots

White paper describes the use of virtual copy Storage Area Network (SAN) snapshots in a load-balanced scalable querying environment for SQL Server 2005 Analysis Services.

This architecture provides the following improvements

  • Improves the utilization of disk resources
  • Optimizes cube processing operations
  • Supports dedicated snapshots for specific users at different points in time

In selecting a snapshot implementation for use with for Analysis Services, users may wish to consider the following snapshot attributes:

  • Provisioning of snapshots
  • Writeability of snapshots
  • Scalability of snapshots
  • Performance of snapshots
  • Efficiency of snapshots

I have created this article here only to promote the original White Paper, which is very easy to read and describes the SAN configuration with Database.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s