Whether looking to supplement your existing DBAs, have less than full-time needs, or simply want to outsource and save money, Emergent Software has you covered. Our team of talented, senior-level SQL Server Database Administrators is available on an as-needed basis or you can sign up for ongoing SQL Server Managed Services for proactive monitoring & support of existing databases.
Health Check & Security Audit
Because SQL Server is so easy to install, most SQL Server environments are not configured with best practices. If you use VMware, did you know that a simple change on your VM configuration will improve disk performance of your databases up to 15%? This and many other configuration changes could help you get so much more out of your database infrastructure without expensive hardware upgrades. While we’re in your systems, we’ll do a security audit so you have a clear picture of who can access what data.
Database Backup & Disaster Recovery
Confidence that your data is backed up and you can fully recover from an IT disaster, like the 2019 fire that started in Wells Fargo’s data center in Shoreview, Minnesota, is the linchpin of your business continuity strategy. Many IT departments erroneously rely on VM snapshots for everything not understanding how this affects their RPO & RTO. Emergent’s SQL Server DBAs give IT managers confidence and help them decide the right database backup strategy.
High Availability Cluster Setup
Your most important systems that require 24/7 operation with little to no downtime need high-availability SQL Server clustering. Emergent’s SQL Server experts help IT leaders choose the right SQL Server cluster technology given your high availability (HA) and disaster recovery (DR) needs and budget. We perform best practice configurations of Availability Group (AG) clusters and traditional standard failover (FCE) clusters. Another option we support is using SIOS DataKeeper for a low-cost, best-of-both-worlds setup including all the benefits of the FCE clusters (SQL Server Standard licensing, easy to administer) and eliminates its major drawback (shared storage). Our experience with both SQL Server and virtualization helps us maximize I/O, CPU and memory performance for your servers.
Database performance tuning is one of the most overlooked aspects in the software world. software is often developed without any consideration to how it will perform after 2 years of data has been created. Also, IT admins often don’t understand that tuning to your specific usage is required even for out-of-the box software packages. Needed index optimization is the most common finding from our database health checks and provide the lowest hanging fruit for turning a poor performing database into a race horse.
SQL Server Best Practices Configuration
So much that is found in our database health checks can be avoided if SQL Server is configured correctly out of the gate. Don’t rely on your system administrators or your BI developers to install and configure SQL Server, because it won’t be done correctly. Contact Emergent before your virtual machines are built and we’ll make sure your database environment is configured with best practices to maximize your infrastructure investments.
DBA Managed Services
Perhaps you’ve read through the summaries of all our DBA services listed on this page and you’re wondering if you can rely on your system administrators to manage your databases on top of their day job. Short answer: you shouldn’t. You may also be wondering how on earth you might hire someone who can do all of this. Short answer: you can’t. However, all of this and more can be yours with access to our team of senior SQL Server experts through DBA managed services.