Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011

    MS SQL Server issues inherent to VPS??

    So I'm researching different VPS hosts and am looking for suggestions...

    When I was on the (triple8) site I noticed this in their FAQ section:

    Are there any software programs that do not run well on VPS servers?
    Yes, some programs do not run well (or sometimes not at all) on VPS servers. These are usually programs that use a lot of ram (MS SQL Server) or very busy database servers. Also, any program that needs to control or manipulate the NIC card (such as proxy servers or VPN software) most likely will not work. If you have an application that uses alot of CPU, RAM, or HD read/writes, in most cases these will not perform well in a VPS environment. A dedicated server may be a better option.

    We were running MS SQL Server on our current VPS (Windows 2003) and didn't seem to be having any issues...

    Can anyone say what the basis of their assertion that MS SQL Server doesn't do well on a VPS box?

    And if that truly is accurate... what's the next best solution, a Dedicated Server instead?

    Any/All advice/input would be GREATLY appreciated!

    Thanks so much,
    Craig J

  2. #2
    Join Date
    Nov 2007
    West Palm Beach, FL
    Hi Craig,

    While I do (overall) agree with that assessment, fundamentally the answer is still that it "depends". MS-SQL on a VPS can be a great fit for a lot of applications, but it's not a one size fits all answer. Any type of SQL server (not just MS-SQL), loves two things: memory and disk throughput. All too often, especially with the 'budget' VPS category those are the two most constrained or inadequate resources.

    If done correctly (e.g. given the proper resources), SQL runs very well virtualized. Depending on the workload that might mean fiber channel storage arrays vs. local SATA storage, etc. For heavy workloads it'll definitely be in your best interest to go dedicated with RAID-10 SAS storage or SSD. It would simply be more economical than finding a VPS provider with the capability of providing an adequate environment.

    The best advice I can give you is know your application and have a baseline of performance, metrics and expectations before issues arise. If you're happy with your performance now, correlate this to what the workload is and what type of environment you're currently in. Regularly collect and monitor performance data. Knowing these metrics will greatly aid in determining when upgrades are needed and then ultimately in comparing different environments when you do change VPS platforms or jump to dedicated.


    Applied Innovations (
    Microsoft Gold Certified Hosting Partner, Featured Host.
    Specializing in Windows Hosting since 1999.

  3. #3
    We run some heavy load SQL servers on VPS and have no problem at all (Hyper-V platform).
    You may experience performance issue when hosting SQL Server on overselling node with bad disk IO. Hyper-V SSD VPS USA London Singapore
    Reseller Hosting Cpanel PURE SSD CloudLinux Softaculous
    Windows Reseller Asp.NET 4.5 MSSQL 2012 SmarterMail Enterprise

Similar Threads

  1. Question about SQL issues
    By jimnyc in forum Hosting Security and Technology
    Replies: 4
    Last Post: 06-09-2009, 10:30 AM
  2. Cron Issues on VPS Server
    By john99041 in forum Hosting Security and Technology
    Replies: 2
    Last Post: 01-25-2008, 12:19 PM
  3. Help...server issues, domains not resolving, sql shutting down
    By miketymikey in forum Hosting Security and Technology
    Replies: 6
    Last Post: 01-09-2008, 02:51 PM
  4. MySQL Running Alongside SQL Server - Any Issues?
    By aspsql9 in forum Dedicated Server
    Replies: 6
    Last Post: 04-02-2006, 02:24 AM
  5. Inherent conflict?
    By NyteOwl in forum Running a Web Hosting Business
    Replies: 10
    Last Post: 05-08-2005, 08:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts