I need information about what it is and how it is handled Fine granularity , especially in SQL Server . Thank you very much
I need information about what it is and how it is handled Fine granularity , especially in SQL Server . Thank you very much
Granularity refers to how fine you want a blockage to be. For example, do you want to block the entire table ( a thick granularity lock ) or just block a specific row ( a fine granularity block) ?
According to the microsoft documentation in general of the granularity it says the following:
The Microsoft SQL Server Database Engine supports multicangular blocking.
This function allows a transaction to block different types of resources. To minimize the cost of blocking, Database Engine automatically locks resources at the appropriate level for the task.
Locks of lower granularity, as in the case of rows, increase simultaneity. However, a greater overload occurs because the more rows are blocked, the more blockages must be maintained.
Locks made in a high granularity, for example in tables, reduce the simultaneity because blocking a whole table restricts the access of other transactions to any part of the table.
However, it causes a minor overload due to fewer blockages remaining.
You want to see more information Link