K Solutions also recognizes that some customers would before
to choose the features and level of support they require.
The following DBA services can be provided individually
or in any combinations, on an ad hoc or as needed basis.
This service is cost based on the total number of man days
required to perform the task.
Any business critical systems will not tolerate the slightest
glitches. With K Solutions' remote support capabilities,
all database and application related issues can be resolved
expeditiously. In addition, value added services such as
providing advice on the application's machine resource consumption
(based on the performance of testing or production environments
and market experiences), monitoring and reviewing space
usage and allocation for the system's optimal performance
can also be expected, whether the support service is provided
on site or remotely.
A database should be monitored
and adjusted on a regular basis to ensure that the system
is well tuned and that a high level of performance is maintained.
The entry of new data into the systems and new business
needs giving rise to new reporting needs make the task of
tuning the database for optimal configuration a necessity.
K Solutions reviews the customer’s entire database
and platform and make changes (such as changing tuning parameters,
rebuilding an index or restructuring a table) that maximize
database performance. This task can be performed at regular
intervals or at an on going basis. Any exceptional behavior
of the database and any performance degradation due to physical
data files placement can be diagnosed and corrected.
The ability of any database and its contents being able
to recover from any unplanned incident in a way that minimizes
the impact of these unplanned outages on a customers core
business is utmost important to any mission-critical businesses.
K Solutions' backup and recovery methodology can assist
the customer in defining backup and recovery plans and procedures
for its systems and at a higher level, a strategic plan
that meets the customer’s business needs. The methodology
is applicable for both online backups and regular batched
backups and the procedures are continuously reviewed to
ensure they remain appropriate for the customer's systems.
Areas addressed in the methodology include:
1. frequency
of backup
2. what is to be backed
up
3. staff procedural training
4. backup retention periods
5. backup verification
6. frequency of recovery
tests
7. backup timeliness and
improvements
8. roll forward recovery
options
When a database recovery is necessary, K Solutions will
either analyze the database using remote diagnostic tools
or provide a DBA at the customer's site, whichever is more
appropriate and effective to 'bring up' the database so
as to minimize delays that can detrimentally impact the
business.
With this service in place, an improved level of data security
is expected and the risk of corrupted data being rolled
back to a production system is drastically released.
A system's performance is impacted by key factors as the
memory, disk space and usage patterns. K Solutions can assist
to address the issues related to improving the system's
performance and study the client organization’s future
needs with the client to rightly configure its systems for
optimal performance.
