About
Building the right SQL Architecture isn’t just as simple as creating a new virtual machine and installing SQL. Creating a robust, performant SQL platform requires in depth analysis of SQL workloads, infrastructure and business objectives.
Workload Isolation
Process Isolation
A key factor in architecting any SQL server environment is where and when the biggest workloads are going to happen, be they from a storage or compute perspective. For example, databases which are 90% write 10% read shouldn’t coexist on the same instance with databases 10% write and 90% read. The former usually being logging or data warehouse databases while the latter being application configuration and state databases. Mixing the two under peak load can result in resource contention of the worst kind.
SQL licences aren’t cheap. Having applications running on your server along with SQL is reducing your return on investment, taking CPU and memory away from SQL Server. Giving SQL every available CPU cycle is another key step to maximizing your ROI which means keeping other applications off SQL servers, including graphical user interfaces.
Environment Isolation
Microsoft provide SQL Developer Edition for non-production databases, i.e. Test, UAT and Development environments. Moving these categories of databases off your production SQL instances is usually a quick win towards getting more from your SQL estate.
What to know more?
Get in touch to discuss how we can help architect the right SQL environment solution for you.