SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Database Snapshots Expand / Collapse
Author
Message
Posted Tuesday, December 30, 2008 12:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: Administrators
Last Login: 2 days ago @ 8:26 PM
Points: 23,166, Visits: 6,925
Comments posted to this topic are about the item Database Snapshots
Post #627083
Posted Tuesday, December 30, 2008 1:00 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, March 17, 2010 11:21 AM
Points: 9,104, Visits: 8,528
I think a better question is "Whats a shared scalable database?" This is the first time that I have ever heard of it. Amazing.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #627570
Posted Tuesday, December 30, 2008 1:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, June 24, 2009 1:05 PM
Points: 25, Visits: 42
Can someone provide information about "a shared scaleable database"?
Post #627573
Posted Tuesday, December 30, 2008 1:08 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:12 PM
Points: 1,586, Visits: 4,456
sheppc1214 (12/30/2008)
Can someone provide information about "a shared scaleable database"?


Sounds like marketing BS.

A database has to be "shared", or it wouldn't really be much of a database.

As for "scaleable", is there a vendor out there that would say theirs isn't?

Post #627578
Posted Tuesday, December 30, 2008 1:09 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, March 17, 2010 11:21 AM
Points: 9,104, Visits: 8,528
From the 2008 BOL:

The Scalable Shared Database feature enables you to scale out a read-only database built exclusively for reporting (a reporting database). The reporting database must reside on a set of dedicated, read-only volumes whose primary purpose is hosting the database. By using commodity hardware for servers and volumes, you can scale out a reporting database that provides the same view of the reporting data on multiple reporting servers. This feature also allows a smooth update path for the reporting database. For more information, see Scalable Shared Databases Overview.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #627581
Posted Tuesday, December 30, 2008 1:30 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:12 PM
Points: 1,586, Visits: 4,456
RBarryYoung (12/30/2008)
From the 2008 BOL:

The Scalable Shared Database feature enables you to scale out a read-only database built exclusively for reporting (a reporting database). The reporting database must reside on a set of dedicated, read-only volumes whose primary purpose is hosting the database. By using commodity hardware for servers and volumes, you can scale out a reporting database that provides the same view of the reporting data on multiple reporting servers. This feature also allows a smooth update path for the reporting database. For more information, see Scalable Shared Databases Overview.


Interesting, but it sounds like a kludge.

Does anyone know of a situation where someone has actually implemented this?




Post #627600
Posted Monday, March 09, 2009 8:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 12:18 PM
Points: 18, Visits: 76
I'm proposing the Scalable Shared Database architecture at my current client and will probably start a proof of concept shorty. I'm a little concerned that none of the BI friends I've talked with have seen this implemented.

Has no one implemented this?

Victor Alcazar
Vihho Technology
Post #671586
« Prev Topic | Next Topic »


Permissions Expand / Collapse