![[layout image]](images/round-185-top.gif){kind=small}
![[layout image]](images/round-185-bot.gif){kind=small}
DSP's Healthcheck Practice
Gain most value from your database and application technology implementation
Any database in constant use needs to be reviewed regularly. What was once reasonable sizing of database objects can change over time. Also as a database grows and users come and go and increase in number the database experiences different stresses. Additionally over time some systems get used slightly differently to the original design. This stems from users discovering unused functionality and by finding shortcuts or because the business has changed and emphasis on specific functionality has shifted. As a consequence of these changes the database needs to be tuned, possibly re-sized and tweaked regularly.
Over time a database will grow and even shrink, users will come and go and the sizing needs of database objects may change. Aspects of the system may also end up being used for something different from its original design because users discover new shortcuts or functionality or a change in the company's business direction. Because of all the possible changes to a database over time it must be regularly tuned, re-sized if necessary and tweaked or its performance and data integrity will suffer.
Databases are sometimes created, configured and sized under rushed conditions or by inexperienced DBAs, and the OFA (Oracle Flexible Architecture) - a recognised standard for the placement and the naming of database files - is not always followed. Such databases need professional assessment and attention.
Our Healthcheck takes a full and comprehensive look at your database for existing and potential high-risk problems. The reports produced also highlight achievable performance gains and administrative improvements, along with recommendations covering structure and performance to allow DBAs to easily rectify problems and carry out improvements.
DSP's Healthchecks Server
"unused capacities atrophy, and cease to be" Tillie Olsen
Because your database and server are very closely linked, our comprehensive Server Healthcheck is included as part of the DSP Database Healthcheck.
It is also available as a stand-alone service and will provide verified, documented information on:
"If I carried all the thoughts of the world in my hand, I would take care not to open it" Bernard Fontenelle
With the increasing use of web technology, security breaches are more of a worry than ever. But security threats have always existed, in fact industry figures claim that 70% of them come from internal sources.
Ensuring the security of your important and sensitive data is paramount, so it is surprising that most Oracle sites do not utilise the full potential of the system's security features.
Our Security Healthcheck will review your database security measures and give recommendations that when implemented, will give you peace of mind. In addition the service can evaluate server (UNIX/NT) security, make recommendations and implement them if required.
DSP's Back up and Recovery
"You may as well fall flat on your face as lean over too far backward" - James Thurb
Would you be able to quickly and easily restore a fully working system in the event of a hardware or database failure? If you're not sure, then you need one of our Backup and Recovery Heathchecks
Due to lack of or a transient technical resource, a site might often leave backup and recovery to chance or just assume that it is being dealt with. We have seen the very serious consequences of this hit and miss approach and it is critical to review backup and recovery procedures as well as broader disaster recovery aspects. Doing this now will save you time, effort and expense should a disaster happen.
The Backup and Recovery Healthcheck will:
E-Business Suite / Oracle Applications healthcheck
This is a comprehensive healthcheck to enable customers to maximize their investment in Oracle Applications by aligning technology and business practice. The objective is to make a difference to the individual user, the department and the organisation as a whole.
Oracle Applications is extremely flexible and functionally rich software and requires great care in its implementation. Thereafter, most organisations are dynamic and, periodically, the set up of the system should be reviewed for continued effectiveness.
We would expect to establish this from two angles - the technical and functional deployment.
Technical
Database and server healthcheck including (if applicable) suitability of existing infrastructure to accommodate R11i. Applications technical architecture deployment (code sets, bespoke TOPs etc.) which affect patching and future upgrades. Patch level, and patching strategy. SYSADMIN functionality effectiveness Security of database and Applications.
Functional
It still meets business and user requirements; is any functionality not being fully utilised. Has adequate interfaces to legacy and adjacent systems. Has adequate reporting. Was implemented with acceptable quality standards, such that future upgrades and enhancements will be achieved with minimum effort.
DSP Delivery on Health check:
For further information regarding our services including Remote DBA, Managed Services, Hosting, Implementation, Upgrades and Migrations please contact DSP to discuss your needs
DSP Supports Oracle & Microsoft using GroundWork
Any database in constant use needs to be reviewed regularly. What was once reasonable sizing of database objects can change over time. Also as a database grows and users come and go and increase in number the database experiences different stresses. Additionally over time some systems get used slightly differently to the original design. This stems from users discovering unused functionality and by finding shortcuts or because the business has changed and emphasis on specific functionality has shifted. As a consequence of these changes the database needs to be tuned, possibly re-sized and tweaked regularly.
- DATABASE Healthcheck
- SERVER Healthcheck
- SECURITY Healthcheck
- BACKUP and RECOVERY Healthcheck
- E-BUSINESS SUITE/ORACLE
- APPLICATIONS Healthcheck
Over time a database will grow and even shrink, users will come and go and the sizing needs of database objects may change. Aspects of the system may also end up being used for something different from its original design because users discover new shortcuts or functionality or a change in the company's business direction. Because of all the possible changes to a database over time it must be regularly tuned, re-sized if necessary and tweaked or its performance and data integrity will suffer.
Databases are sometimes created, configured and sized under rushed conditions or by inexperienced DBAs, and the OFA (Oracle Flexible Architecture) - a recognised standard for the placement and the naming of database files - is not always followed. Such databases need professional assessment and attention.
Our Healthcheck takes a full and comprehensive look at your database for existing and potential high-risk problems. The reports produced also highlight achievable performance gains and administrative improvements, along with recommendations covering structure and performance to allow DBAs to easily rectify problems and carry out improvements.
DSP's Healthchecks Server
"unused capacities atrophy, and cease to be" Tillie Olsen
Because your database and server are very closely linked, our comprehensive Server Healthcheck is included as part of the DSP Database Healthcheck.
It is also available as a stand-alone service and will provide verified, documented information on:
- Operating system version and patch level
- Kernel configuration
- Available memory, configuration and usage
- CPU architecture and usage
- Disk configuration, available space and I/O usage
- Overall performance
- OFA (Optimal Flexible Architecture) for any installed Oracle databases and carry out improvements
"If I carried all the thoughts of the world in my hand, I would take care not to open it" Bernard Fontenelle
With the increasing use of web technology, security breaches are more of a worry than ever. But security threats have always existed, in fact industry figures claim that 70% of them come from internal sources.
Ensuring the security of your important and sensitive data is paramount, so it is surprising that most Oracle sites do not utilise the full potential of the system's security features.
Our Security Healthcheck will review your database security measures and give recommendations that when implemented, will give you peace of mind. In addition the service can evaluate server (UNIX/NT) security, make recommendations and implement them if required.
DSP's Back up and Recovery
"You may as well fall flat on your face as lean over too far backward" - James Thurb
Would you be able to quickly and easily restore a fully working system in the event of a hardware or database failure? If you're not sure, then you need one of our Backup and Recovery Heathchecks
Due to lack of or a transient technical resource, a site might often leave backup and recovery to chance or just assume that it is being dealt with. We have seen the very serious consequences of this hit and miss approach and it is critical to review backup and recovery procedures as well as broader disaster recovery aspects. Doing this now will save you time, effort and expense should a disaster happen.
The Backup and Recovery Healthcheck will:
- Qualify your contingency needs and expectations
- Assess each server and application to give it our own disaster recovery rating. This rates each system on its importance to you in terms of downtime, data input loss and recovery time and enables us to match it to a 'best practice backup and recovery' strategy
- Evaluate database and server script and procedures
- Recommend changes and new procedures and implement if required - Execute test recovery with accurate timings and verification of data recovery
E-Business Suite / Oracle Applications healthcheck
This is a comprehensive healthcheck to enable customers to maximize their investment in Oracle Applications by aligning technology and business practice. The objective is to make a difference to the individual user, the department and the organisation as a whole.
Oracle Applications is extremely flexible and functionally rich software and requires great care in its implementation. Thereafter, most organisations are dynamic and, periodically, the set up of the system should be reviewed for continued effectiveness.
We would expect to establish this from two angles - the technical and functional deployment.
Technical
Database and server healthcheck including (if applicable) suitability of existing infrastructure to accommodate R11i. Applications technical architecture deployment (code sets, bespoke TOPs etc.) which affect patching and future upgrades. Patch level, and patching strategy. SYSADMIN functionality effectiveness Security of database and Applications.
Functional
It still meets business and user requirements; is any functionality not being fully utilised. Has adequate interfaces to legacy and adjacent systems. Has adequate reporting. Was implemented with acceptable quality standards, such that future upgrades and enhancements will be achieved with minimum effort.
DSP Delivery on Health check:
- Executive summary
- Database/server healthcheck
- Applications technical architecture deployment review
- Applications implementation quality assessments
- Review of Applications set up
- Review of Applications usage
- Business process correlation with above items
- Review of user issues and training needs
For further information regarding our services including Remote DBA, Managed Services, Hosting, Implementation, Upgrades and Migrations please contact DSP to discuss your needs
DSP Supports Oracle & Microsoft using GroundWork
![[layout image]](images/round-870-top.gif){kind=small}
![[layout image]](images/round-870-bot.gif){kind=small}