Performance plays a very critical role in payment processing industry. And we were the last level of escalation for any performance or DBA level tasks for our client. Our client had long list of tasks that needed optimization.
 

We took a well defined approach to tackle the task. Our internally developed mechanism to trace all needed data were deployed on performance test servers.

A very through implementation was done to partition all important large tables. Deep analysis of execution plans was done for individual procedures.

All best practices related to indexing, tempdb configuration, storage,Code changes, query optimization and isolation levels were followed to make sure the performance met the client expectations.

All findings were well documented and tickets were raised for deployment of modifed objects. Clients employee were trained for the best practices to follow so that same mistakes are not repeated.