![]() Stored procedures executes the same way, statement by statement. A statement in a request must finish before the next starts, always. The request is executed statement by statement, sequentially.A free thread from SQL Server’s own thread pool picks up the request, compiles it and executes it.The request is placed in a queue inside SQL Server memory.The application sends a request to the server, containing a stored procedure name or some T-SQL statements.The grossly simplified explanation is that SQL Server executes your queries as follows: ![]() To be able to troubleshoot performance problems you need to have an understanding of how SQL Server works.
0 Comments
Leave a Reply. |