Transcript Scott Klein Thomas LaRock [email protected] [email protected] • • • • • • • Total Capacity Total Request Rate Total Bandwidth (Geo-redundant) Total Bandwidth (Locally Redundant) 500 TB 20,000 / sec 10 gb/sec Ingress 20 gb/sec Egress 20 gb/sec Ingress 30

Scott Klein
Thomas LaRock
[email protected]
[email protected]
•
•
•
•
•
•
•
Total Capacity
Total Request Rate
Total Bandwidth
(Geo-redundant)
Total Bandwidth
(Locally Redundant)
500 TB
20,000 / sec
10 gb/sec Ingress
20 gb/sec Egress
20 gb/sec Ingress
30 gb/sec Egress
http://msdn.microsoft.com/en-us/library/azure/dn249410.aspx
VM Size
CPU Cores
Memory
Max. IOPS
# Data Disks
Temp Drive
A0
Shared
768 MB
1x300
1
20 GB
A1
1
1.75 GB
2x300
2
40 GB
A2
2
3.5 GB
4x300
4
60 GB
A3
4
7 GB
8x300
8
120 GB
A4
8
14 GB
16x300
16
240 GB
VM Size
CPU Cores
Memory
Max. IOPS
# Data Disks
Temp Drive
A0
Shared
768 MB
1x500
1
20 GB
A1
1
1.75 GB
2x500
2
70 GB
A2
2
3.5 GB
4x500
4
135 GB
A3
4
7 GB
8x500
8
285 GB
A4
8
14 GB
16x500
16
605 GB
VM Size
CPU Cores
Memory
Max. IOPS
# Data Disks
Temp Drive
A5
2
14 GB
4x500
4
135 GB
A6
4
28 GB
8x500
8
285 GB
A7
8
56 GB
16x500
16
605 GB
* http://msdn.microsoft.com/library/azure/dn689095.aspx
Disk type
Read Only
Read Write
None
OS Disk
Supported
Default
Not Supported
Data Disks
Supported
Supported
Default
Enable instant file initialization
Logical disk counter
Disk reads / second
Typical storage term
IOPS
Suggested actions in
Windows Azure virtual machine environment
Measure the number of I/O’s per second.
Consider adding more data disks in line with your IOPS requirements.
Disk writes / second
Latency
Average disk sec / read
Measure disk latency.
Note: Numbers might vary; look at averages over time.
Average disk sec / write
Block size
Average disk bytes / read
Note: Larger I/O’s tend to have higher latency, such as those associated with
BACKUP/RESTORE.
Average disk bytes / write
Average / current disk queue length
Disk read bytes/sec
Disk write bytes/sec
Measure the size of I/O’s being issued.
Outstanding or waiting IOPS
Throughput or aggregate
throughput
Provides insight into the applications I/O pattern.
Measure of total disk throughput.
Note: Ideally, larger block scans should be able to heavily utilize connection
bandwidth (for example, your throughput can be higher with a smaller number
of larger IOPS).
BACKUP database TO URL =
‘
’
WITH CREDENTIAL = ‘credential_name’
CREATE CREDENTIAL
Identity
Secret
E.g.
CREATE CREDENTIAL mystorage
WITH IDENTITY = ‘mystorage',
SECRET = ‘xxxxxxx’
http://www.trySQLSever.com
http://www.powerbi.com
http://microsoft.com/bigdata
Performance Guidance for SQL Server in Windows
Azure Virtual Machines Whitepaper
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn