I need a dedicated SQL Server box to host clients databases. However i wanted to know from peoples experience roughly how many databases it is safe to put on one installation of SQL 2000 server.
I know its a "how long is a peice of string" question but i mean in general terms.
Say i provide 100MB databases. Could i provide more than 100 of these on one installation?
This would be on an average dedicated box, say p3 1.2, 512MB.
Remember though, just because they could have a 100 databases on a box, doesn't mean they should
By the way, how were they offering you connectivity? Was it via a control panel, port 1433 access, gave you a connection string?
We house some enterprise databases and I've always been curious on hosting companies monitor and bill sql server usage on shared plans. I mean, if was doing crazy inner joins to left joins, to where in () etc statements on non-indexed tables on high traffic sites with no caching, can't I pretty much screw others?
Maybe you could try it out with a few customer, in return for free hosting for them for 1 or 2 months. This way you know what to price and they will appreciate the efforts you take to offer the best service. And for SQL 2000 a better processor and more Ram will also help, and you can always plug in extra memory when loads get to high!
Most [smart] SQL hosts have query governing turned on to limit SELECT (SELECT (SELECT (SELECT (SELECT, well you get the point... I contract for a bank and they have big fat Compaq servers with hundreds of SQL databases on them; concurrent users? 50. Critical systems? Dedicated SQL boxes.
It really depends on the usage and you have to assume that most people using MS SQL Server are either VB programmers or using an off the shelf package, so it's 50/50 on "good database design" which can also affect server performance.
My 13 cents: Watch your performance monitor logs, if you see crazy stuff, nip it in the bud with the dbo. Use query governing - if it takes longer than 30 seconds to run, they don't need it!
argonblue.com | sales | 800.710.8004 LA Grand Avenue, Rancho Cordova, cages, racks and power plus HE Fremont cabinets available!
Ya, one of my sites is using a shared SQL server with what looks to be around 300 databases. However, the shared SQL server they are running is a quad Xeon with something like 6 gigs of RAM, 10,000 RPM hard drives etc. The SQL server is a tad slow, but nothing that I'm complaining about for $50 a year to be on it!
A better question you should be asking is how many DB requests per second can that sort of server handle. Again, its up to the complexity of the queries and if there are stored procedures and so forth. Unfortunately I am not experienced enough with SQL servers to even give a ballpark figure to that question. But it is a much better question because in theory you can host 1000 databases on a Celron 800, with 1 gig of ram, as long as there aren't many DB requests...