Management of database falls into main two categories
- Standard maintenance tasks:
- Regular Backups – depending on recoverability level we employ Full, Differential or Log database backups to provide up to the minute recovery, where needed. These backups should be written to a network share during the day in case the SQL Server fails.
- Database index optimisation, including statistics updates, index defragmentation and Database Consistency check to identify structural issues.
- Pro-active monitoring:
- Automated scanning of SQL Server errorlogs, metric gathering and recording, alerts triggered when thresholds exceed, replication latency recorded and alerted on,
We use a suite of enterprise level scripts to carry out these tasks and alert via email should issues be discovered or a job fail.
There is often a need to write and maintain custom scripts to automate new DBA functions and specific tasks for the client. We can assist where these scripts deliver DBA functions, such as automating database copy and loads. For SQL Server, we accomplish this using bespoke PowerShell scripts and freely available tools from www.dbatools.io. dbatools is a free PowerShell module with over 500 SQL Server administration, best practice and migration commands included. For Sybase or MySQL we have a suite of in-house written Shell scripts.
We will ensure that the SQL Servers are configured in line with Microsoft’s best practice guidelines. We review server installations and check configurations (memory network settings, etc) and disk layout (separation of devices, tempdb setup, block allocation size, etc).
Where there is a requirement to maintain a very recent copy of the database at a Disaster Recovery location, various tools can be used to replicate the database to eth DR site, including: Always On Availability Groups, Database Mirroring, Log Shipping or even simple database backup file recovery. The choice will depend on bandwidth, SQL Server edition, database activity and of course cost. The correct solution would be agreed with the client before any implementation plan was drawn up.
Kronva team members currently hold Microsoft Certified Professional certification in “Administrating Microsoft SQL Server 2012/2014 Databases (70-462)”