total_request_count on sys. dm_resource_governor_workload_groups

S Lancaster 26 Reputation points
2022-09-28T18:28:04.017+00:00

I would like to know if the column “total_request_count” on sys. dm_resource_governor_workload_groups would be equivalent to a batch or a transaction at all.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,926 questions
0 comments No comments
{count} vote

Accepted answer
  1. PandaPan-MSFT 1,901 Reputation points
    2022-09-29T02:14:23.403+00:00

    Hi @S Lancaster ,
    SQL transaction is a single unit of work applied to a database. And you can check this link for more information:https://tracedynamics.com/what-is-sql-transaction/
    SQL batch means a series of SQL commands that are sent to the database server at once. And you can check this link for more information:https://dba.stackexchange.com/questions/222395/what-is-a-dbas-definition-of-batch
    At last we talk about the “total_request_count” . This is a task of SQL Server.

    Any task in SQL is must a batch.
    So we can get the conclusion that “total_request_count” is a batch.
    245873-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"


2 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 102.4K Reputation points
    2022-09-28T21:37:47.873+00:00

    That would be a batch of SQL statements. Recall that we have sys.dm_exec_sessions which lists all currently connected sessions and sys.dm_exec_requests which lists the sessions currently running something, that is a batch.

    0 comments No comments

  2. PandaPan-MSFT 1,901 Reputation points
    2022-09-30T08:21:42.643+00:00

    Hi @S Lancaster ,
    We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

    0 comments No comments