startCCH SQL and Server Optimisation Consultancy Online
How To

CCH SQL and Server Optimisation Consultancy Online

Training and Consultancy
Last update: Reading time 1 minutes
ConfigurationSQL ServerTechnical Services

    CCH Central optimal operation is key to the business function​

    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.​

    'Server and SQL optimisation consultancy is designed to ensure that the system continues to operate in healthy and optimum configuration giving reliable service to your business. As part of the session , our consultant will review , discuss, and plan the best approach for your system and suite deployment. ​

    Taking your specific requirements and environment 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 maintenance window when system will be unavailable to users.​

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

    Note: ​Please complete the questionnaire regarding your current environment prior to the process.​

     During the session, the system will be unavailable to users.

    Agenda

    • Current infrastructure architecture ​

    • System resources review​

    • Suite deployment methodology and optmisation​

    • CCH suite version review and update​

    • SQL Backup review and optmisation​

    • SQL configuration review and optimisation​

    • CCH suite databases health and optimisation​

    • Future actions

    Related documents

    CCH Compliance Pack Implementation
    This document outlines an implementation session aimed at assisting users with the effective set up of CCH Tax and Accounting software. The session will cover best practices, compliance options, pre-configuration checks, data migration discussions, and training opportunities. Key objectives include reviewing current processes and confirming tasks and responsibilities. Target participants are decision-makers and managers. The session lasts up to three hours and includes an agenda focused on operations, data security, compliance training, and useful resources such as eLearning and webinars.
    Azure Information
    This document provides guidance on selecting Azure architecture and hardware provisioning specifically for SQL Server. It recommends the Ebdsv5/Ebsv5 series for those seeking optimal performance and cost-effectiveness. Key advice includes prioritizing P core processors, focusing on clock speed over core count for SQL performance, and utilizing Proximity Placement Groups. Relevant Microsoft resources for best practices and pricing strategies are linked, as well as additional support materials for products and training from Wolters Kluwer.
    CCH Accounts Production Corporate: Refresher (10134647/10134661)
    A streamlined service for existing users who require a quick update or refresher on key processes within CCH Accounts Production. This service is ideal for those returning to CCH Accounts Production after a break or seeking to refresh their skills in line with current standards and software updates. 
    CCH Accounts Production Corporate: Professional online (10134646)
    An advanced programme for experienced users of CCH Accounts Production who wish to develop their expertise or update their knowledge. This service covers the latest updates, advanced functionalities, and troubleshooting techniques, helping users to stay current and maximise efficiency in their accounts production work. 
    CCH Accounts Production Corporate: Practitioner (10134645/10134660)
    A comprehensive onboarding programme for new users with little or no prior experience of accounts production software. This service covers accounts production for corporate entities, guiding users through CCH Central and CCH Accounts Production software.