Statistics updating resource allocation

The processes by which resources (more broadly including income and consumption goods, tasks, leisure, and investments in human capital) are allocated among individuals and the outcomes of those processes.

You as the SQL Server DBA decide that updating database statistics is one possible solution to the problem, but your boss says that it will cause blocking and advises not to update statistics while the database is being used.

Some people say that a statistics update blocks transactional activity.


If you look back at the table with the column descriptions, you can see that it says different subtypes do not conflict with each other.While the statistics update is running, open a new session and execute the following query against sys.dm_tran_locks Dynamic Management View in order to analyze the locked resources by the statistics update.Notice that your session_id most likely will be different than the one in the following query.USE master GO SELECT resource_type , resource_subtype , resource_description , resource_associated_entity_id , request_mode , request_type , request_status , request_session_id FROM sys.dm_tran_locks WHERE request_session_id = 79 Represents a subtype of resource_type.

Acquiring a subtype lock without holding a nonsubtyped lock of the parent type is technically valid. Possible values are GRANTED, CONVERT, WAIT, LOW_PRIORITY_CONVERT, LOW_PRIORITY_WAIT, or ABORT_BLOCKERS.

(ii) Those dealing with composite scheduling rules.


  1. Pingback:

  2. eric   •  

    We take no responsibility for the content on any website which we link to, please use your own discretion while surfing the links.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>