sql-serverindexingpaginationsql-server-2016usage-statistics

sql server - can a single data row be split into multiple pages

I'm looking into Index Operational Statistics SQL Server 2016 report. One of the columns is named "# Locks" with two subcolumns, "Row" and "Page".

As per the report my Primary Key index has Locks on 350,000 rows and on 2.2 mln pages.

My understanding that 350,000 row were split between 2.2 mln pages.

So, can we split a single table data row into multiple pages?

Solution

  • SQL Server page size is 8KB, so if your row's data is larger than that it will definitely be split across multiple pages. SQL Server does this automatically.

    For further reference you can read this: Understanding Pages and Extents