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