ANZCO Foods Limited
 
Early this morning there was a requirement for a production database to be restored at short notice. [SQL Services] was tasked with the job, and performed an exemplary recovery of the situation, with informative and detailed narrative of the procedure. Despite A/V and laptop restrictions hampering efforts, the experience and end-result was smooth, professionally-handled and thorough. Thanks to [SQL Services’] efforts and analysis, future work efficiency on the servers is expected to improve considerably.
 
Paul Hannam, Software Support Officer, Theta Technologies Pty Ltd

Professional Services

DATA MODEL REVIEW

The Physical Data Model review looks at the physical layout of the database structure with the view to identifying issues that may impact data integrity, performance and security. Quite often application performance issues can be avoided or rectified by ensuring the physical database structure is reviewed and optimised. A number of areas of the physical database structure are assessed during this process such as table design, integrity constraints and indexes.

While storage is usually considered to be low cost, small improvements in database design can result in enormous savings on CPU usage, memory usage, network usage and backup size. This review looks at how these savings can be achieved and can identify the changes required to the physical database structure to bring about the improvements.

 To request information on Data Model Reviews, or any of SQL Services offerings, click here.
 
Microsoft Gold Data, Silver BI partner © Copyright SQL Services Limited 2005 - 2018. Oracle Partner Logo