By: Rob Verschoor & Irfan Khan

This presentation will give you an understanding of how ASE processes a transact-SQL query, from initial parsing, compilation to execution. The session will traced the route of the various ASE resource managers including (Lock, buffer, memory, etc. ) and showed how they coordinate resources to fulfil a query.

The slides will give you a valuable insight as to how the query processing within ASE is performed and will equip you with the necessary skills to troubleshoot performance issues.