Tuesday, November 08, 2005

Scalable Shared Databases in SQL Server 2005

Scalable Shared Databases supported by Sql Server 2005 RTM

"Scalable shared databases
The scalable shared database feature allows you to attach a read-only reporting database to multiple server instances over a storage area network (SAN). A reporting database is a read-only database that is built from one or more production databases that are used exclusively for reporting purposes. To be made into a scalable shared database, a reporting database must reside on one or more dedicated, read-only volumes whose primary purpose is to host the reporting database or a coordinated set of reporting databases. These volumes are known as reporting volumes. ..."



This is the first I've heard of this feature... So multiple SQL Servers all pointing to the same read only report data DB. Interesting... I've run into reporting perfromance "issues" in the past so I can see where this could be very useful.

Check out http://support.microsoft.com/Default.aspx?kbid=910378 for more information...

No comments:

Post a Comment

NOTE: Anonymous Commenting has been turned off for a while... The comment spammers are just killing me...

ALL comments are moderated. I will review every comment before it will appear on the blog.

Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...

I reserve, and will use, the right to not approve ANY comment for ANY reason. I will not usually, but if it's off topic, spam (or even close to spam-like), inflammatory, mean, etc, etc, well... then...

Please see my comment policy for more information if you are interested.

Thanks,
Greg

PS. I am proactively moderating comments. Your comment WILL NOT APPEAR UNTIL I approve it. This may take some hours...