Home » Microsoft » 70-473 v.2 » Which three metrics should you evaluate?
You are evaluating the migration of an on-premises Microsoft SQL Server database to a Microsoft Azure SQL database.
You need to identify the minimum service tier required to host the database.
Which three metrics should you evaluate? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. the concurrent sessions
B. the I/O latencies
C. the number of worker threads
D. the max degree of parallelism
E. the database size
Correct Answer: ABE
Explanation/Reference:
A: The maximum number of sessions and workers are determined by the service tier and performance level (DTUs and eDTUs).
B: Performance levels are calibrated and governed to provide the needed resources to run your database workload up to the max limits allowed for your selected service tier/performance level. If your workload is hitting the limits in one of CPU/Data IO/Log IO limits, you will continue to receive the resources at the maximum allowed level, but you are likely to see increased latencies for your queries.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers
https://azure.microsoft.com/en-us/blog/azure-sql-database-introduces-new-near-real-time-performance-metrics/
