Transcript NAV-17 Dynamics NAV 2016 on Azure SQLx

Microsoft Dynamics NAV
Dynamics NAV 2016
one Azure SQL
Dmitry Chadayev
Microsoft
the cloud
service in
8
BASIC
•
STANDARD
PREMIUM
Small databases with a
light transactional
workload.
The go-to option for
most applications.
Mid-level performance
to support multiple
concurrent
transactions.
Designed for missioncritical databases. Offers
the highest level of
performance and access
to advanced business
continuity features.
Predictable hourly
transaction rates.
Predictable per minute
transaction rates.
Predictable per second
transaction rates.
Performance level:
Basic
Performance levels:
S0, S1, S2, S3
Performance levels:
P1, P2, P4, P6
More information
Service Level
Complex Support
Custom Solutions
Performance
Tiers
Measure of
power
Across the service tiers, each performance level is assigned a
defined level of throughput for a streamlined experience
Defined using the Database Throughput Unit (DTU) which
represents database power and replaces hardware specs
% CPU
Reads
Writes
Compute
Memory
% read
% write
DTU is defined by the bounding box for
the resources required by a database
workload and measures power across
the performance levels.
Basic — 5 DTU
% memory
S0 — 10 DTU
S2 — 20 DTU
S3 — 50 DTU
S4 — 100 DTU
P1 — 125 DTU
P2 — 250 DTU
P4 — 500 DTU
…
Point In Time Restore
Geo-Restore
Designed to return your
database to an earlier point in
time.
Provides the default recovery
option when database is
unavailable because of an
incident in the region where
your database is hosted.
Uses the database backups,
incremental backups and
transaction log backups that
the service automatically
maintains for every user
database.
Relies on database backups in
geo-redundant Azure storage.
ERT (Estimated Recovery Time)
< 12 h
RPO (Recovery Point
Objective) < 1 h
Standard GeoReplication
Designed for applications that
have more aggressive
recovery requirements than
Geo-Restore can offer.
When the primary database
fails you can initiate failover to
a non-readable secondary
database stored in the DR
(disaster recovery) paired
region.
ERT < 30 sec ; RPO < 5 sec
Active Geo-Replication
Available only for Premium
databases for write-intensive
applications with the most
aggressive recovery
requirements.
You can create and initiate
failover to up to four readable
secondaries on servers in
different regions.
ERT < 30 sec ; RPO < 5 sec
Business continuity is about designing, deploying and running your
application in a way that it is resilient to planned or unplanned disruptive
events that result in permanent or temporary loss of the application’s ability
to conduct its business function.
• More information
Replicas Enable Database High Availability
•
•
•
•
Single Logical
Database
T-SQL Query
DB
Read
Write
Ack
Ack
S
Ack
P
Write
Majority quorum up to 4 replicas
Transparent automatic failover
Uptime SLA of 99.99%
Zero user or admin config
P
S
S
Write
Reads are completed at the primary
Writes are replicated to secondaries
S
logical server
Subscription
Subscription
Logical
Server 1
Server
Logical
Server 2
Database
master
UserDB1
Logins/Users
Logins
Users
…
https://msdn.microsoft.com/en-us/jj650015
https://msdn.microsoft.com/en-us/library/mt204009.aspx
https://azure.microsoft.com/en-us/downloads/
https://azure.microsoft.com/en-us/pricing/details/sqldatabase/
Cost
Service level
agreement (SLA)
and compliance
Administration
Business
continuity
Built-in
supportatfora
Billed hourly
high
availability
,
Multiple
built-in
business
Database-level
availability
fixed rate,
instead
of
continuity
automaticfeatures
backups,
having
to pay for a
SLA
of 99.99%
data
protection
SQL license
upfront and
fault tolerance
The database software is
Eliminates
hardware
Point
in Time
Restore,
Azure
certifications
automatically
patched, :
Geo-Restore,
andEU
Geocosts,
near-zero
ISO,
HIPAA
BAA,
and
upgraded
by
Replication
Model
Clause
administrative
costs
Microsoft
Azure
Predictable
performance
and scalability
Setup and
administration
Simple
migration path
Familiar SQL
Server tools
and APIs for
developers
and admins
Make use of
Upload
and
Azure
takes care
Focusperformance
on
rapid
monitoring
and
Adjust
Nearly
complete
Access
via
REST
API,
of the physical
Connect
securely from
applicationyour
manage
troubleshooting
and scale without
PowerShell,
Azure
Portal, Microsoft
compatibility
resources
of the with
Dynamics
NAV
development,
rather
existing
database
via
features
for
index
SQL
Management
downtime
underlying
the
SQLand
Server
SQL
Server
engine
thanServer
managing
theor 2016
Azure
Portal, SSMS
tuning
queries
Studio
instance
optimization
aninfrastructure
API
6 How Do I Videos
https://mbs.microsoft.com/partnersource/northamerica/readinesstraining/readiness-training-news/VideoSeriesNAVPerformanceTesting
O365 Auth.
User/Password
SP
BI
• On this page you will have access to resources for developers, consultants, sales and business
decision makers. For more detailed information please visit our readiness library, which includes a
variety of materials such as how-to videos, demo scripts, white papers and slide decks.
• https://mbs.microsoft.com/partnersource/global/readiness-
training/NAVGetReady
• https://azure.microsoft.com/en-us/documentation/articles/sql-database-
technical-overview/
Learn more
http://aka.ms/NAVGetReady
SQL DB
V12