Question
2
Replies
2355
Views
Posted: January 21, 2017
Last activity: February 7, 2017
Closed
Solved
Why editable Data Pages do not have a node scope but only thread or requestor?
Editable data pages do not have a node scope but only thread or requestor. Why is that? My guess is because the node level data pages can be accessed by different requestors on the node, locking would be a potential issue. To avoid locking node level data pages are not editable. Any comments?
Hi ,
Yes, node level datapages , are always , read-only, and not editable. Because , a node level datapage , is the one that can be accessed by many requestors on the current node . If it is maintained as editable, we need to take care of locking issues,which is of high cost.
Hence mainly node level datapages are used for storing common, typically more static, reference data.