Running Microsoft SQL Server on a VPS

SQL Server is Microsoft’s relational database management system or RDBMS. It’s the data engine underneath most of Microsoft’s business software, such as ERP systems, accounting packages, and anything that’s built on .NET or ASP.NET.

As it’s Microsoft’s very own, SQL Server is better on a Windows Server. Technically, SQL Server has supported Linux since its 2017 release but the Windows experience is the standard. It’s the best-supported path.

Generally, shared hosting isn’t sufficient for running SQL Server. A VPS hosting gives it what it needs, which is dedicated RAM and CPU, as well as admin/RDP access. The fast, dedicated, and completely isolated storage of a VPS server is also critical to run the server workloads because databases are all about fetching and storing data in/out of databases. A faster storage that’s dedicated to your SQL Server only is remarkably better in terms of performance than whatever you can put together on any type of shared hosting setup.

VPSBlocks’ Microsoft SQL Servers are VPS hosting packages that essentially offer you a dedicated database server without the need to own expensive hardware. And to truly appreciate just how useful our VPS is for a Windows database setup, we need to take a look at the resource hunger databases have.

Why is SQL Server Resource-Hungry?

Anyone interested in setting up a Microsoft SQL Server should know these mechanics. The three key resources that are important to any type of web server are RAM, storage, and CPU. Database workloads need significantly more of everything, not just in terms of quantity but quality as well, to do their job well.

  • RAM: SQL Server caches data pages in memory in what’s called the buffer pool. This buffer pool is an amazing piece of the puzzle. The job of a database setup is to store and fetch data. As such, the number of trips needed to be made to the disk is directly proportional to performance and speed. The more of your active data that fits in RAM/buffer pool, the fewer trips to disk will be needed. Practically, the closer usable RAM gets to your working data size, the faster the database feels.
  • Disk I/O: In many setups, disk I/O is often a bottleneck. Databases need to do a lot of small, random reads and writes. On top of that, there are three things that punish slow storage hard: the transaction log (written to constantly, sequentially), tempdb (a scratch database used heavily for sorts/joins/temp tables), and the data files themselves. This is why NVMe matters far more for a database than for a website.
  • CPU: The processor handles the actual query processing and concurrency. Without the CPU as the brain to mediate all this, no amount of RAM and no speed of disk will ever work. Generally, lighter lookups are cheap, and fewer cores will do the job. But if your task has concurrent users and heavy reporting (such as month-end reports, analytics, etc.), additional cores make your life much easier.

Many budget hosts overcommit RAM/CPU across customers. A database is the worst possible workload for that, because a busy “noisy neighbor” directly slows your queries. VPSBlocks dedicated (not oversold) resources come with the promise of speed and performance.

SQL Server Editions

Picking wrong can be expensive. Here’s a quick primer:

  • Express: Free. Hard caps: 10GB maximum database size, uses only the lesser of 1 socket or 4 CPU cores, and roughly 1.4GB of RAM for its buffer pool. Fine for small internal tools, dev, or light apps. You hit the ceilings faster than expected on real production data.
  • Web: Low-cost, available through hosting providers (SPLA) for public-facing web applications only. Cheaper than Standard where the workload qualifies.
  • Standard: The workhorse most businesses land on. Supports up to 128GB of RAM for the buffer pool per instance and up to the lesser of 4 sockets or 24 cores. Covers the feature set the vast majority of business apps ever use.
  • Enterprise: Top tier. Uses up to the OS maximum RAM and cores, plus advanced high-availability and performance features. Priced accordingly. Most SMBs genuinely don’t need it.
  • Developer: Free. Includes the full Enterprise feature set, but licensed for development/testing only, never production. This is ideal if you’re just spinning up a test box.

Sizing a SQL Server VPS

Windows Server itself carries overhead, so the floor is higher than Linux. You need at least 2 to 4GB RAM and 2 CPU cores just for the OS to run comfortably! Add to that the SQL Server doing its heavy lifting and the sensible starting point is often around 4-8GB RAM with multiple CPU cores. This will scale with database size and concurrent users, of course. Multi-user and/or heavier workloads should preferably be positioned higher from the outset rather than starting too lean.

Also, it’s recommended to keep data files, the transaction log, and tempdb on fast storage. Here on VPSBlocks, that’s all NVMe or Flash by default, so you’re good to go. You can use a cheaper SATA backup disk for your backup needs or bulk data. SATA isn’t automatically included in managed backups, so data kept there needs its own backup plan.

Interested in learning more about a proper Windows VPS server for your business? Here’s why VPSBlocks offers excellent performance for Australian business owners:

  • Storage is NVMe/Flash in RAID 10, which is over 100x faster than SAS/SATA drives and at least 20x faster than SSD. For a constantly-reading-and-writing database, that’s felt directly in query times.
  • RAID 10 means a failed disk rebuilds onto a replacement with no service interruption.
  • And the best part? Our network. Australian infrastructure with multi-carrier feeds (Telstra, Optus, TPG/iiNet and others), BGP routing to the shortest path, and upstream DDoS scrubbing (SmartWall). For an Australian user base this means low latency, the database is close, not adding overseas round-trip delay to every connection.

Ready to consider options? Get in touch today!

quote
Neil

PROMO CODES

Toggle VPS Promo Code

Enter the promo codes below on the checkout page.

80% OFF FIRST MONTHLY*
80% off your first monthly payment.
Code: 80OFF

30% OFF FIRST ANNUAL*
30% off your first annual or semi-annual payment. You can save hundreds.
Code: VPSHOST30

* These offers may be used once per customer for new VPS orders only.