TL;DR
Before you approve the next CPU upgrade or Enterprise license, ask what else is running on the box. Co-located apps (IIS, backup agents, even Exchange) eat the CPU, memory, and I/O SQL Server needs, and more hardware won't fix that.
- Teams routinely overspend on SQL Server resources by 2-3x when the real problem is a shared box, never a hardware shortage.
- SQL Server is licensed per core, so every core a non-database app burns is licensing you paid for and got nothing back. On a shared box that waste often dwarfs the price of a second server.
- Cloud doesn't fix this for free. Azure VM or EC2 removes your co-located apps but adds noisy-neighbor contention, so reserve resources at the hypervisor or instance level.
The Problem
CTOs and CIOs regularly overspend on SQL Server resources by 2–3x. More CPU, more RAM, bigger storage, Enterprise Edition licenses when Standard would do. The assumption is that SQL Server needs more power.
More often, SQL Server isn't getting the power it already has.
When SQL Server shares a machine with IIS, application services, backup agents, monitoring tools, or — in the worst cases we've seen — Exchange Server, those processes consume resources SQL Server needs. The result:
- Unpredictable performance. Query response times that swing based on what else is running.
- Resource contention. CPU spikes that don't correlate with the database workload.
- Memory pressure. SQL Server wants all available RAM for its buffer pool. Other apps force the OS to page, and everything degrades.
- Troubleshooting nightmares. Is it SQL Server? The web server? The backup agent? Good luck at 2 AM.
The Licensing Angle
SQL Server is licensed per core. If cores licensed for SQL Server are regularly consumed by non-database workloads, you're effectively paying SQL Server licensing costs for work that isn’t database-related.
Enterprise Edition licensing can run into tens of thousands of dollars per two-core pack, depending on your agreement. Standard is roughly a quarter of that and handles the majority of workloads we encounter. The licensing waste on a shared box often dwarfs the cost of a second server.
Why This Keeps Happening
Budget consolidation. "Can we put these on one box?" Per-server cost goes down. Total cost of ownership goes up through performance issues, licensing waste, and incident response — but that shows up in different budget lines.
"It's just a small app." Every co-located application starts small. Then it grows, gets a scheduled task, develops a memory leak, and SQL Server performance degrades with no obvious cause.
Lack of technical authority. The people who know this is wrong don't always have the organizational power to stop it. The people who approve the consolidation aren't the ones getting the 2 AM call when it breaks.
Virtualization complacency. "It's a VM, so it's isolated." Not if the hypervisor host is overcommitted. You've just moved the noisy neighbor problem one layer down. Proper resource reservation at the hypervisor level matters.
What Belongs on a SQL Server
Yes: SQL Server Database Engine, SQL Server Agent, full-text search, SSMS for emergency local access.
No: IIS, application services, RDS, backup agents, monitoring agents, development tools, Exchange, any other database engine.
Edge cases:
- SSIS. Included with SQL Server licensing when installed on the same licensed server. Separate install requires its own license. Heavy ETL workloads do compete for resources, but the licensing math often wins.
- SSRS / SSAS. Better on separate servers for non-trivial workloads. Small deployments sometimes co-locate for licensing.
- Hyper-chatty applications. If an application makes thousands of tiny, rapid-fire database calls, shared-memory on the same box can outperform network communication. Rare, but test before dismissing.
Cloud Doesn’t Solve This Automatically
Moving to an Azure VM or EC2 instance eliminates co-located applications but introduces different contention. You're sharing physical hardware with other tenants. Storage can be throttled. CPU can vary. This is the cloud "noisy neighbor" problem — harder to detect, impossible to resolve directly.
The principle is the same regardless of platform: SQL Server performs best with predictable, dedicated access to CPU, memory, and storage.
Memory: The Related Mistake
Once SQL Server is dedicated, sysadmins often panic at high memory usage. SQL Server using 80–90% of RAM on a properly configured dedicated box is normal — it's caching data in memory to avoid disk reads. That's the feature working.
Set max server memory to leave appropriate headroom for the OS and supporting services (commonly 4–8 GB on smaller systems, proportionally more on larger servers). Let SQL Server use the rest. This only works cleanly when SQL Server is alone on the box.
Business Logic and Resource Consumption
Some environments push all business logic — sorting, paging, aggregation, transformation — into stored procedures. SQL Server becomes the compute engine for the entire application, not just the data store. Tempdb fills up, memory pressure climbs, CPU stays pegged.
Whether business logic belongs in the database or the application layer depends on the workload. But the architectural choice directly affects how many resources SQL Server needs — and if it's doing double duty as both data store and application server, it definitely shouldn't be sharing a box with anything else.
How to Fix It
Clean approach: Migrate SQL Server to a new, dedicated server. Best when the current server has accumulated years of unnecessary software and questionable configurations. Start fresh.
Eviction approach: Remove everything that doesn't belong. Less disruptive, but requires confidence that the current server configuration is clean underneath.
Either way: SQL Server gets dedicated resources, monitoring becomes straightforward, and the next performance problem has one less variable.
Bottom Line
Before you approve the next CPU upgrade or Enterprise Edition license, ask a simpler question: what else is running on that box?
The answer might save you more than the upgrade would have.
