Gen-i BOP
 
We have had some real issues with one of our clients applications. We didn’t have the in-depth SQL skills/knowledge that SQL Services have. Once SQL Services became involved they were able to pinpoint the issue and also back this up with solid evidence. SQL Services contribution was not only acknowledged by us but equally so by the client. I just wanted to say that we at Gen-i are hugely thankful to the work that SQL Services team have put into this account.
 
Alex Johnston, Project Manager – PMP

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 2005 - 2018. Oracle Partner Logo