This section describes all of the database configuration that is required for running a ServiceOptimizer instance. Certain areas will only need to be set up once, when the Database is first created. Others will need to be reconsidered/altered on each upgrade of the code, or where an existing database is to be used for a different instance (e.g. where a production database is imported into a Development instance). All of the following questions need to be considered in each case:

Read through all of these prior to following up on any one, as there may be requirements that cross boundaries.

Question	Sections to consider	New Database	Reusing/upgrading Database
How should the various processes be spread across the one or more server machines to be used?	Example Configuration System Start Up Admin ServiceOptimizer System Configuration Distributed System	resources of each server size of the processes expected throughput of the processes required restart times for the processes (based on timezones)	Has the size of any one of the processes changed (more employees added, larger volume of jobs? Has there been a reorganisation of the geography, hence bringing about the above?
Are multiple gantt routers required?	Multiple GanttRouters	how many gantts required for whole instance how many gantts required for each FRU how will their login be spread time wise	has either the number, or spread, of gantt users changed
Which UI features are required by the business?	UI Support	Required Gantt Reports? Is ServiceManager being used? Does the gantt need access to ServiceManager	Any change in the required Gantt Reports? Any change in use of ServiceManager?
Does the API interface need to be secure?	System Start Up	what is the security strategy for integrations? is there an SSL certificate available	is a different certificate needed for this instance?
Does any business functionality need to be enabled directly in the database?	Business Functionality	what functionality does the business require? what has been set up by the ServicePower consultants instance calendar booking ranges	Any change in business usage?
How should the logfiles work?	Application Logfiles	Available resources Is auditting switched on	Any change in available resources Is there a need for support on a specific component?
What Travel Matrix (or Travel Matrices) should be used?	How the Travel Matrix works	does a single TM suffice for the whole instance is the instance distributed	are you adding a new geography has there been a change in the distribution of processes
What auditting is required within the system?	Auditing	what logging is required for automated processes what logging is required for manual processes what support needs are there	is there a specific need for support is there a specific need for performance
What time zones are required for the vaious parts of the business and business processes?	Time Zones	what geographies are covered by the instance what is the TM of the server(s)	have the geographies changed have new geographies been added have the servers been moved
What is the auto-restart/recovery strategy?	Admin ServiceOptimizer Further Detail Setting up Auto-Recovery of Components	resource constraints uptime constraints	specific support need
What is the planned restart strategy?	Planned restart of Components	time zones dispatch requirements	changes to dispatch requirements new/changed geographies

Browser not supported