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

Manoj Syamala
PRINCIPAL RSDE
.

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

  • Presently my work involves resource governance in the database kernel for multi tenant systems
  • I own the dev side of tuning engine backend of SQL Server Database Tuning Advisor that has shipped in multiple releases since 2005 (http://msdn.microsoft.com/en-us/library/ms173494.aspx ). 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.
Publications