R Meyyappan offers onsite and offsite consulting services
on the following areas
SQL Server Performance
SQL Server Performance Health Check
Performance Review of SQL
Server Application Design & Implementation
SQL Server Performance Troubleshooting Consulting for SAP
here to contact us for onsite or offsite consulting engagement.
SQL Server Performance Tuning Consulting Service:
Identifying and analyzing SQL Server Query execution
performance issues. To provide recommendations to improve
query performance by optimizing data structures (like data
types, indexes and table partitioning), rewriting stored
procedures, functions and queries, optimizing temporary
table and variable usage, tweaking plan caching, optimizing
query memory grants, creating plan guides and tuning
parallel query execution. Analyzing concurrency issues and
providing recommendations to improve performance and to
avoid lock waits and deadlocks.
Monitoring SQL Server workload and analyzing wait
types: To provide performance best practice guidelines on
server and database configuration, administration and
maintenance including database and tempdb file configuration
and location, file group, data compression, indexes,
statistics, fragmentation. Best practice guidelines on
Database Mirroring, Database Snapshots, Backup Compression,
Transparent Data Encryption and Resource Governor
configuration based on workload.
Monitoring SQL Server hardware configuration and
utilization: This will include recommendations to add/remove
CPU, Memory and Storage capacity to maximize the utilization
of existing hardware resource and to reduce the Total Cost
of Ownership (TCO).
Presentation and written report summarizing findings
and recommendations as prioritized action items.
Onsite: 3 to 5 days. Offsite is possible.
Customer has to provide a short introduction with
description of database performance issues. Optionally customers
can have some members of their development and administration
team to participate during the onsite engagement in order to
learn and continue the tuning process.
Feedback from past Consulting Engagements:
Troels, NNIT A/S, Denmark,
Offsite Consulting Engagement:
Seeing you work on a real production system /
problem was very impressive - structured approach and using the
very same scripts and tools that you showed during the course.
Operations Managment, Kapsch TrafficCom AG, Vienna, Austria,
We are very satisfied with Ramesh's onsite consulting
engagement; he did an excellent job by helping us identify major
performance issues in our SQL Server application and by
providing ways to address those issues. We are also satisfied
with the report he wrote and with the conference call he
As a result we are planning to engage him on a regular basis to
keep our SQL Server performance optimal. We would be happy to
recommend Ramesh to anyone who has performance issues related to
Stein Ove, IT
Manager, Komplett ASA, Sandefjord, Norway,
I want to thank you for doing a excellent job for us. The report
we got from you gave us a lot of valuable information.
You have helped us a lot with the job you did for us.
In my opinion, this is one of the best SQL
engagements I have ever seen.
As I said, you have done an excellent job for us, Thanks a lot
Developer, Det Norske Veritas AS, Olso, Norway,
Thanks for the workshop. I found it very useful as the topic
that you presented on Thursday was directly relevant to my
everyday work as a developer. The level of detail was excellent,
and issues concerning the handling of execution plans relating
to stored procedures was especially useful. The accuracy of your
findings was very good and I look forward to reading your report
Developer, Det Norske Veritas AS, Olso, Norway,
We found the workshop very useful. We learned how to attack the
kinds of problems we have, and got some concrete solutions to
some of our most serious problems.
Ramesh's consulting customers include Austria:
Allgemeines Krankenhaus Linz, BMD Systemhaus,
Bundesrechenzentrum, bwin, C07 IT
Operations, CMC Markets, derStandard, ERGO Insurance Service,
Fabasoft Austria, Greentube, IAEA (UN), Interwetten,
INTERSPORT, Kapsch, Linz AG, Mayr-Melnhof Karton, NÖM, ÖBB, OMV, Österreichische Post,
RACON West Software, Raiffeisen Bankengruppe, Raiffeisen
Informatik, S.Spitz, Salzburg AG, Siemens, TIWAG, UC4, Vinzenz
Gruppe, Wiener Zeitung,
Wirtschaftskammer Österreich; Bulgaria:
MobilTel; Czech Republic: Česká pojiťovna,
ČSOB Bank, GTS Novera, Telefónica O2, Vodafone; Denmark:
Danfoss, Egmont, NNIT; Finland: Cap Gemini,
Kemira, Pohjola; Germany: JAM Software, SAP AG;
Netherlands: De Nederlandsche Bank;
Norway: Acta, Aker Solutions, Det Norske Veritas(DNV),
Komplett; Russia: Mediatel; Serbia:
Tarkett; Slovakia: Adastra Corporation, VÚB
Banka; Slovenia: Bankart, Iskratel, KDD, Krka,
Mobitel, Pota Slovenije, Sava, SRC.SI; South Africa:
De Beers, Kumba, Sasol; Spain: CIE Automotive,
Gas Natural, ITP; Sweden: Sony Ericsson;
Switzerland: F. Hoffmann-La Roche, Philip Morris International; UAE: