How well do your MS SQL databases perform on a dedicated server?

[danwednesday]

Hi,

I'm looking into getting a dedicated server, but would like some feedback on how well MS SQL Server works in practice on a standard Windows dedicated server, having not been able to properly run some MS SQL Server driven sites on my VPS Hosting due to lack of processing power.

Any experiences welcomed.

Thanks y'all...

[eUK-Martin]

Hello,

Which MSSQL version do you wish to run on the server. If it is SQL Server 2000 then it will need allot of RAM on the server as it is resource intensive.

It also depends on your database size and number of queries it runs on a single request, regardless of version. We have seen just one badly configured database and script over loading our E5420 servers with 8GB RAM.

So it depends on how busy your web site hosting is and how frequently it updates the database.

[danwednesday]

It would be 2005 Express. There might be a few hundred visitors per day - the content of each page being pulled from the database - nothing beyond SELECT and JOINS across possibly 3-4 tables.

[eUK-Martin]

Originally Posted by danwednesday

It would be 2005 Express. There might be a few hundred visitors per day - the content of each page being pulled from the database - nothing beyond SELECT and JOINS across possibly 3-4 tables.

In that case the hardware specification you are looking for should work fine with 2GB RAM. If your web site hosting is about to grow in future then a better specification is recommended. It will only save you from the hassle of migration.