Return to Question

deleted 1 character in body; edited tags

Source Link

edited May 18, 2021 at 13:41

44.1k
14
140
514

In a Service Broker queue, when one message is proceed over time, we are executing a stored procedure which is performing some heavy operations using temporary tables.

I guess that the sp_who_isactivesp_WhoIsActive is showing summarized values for tempdb allocations and CPU usage, as the queue is using one session.

The question is, are the allocations released when the current stored procedure completes?

In a Service Broker queue, when one message is proceed over time, we are executing a stored procedure which is performing some heavy operations using temporary tables.

I guess that the sp_who_isactive is showing summarized values for tempdb allocations and CPU usage, as the queue is using one session.

The question is, are the allocations released when the current stored procedure completes?

In a Service Broker queue, when one message is proceed over time, we are executing a stored procedure which is performing some heavy operations using temporary tables.

I guess that the sp_WhoIsActive is showing summarized values for tempdb allocations and CPU usage, as the queue is using one session.

The question is, are the allocations released when the current stored procedure completes?

Source Link

asked May 18, 2021 at 12:21

gotqn

4.3k
11
51
89

When tempdb allocations are released?

In a Service Broker queue, when one message is proceed over time, we are executing a stored procedure which is performing some heavy operations using temporary tables.

I guess that the sp_who_isactive is showing summarized values for tempdb allocations and CPU usage, as the queue is using one session.

The question is, are the allocations released when the current stored procedure completes?

sql-server t-sql sql-server-2019 standard-edition