Share on Facebook Tweet on Twitter Share on LinkedIn Share by email
Manoj Syamala

Manoj Syamala

I work as a Software Design Engineer in the DMX group. 

  • As a member of the SQLVM team (, designed and implemented the SQL Azure I/O resource governor mechanism in the database kernel. Some of the interesting challenges the code had to deal with were  - a new I/O scheduling mechanism aligned with the SQL OS scheduler, scaling to thousands of database tenants on one node and accommodating more than one, possibly heterogeneous throughput capacity storage media.
  • Implemented mechanisms for a multi-tenant, shared buffer pool governance in SQL Engine . This involved adapting novel algorithms to modify storage engine’s traditional page replacement policy (LRU-K based) to different SLA aware replacement policies.
  • I own the dev side of tuning engine backend of SQL Server Database Tuning Advisor that has shipped in multiple releases since 2005 ( ). DTA analyzes a representative workload consisting of queries and updates that run against the database engine and recommend appropriate changes to physical design for the workload. Recent work include tuning workload from the engine query plan cache, recommending compressed indexes , filtered indexes and extending existing index selection algorithms to exploit multiple processors.
  • I have worked on workload driven index defragmentation in the database engine. We developed low overhead techniques to identify and defragment a logical range rather than the whole physical B-Tree based on the workload, making the index reorganize/rebuild operation amenable to online and zero admin settings.
  • In the past I have worked on developing a framework for dynamic profiling and static analysis of database centric applications.We adapted profiling techniques and traditional program analysis (using extensible compiler framework Microsoft Phoenix) by leveraging understanding of call level data access APIs.