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, 2723🔥, 0💬
Popular Posts:
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...
Where to find tutorials on Test Management? I want to know how to manage software testing documents ...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to generate email addresses? To help you to obtain some email addresses for testing purpose, FYI...