Collections:
Page Size Varies on Azure SQL Database
What is the data page size on Azure SQL Database?
✍: FYIcenter.com
To find out the data page size on Azure SQL Database, we can run the SQL script, fyi_page_insert.sql, presented in the last tutorial with different @Size on Azure SQL Database.
The following table shows the summary of the test results. The PARTITION field is removed to save space. The PAGE_SIZE field is calculated as SIZE * COUNT / PAGES.
@@version = Microsoft SQL Azure (RTM) - 12.0.2000.8 May 2 2019 SIZE COUNT DURATION +ROWS ALLOCATION +PAGES FILE_ID PAGE_SIZE 256 100 424 100 IN_ROW_DATA 4 1 6400 512 100 386 100 IN_ROW_DATA 8 1 6400 1024 100 387 100 IN_ROW_DATA 22 1 4655 2048 100 420 100 IN_ROW_DATA 54 1 3793 4096 100 494 100 IN_ROW_DATA 100 1 4096 8192 100 403 100 IN_ROW_DATA 100 1 8192 16384 100 436 100 IN_ROW_DATA 100 1 16384 32768 100 470 100 IN_ROW_DATA 100 1 32768
As you can see:
⇒ Page Size Varies on SQL Server 2016 Database
⇐ Use allocation_units for I/O Tests
2019-05-12, 2305🔥, 0💬
Popular Posts:
How to generate date and time test values? Timestamp values are frequently needed in testing almost ...
How to find out my browser's identification information? To help you to see your browser identificat...
How to use HTTP protocol to post an XML message to a server? You can follow this tutorial to post an...
How to generate test phone numbers for US and Canada? Test phone numbers are frequently needed in te...
In what order thread groups are executed in JMeter? Thread groups, including regular "Thread Groups"...