Comments on: Changing Storage in an Always On Environment https://virtual-dba.com/blog/changing-storage-in-an-always-on-environment/ Remote Database Administration Tue, 25 Apr 2023 23:18:31 +0000 hourly 1 https://wordpress.org/?v=6.9.4 By: Thusitha Jayawardana https://virtual-dba.com/blog/changing-storage-in-an-always-on-environment/#comment-2947 Tue, 25 Apr 2023 23:18:31 +0000 https://virtual-dba.com/?p=30016#comment-2947 Great article. What are the steps that need to be followed when moving SQL Server Always On server storage from one Nimble array to another Nimble array? I am sure most of these steps are irrelevant in this situation.

]]>
By: Todd Harness https://virtual-dba.com/blog/changing-storage-in-an-always-on-environment/#comment-76 Wed, 26 Apr 2017 22:31:38 +0000 https://virtual-dba.com/?p=30016#comment-76 Ambrella,

If you are referring to the b-tree in how data is stored in both the table and the index, adding a clustered index keyed off of an incrementally generated identifier (think bigint) will do the trick. This will physically store the data sequentially in the underlying pages and extents. If your tables do not have a clustered index they will be stored as a heap and there will be no order to the storage of the data. If you are referring to indexes and the b-tree that is associated with index storage, I would recommend implementing a fill factor to allow for empty space to accommodate new rows to be added. This will not eliminate page splits but can help to reduce them.

]]>
By: Ambrella https://virtual-dba.com/blog/changing-storage-in-an-always-on-environment/#comment-74 Fri, 21 Apr 2017 02:01:46 +0000 https://virtual-dba.com/?p=30016#comment-74 Is there any way to force SQL server to write sequentially? Some function perhaps which adds intelligence to determine if the data can be added to a b-filled page, and not grab an empty b page?

]]>