Database Management



DSP has a high  focus on ensuring that our clients Database architectures are performing optimally
We employ a number of experienced SQL Server DBA specialists and they have been working with numerous clients across many market sectors. We deliver SQL Server consultancy on both an ad hoc and project basis. One of our core strengths is our ability to provide ongoing support of databases and applications, both remotely and onsite, to virtually any service level.

The skills provided in this list are not exhaustive and DSP welcomes the opportunity to discuss ideas or issues relating to your SQL Server estate.

This DSP SQL Server support service includes the ability to:
  • Manage SQL Server Databases remotely
  • Centrally view customer problem data and health from Groundwork
  • Report on problems and time spent working on customer issues
  • Perform remote diagnostics, troubleshooting and support
  • Provide advice on best practice for customers
  • Deploy software updates and patches to the hosts databases
The original DBA service with a 24*7 option gives access to DBAs remotely and on site. Includes automated monitoring and alerting via a secure portal, email and SMS and trend analysis is also provided. Our burstable model works equally well for sites with DBAs as for those where there are none. It is also ideal for holiday, variable workloads and sickness cover.

Although some clients have DBA's onsite, having access to third party skills with multi-project experience is often crucial to solve testing issues of availability, performance, speed & resilience. DSP provides these resources to clients of all sizes, some of whom use us when specific issues arise and others in a more pro-active fashion. We have listed our core database services here:

• Database Support
 Access to skilled and certified Microsoft SQL*Server DBA’s, 24x7. DSP also provide ‘on site’ based resource for any duration; ideal for sickness andor holiday cover.

• Database Design
 With skilled SQL*Server database developers, DSP makes for an excellent choice for database development, design and management. DSP specialise in databases and the supporting storage; it’s what we do best. DSP can build you a working application, backed by robust SQL*Server technology to meet the demands of your business. Add onto this Reporting Services, Analysis Services and Integration Services skills, DSP provide the full package.

• Database Capacity Planning
DSP can undertake volume and database usage using DSP GroundWork™ to predict growth and usage. This is essential for system upgrades, migrations and consolidation projects.

• Database Consolidation
 With costs being the focal point of any IT budget, more and more businesses are looking to reduce their overheads and one way to do this is to consolidate your SQL*Server databases onto fewer SQL*Servers. DSP specialise in database consolidation and migration.

• Database Maintenance
 DSP provide proven, reliable housekeeping methods and scripts to address daily fragmentation as well as provide ‘health check’ services surrounding the installation of the SQL*Server software, which includes service packs, hot fixes and Microsoft Premier Support escalation.

• Database Migration
 DSP provide skilled technical resource to perform database migrations between instances, servers or even other database applications.

 • Disaster Recovery
DSP specialise in providing Disaster Recovery and Business Recovery solutions to fit any or all areas of your IT infrastructure. From software based tools to enterprise-resilient designs including Active-Active SQL stretched clusters with seemless automatic client redirection, DSP know how to keep your budget safe and your conscience at ease.

As you may be aware of, the use of Microsoft technologies requires considerable planning and maintenance to avoid a poor implementation. DSP services can assist throughout the entire project lifecycle or be used to deliver distinct phases. SQL server can be used as a high availability platform for databases using the following technologies.
  • Replication
  • Clustering
  • Log shipping
  • Database Mirroring (SQL server 2005)
  • 3rd party clustering and replication tools
There are a multitude of benefits for any organisation using these services, however individual needs must be identified to ensure that the implemented service meets with the needs of the host organisation. required. For further information please contact DSP and ask for the Microsoft Practice.


DSP is a registered Microsoft partner for both Software, Technology and Applications