"If your Company is experiencing system problems then they should be addressed before they fundamentally affect the business. Alternatively, if your systems are performing satisfactorily, but the business has grown, is growing or changing - then taking preventative measures before issues occur is a much more cost efficient way to run any business. The usual problem is "where do I go?” and “whom should I call?”. The answer is not necessarily your Systems or Solutions supplier, but independent consultants that specialise in MS SQL Server"

Xynomix Marketing Literature
Oracle Gold Partner
Home » Oracle And Microsoft Sql Support » Sql Server Support » SQL Server Services

SQL Server Services

[back to main SQL Server Support page]

Xynomix are able to offer the following range of Database Services, either individually or as a combined solution.

Xynomix Database Services
  • Database Health Check & Investigation
  • Configuration of database initialisation parameters
  • Configuration and location of database files and objects
  • Memory utilisation 
  • User configuration
  • Block size
  • Backup and Recovery Policy
  • Capacity Planning
  • Table Partitions
  • Failover Procedures
 Performance Tuning
  • Slow response / notable poor performance
  • Standard/default installations
  • Applications installed on a standard configuration
  • I/O bottlenecks
  • Object and free space fragmentation
  • Investigate Inefficient SQL
  • Identify tables without indexes or primary keys
  • Rollback Segment Contention
 Database Design & Creation
  • Skills transfer
  • Highlight key features and drawbacks
  • Cut down on initial tuning issues
  • Where to locate files etc to avoid performance bottlenecks
  • Highlight storage and file sizes to avoid performance issues
  • Capacity Planning
Backup & Recovery
  • Analyse Backup and Recovery Policy / Strategy
  • Validate backups
  • Highlight options available
  • Import and Export – (why it is important to do this periodically)
  • Disaster recovery
  • Hot backups – (Live backups or Archive log mode) strengths, weaknesses, when to use and when not to
  • Cold Backups – Key strengths, weaknesses, when to use and when not to
Installation and Platform Migrations
  • Installations on all Versions from 6.5 onwards
  • Expert Installs – working hand in hand with your Solutions supplier
  • Migrations
  • Upgrades
Senior DBA Services / Outsourced Managed Services
  • DB Assist Silver, Gold and Platinum DBA support packages
  • Daily, Weekly and Monthly scheduled activities
  •     Verify all instances are running
  •     Check alert log file for errors
  •     Verify success of database backup
  •     Check for available resource for acceptable performance
  •     Check for objects that break rules / thresholds
  •     Check security policy violations
  •     Check for excessive growth rates
  •     Review tuning opportunities
  •     Check for I/O contention
  •     Check for server performance issues
  • Use our Senior DBA to ensure key monthly actions are covered
  • Use our Senior DBA to handhold known or recurring problems
DBA Contracting / Outsourcing
  • Long Term cover
  • Maternity cover
  • Illness / unexpected leave of absence cover
  • Data conversions
  • Migration
  • Testing
  • Overcoming Recruitment issues
Service Packs (5, 10, 15 and 20+ days)

Purchase block days and decide how you want to use them. They can be used for any of the above Services either as 1 days consultancy, 2 dial-ins or 3 telephone incidents.

More Information?

Or…