Page History
...
To track this metric, use the CPU Call Rates chart in the CPU dashboard of the Server Overview tab.
...
- Transmitted to the server using the network.
- Parsed by SQL Server to check syntax.
- Have an execution plan compiled.
- Executed according to the execution plan.
- Have the results transmitted back to the client computer or Web sitewebsite.
Reduce the number and impact of T-SQL batches
...
- Reducing the size and complexity of the T-SQL by creating a stored procedure containing the commands you want executed to execute and then simply calling it in the T-SQL batch. This approach reduces the size and complexity of the T-SQL batch, which means less network traffic and less CPU time consumed producing a complex execution plan.
- Once you move most of the T-SQL code into stored procedures, consider grouping as many of those calling T-SQL commands into a single network batch, if possible. Also, consider redesigning the application to call only those stored procedures you need to complete an application function all from within one batch rather than sending each EXECUTE statement to execute separately in its own batch. This strategy reduces network queues dramatically as better use is made of the default 4 KB network packet size.
...