NXTEO
SQL SERVER SERVICES
SERENITY Pack or ASSURITY Pack
Our basic offer for all packs
Managing physical spaces
Managing the size and occupancy rate of base files
Managing the distribution of base files
Management of specific base settings
Object management
Reconstruction / Reorganisation of tables and indexes
Creating, modifying and deleting objects in a database
Checking object status*
Availability management
Verification that all instances/bases are UP on the perimeter*
Check that the services associated with an instance are UP*
Corruption management*
Management of locks and blocking sessions*
Error management
Checking jobs*
Error handling in the errorlog*
Modification of a database parameter
Safety management
User and password management
Verification of instance/base backups*
Shrink logs associated with a backup
Backup / restore of a basic backup of less than 200GB
Feeding a database from Production (SSIS, export/import)
Performance management
Statistics management
Analysis of consumer queries
Identification of CPU, memory, network and disk I/O restrictions
Our additional options
SERENITY packs only
UNLIMITED option
Safety management
Management and implementation of a backup plan + archive mode
Backup / restore of a backup greater than 200GB
Application of Service Packs in accordance with the Microsoft schedule
Performance management
Detailed analysis of CPU, memory, network and disk I/O constraints
New monitoring tool under study and development
DR* operations management
* DR : Disaster Recovery
Failover Cluster Instance, DB Mirroring, Log Shipping or equivalent
Checking the status of the Disaster Recovery solution*
Failover of a database or instance (depending on the DR solution) in the event of a major incident
Management of CDC* operations
* CDC : Change Data Capture
Checking latency to the target base*
Verification of CDC activation on base model loading*
Additional operations
Migration of a database on the same server
Duplicating/moving a database to another server
ON-CALL DUTY option
ON-CALL DUTY management
Full scope of NWH incidents taken into account
NWH : Non-Working Hours, 24/7/365, including public holidays
SUPERVISION option
Supervision management
Remote supervision of the perimeter, reduced GRT*
*GRT : Guaranteed Response Time
* : Action Corrective Éventuelle
