TCO Cost Data access Admin overhead Perf Performance ■ Current Solutions Keep, keep, keep! Business owners, end-users, … ??? !#$^* DBA Cut, cut, cut! Storage admins, budget owners, …
Download
Report
Transcript TCO Cost Data access Admin overhead Perf Performance ■ Current Solutions Keep, keep, keep! Business owners, end-users, … ??? !#$^* DBA Cut, cut, cut! Storage admins, budget owners, …
TCO
Cost
Data
access
Admin
overhead
Perf
Performance
■ Current Solutions
Keep, keep,
keep!
Business owners,
end-users, …
???
!#$^*
DBA
Cut, cut,
cut!
Storage admins,
budget owners, …
No change to access controls, DBA processes, applications, tools, operations
Tradeoffs
Goals
Moderate performance reduction for
Cold data always online
cold data access
Significantly lower storage TCO
Access cold data with existing
applications
TCO
Cost
Easier performance and index
Update and delete on cold data is an
administrative function
Some functional limitations
maintenance
Faster backup/restore
Automatically managed and
protected cold data
Data
access
Admin
overhead
■ Stretch Database
Perf
Performance
■ Current Solutions
On-premises
SQL Server
Hot/online
business data
DBA scripts and tools work
as before; all controls still
held in local SQL Server
Business applications
continue working
without disruption
Developers continue
building or enhancing
applications with existing
tools and methods
Trickle data move
Transparent remote
query processing
Cold/closed
business data
Enabling Stretch Database
Data movement
Stretching a table
Querying a stretched table
Backup & restore
On-premises
On-premises
application(s)
Azure
Onpremises
SQL Server
instance
Compute
Storage
DB in SAN/Local
Storage
Ord_Detail
Txn_detail
Ord_detail
_archive
table
Hot +
cold
rows
On-premises
On-premises
application(s)
Azure
Onpremises
SQL Server
instance
Trickle data migration
Compute
Storage
DB in SAN/Local
Storage
Ord_Detail
Ord_detail
_archive
table
Txn_detail
Hot +
cold rows
in same
table
Ord_detail
_archive
table
Txn_detail
(cold rows
only)
Only cold
Entire
archive table rows moved
moved
On-premises
Azure
Local +
Local data
remote data
only queries
queries
On-premises
application(s)
Onpremises
SQL Server
instance
Trickle data migration
Compute
Transparent remote
data access
Storage
DB in SAN/Local
Storage
Ord_Detail
Ord_detail
_archive
table
Txn_detail
Hot +
cold rows
in same
table
Ord_detail
_archive
table
Txn_detail
(cold rows
only)
On-premises
On-premises
application(s)
Azure
Onpremises
SQL Server
instance
Compute
Storage
Shallow
Regular backup
& restore
Table 11
Table
Table 1’
Table 2
2
Table
DB in SAN/Local
Storage
Ord_detail
Txn_detail
Ord_detail
_archive
table
Txn_detail
(cold rows
only)
On-premises
On-premises
application(s)
Azure
Onpremises
SQL Server
instance
Compute
Transparent scaleout
DB in SAN/Local
Storage
Ord_detail
Txn_detail
Storage
Shard 1
Ord_detail
_archive
table
Txn_detail
(cold rows
only)
Storage
Shard 2
Ord_detail
_archive
table
Txn_detail
(cold rows
only)
NO PURCHASE NECESSARY. Open only to event attendees.
Winners must be present to win. Game ends May 9th, 2015.
For Official Rules, see The Cloud and Enterprise Lounge or
myignite.com/challenge
http://myignite.microsoft.com