Contact Energy
 
The SQL Server migration was 100% successful: there were no incidents of any severity. It was done in record time… this one took the same number of days that the previous migration took in weeks. I credit Kokila with the speed, ease and seamless completion of the migration. It was a genuine pleasure to work with such a competent DBA. She made the whole task look easy. I would highly recommend Kokila for any DBA work you may require in the future.
 
Mike

Professional Services

PERFORMANCE TUNING

Performance of a database application is dependent on many variables including network infrastructure, server hardware, size, configuration and design of the database and efficiency of application coding. Therefore when application performance issues arise it is important to properly analyse all areas of the database application, otherwise money and time may be spent on areas which in fact are not the cause of the performance issues, and which only generate small performance gains.

For example, upgrading server hardware in response to application performance problems, can be expensive in both time and money, and may not be the fundamental performance bottleneck. In fact, performing a complete and thorough analysis end-to-end, to resolve the fundamental performance bottleneck, may negate the requirement to upgrade server hardware at all.

SQL Services offers a Performance Audit/Troubleshooting service for SQL Server and Oracle databases. A template approach is utilised using various system tools, including such items as Performance Monitor and internal RDBMS tools to isolate key performance bottlenecks in databases. A formal report is then provided to customers with recommendations for action to resolve or reduce performance bottlenecks. If the exercise identifies application-specific issues these can be passed to the application supplier/developer for resolution at the customer’s request.

To request information on Performance Tuning, or any of SQL Services offerings, click here.
 

Microsoft Gold Data, Silver BI partner © Copyright SQL Services Limited 2018. For information on how SQL Services processes personal data please refer to our group privacy statement on our Group Website URL Privacy Statement Oracle Partner Logo