Infosphere's SQL Server Database Administration Framework
This part of our web site contains Infosphere's framework for SQL Server database
audits.
To manage a SQL Server database environment, an operations team needs to perform
a wide variety of procedures, including server monitoring, backup, verification
of scheduled events and capacity planning. Infosphere's audit framework includes
areas of the SQL Server database environment which need to be assessed to ensure
the smooth running of database servers in a day-to-day environment.
Some aspects of the environment are very time consuming from an audit point of view.
The following topics are crucial determinants of performance that take time to analyse:
- Review of the application design and development
- Review of the techniques employed within the application for accessing the database
server
- Capacity planning requirements
Sometimes a cursory glance at these issues is all that time permits. If we form
an impression that more time needs to be applied to them, we negotiate this with
the client.
The following headings are used in this framework:
SQL Server Database Security
Reviews the development, implementation and management of security controls.
SQL Server Database Performance
Observes the health of a SQL Server database service and identifies any obvious
performance problems with SQL Server database.
To make the SQL Server Database Performance Audit easy to follow, we have divided
it into the following sections:
- Performance Monitor
- Hardware Characteristics
- SQL Server Database Settings
- Database Settings
- Indexing
- Application Quality
|
|
SQL Server Database Disaster Recovery
Deals with on-site and off-site data storage for the purposes of data restoration
and historical archiving, and ensures the physical security of backups and archives.
System Alerts
Assesses batch processing tasks in terms of resource use and business impacts. Checks
alert mechanisms used for encountering failures.
Please click here to download the
audit program. Warning: this is of limited interest unless you are a geek.
|