Query Processor Architecture

SQL Server Architecture

SQL Server Architecture

Query Processor Architecture

SQL statements are the only commands sent from applications to Microsoft® SQL Server™ 2000. All of the work done by an instance of SQL Server is the result of accepting, interpreting, and executing SQL statements. The processes by which SQL statements are executed by SQL Server include:

  • Single SQL statement processing.

  • Batch processing.

  • Stored procedure and trigger execution.

  • Execution plan caching and reuse.

  • Parallel query processing.