Collections:
Azure SQL Database Related Terminology
![]()
Azure SQL Database Related Terminology:
DTU - DTU (Database Transaction Unit) is a unit of measure of mixed resources of CPU, Memory and IO used to support Azure SQL database. The actual computing power provided by each DTU is based on your SQL database service tier. For example, at the "Standard" tier, each DTU will provide you a throughput of 2.5 IOPS (I/O Operations Per Second) and a latency of 5 ms to read and 10 ms to write.
IOPS - IOPS (I/O Operations Per Second) is a measurement on how fast a data storage device can perform read and write operations. IOPS is not a throughput measurement, it only gives you the total number of I/O operations. Throughput can be estimated by multiplying IOPS with I/O block size, which is 8 KB in most cases. For example, if a transaction executed 1000 IOPS and 8 KB per operation, the throughput is 8,000 KB/sec or 8 MB/sec.
SQL - SQL (Structured Query Language) is the standard language for relational database management systems.
⇒ IOPS Tests on Azure SQL Database with INSERT
⇐ Use Query Editor on Azure Portal
✍: FYIcenter.com
2019-07-05, ∼1777🔥, 0💬
Popular Posts:
What are JMeter command line options? You can get see JMeter command line options by running this co...
How to convert hexadecimal encoded data back to binary data (or Hex to Binary Decoding)? Hex to Bina...
What are date and time test values? Date and time test values are frequently needed in testing date ...
How to validate email address format? In order to help your programming or testing tasks, FYIcenter....
What are JMeter command line options? You can get see JMeter command line options by running this co...