Skip to main content
CCH Software User Documentation

CCH SQL and Server Optimisation Consultancy Online

  1. Last updated
  2. Save as PDF

Professional_Services_2.png

 

CCH Central optimal operation is key to the business function. 'Server and SQL optimisations' are designed to ensure that the system continues to deliver maximum availability, performance and reliability for your business. 'Service' is where our consultants review, advise and apply best practice and optimal configuration reflecting your environment.

CCH Central suite key underlying technology is Microsoft SQL Server. Whilst the database function is viable to operate within its parameters 'out of the box', it is a highly flexible product and benefits from careful optimisation in order to achieve best performance.

As part of our optimisation service, our consultant will review , discuss and plan the best approach for your system and suite deployment. Taking your specific requirements and enviroment into consideration to apply best practices to your SQL and System configuration. 

Due to nature of the tasks, consultancy is orientated to be carried out during maitenance window when system will be unavailable to users.

Details of our currently supported environment can be found here and should be reviewed as part of planning any technical work involving the CCH Suite of products. 

Note: This technical questionaire regarding your current environment should be completed prior to the process.

Information: It is recommended to take into consideration that the process can impact both 'user and system availability' and 'planning' from a business view.

The process breaks down into key components :

Review
  • Current Infrastructure Architecture 
  • System Resource Availablity
  • Suite Deployment Methodology 
  • CCH Product Versions and Update Process Available
  • Baseline SQL configuration
Action
  • Optimisation of Background SQL Configuration
  • Optimisation of Environment Resources and Configuration
  • Databases Health Check
  • Databases Optimisation
  • Configuration of Maintenance Tasks for Runtime Optmisation
  • Suite Deployment Optmisation in line with current best practices
  • Scoping of Future Environment Upgrades and Futher Deployment Improvements 

 

 

  1. Back to top
  • Was this article helpful?

Recommended articles

  1. Article type
    Topic
    Product
    Professional Services
  2. Tags
    This page has no tags.