August 25, 2002 at 9:20 pm
We have a bunch of departmental servers and are trying to determine if we need SQL Standard vs. MSDE.
They have small databases, and modest but continual use. They are data collection servers for warehouse operations. They have maybe 4-15 clients connected to them entering data frequently, but with tiny transactions. The number of concurrent connections is high (each client may make 3-4 connects due to the software architecture) but the number of concurrent queries in progress is very low, I'd say typically 1 or 2. Databases are small, generally < 1G. No significant interactive (e.g. SQL) users.
We beleive this a good candidate for MSDE. But how do we tell? We installed a very small one and it works fine (as witness both performance and DBCC CONCURRENCYVIOLATION checks).
But some larger ones we have running Standard, and Microsoft (of course) gives you no way to evaluate the impact of DOWNGRADING to MSDE. DBCC CONCURRENCYVIOLATION doesn't work if you are already running Standard, so we can't take a representative site and tell.
And as best I can tell I need to do a remove and reinstall to put MSDE on at all. And even then I'm not 100% sure I'll get a real legitimate MSDE (microsoft un-installs being rather well known for being incomplete).
Anyone know if there is a single component that controls the governor (and hopefully the DBCC command) that I could replace with the MSDE version for a while, see how it goes?
Or anyone have a better suggestion how to tell, on Standard, what the equivilent concurrent query maximums are? Whatever the query governor is going to measure?
Or have other advice?
PS. Yes, this is purely a cost issue. These are small sites, we keep a primary and backup there, we have multiple sites and I'd rather not buy servers and upgrades for each of them.
PPS. Half of this application already runs on JET, but was recently migrated to SQL. So in part we're looking to avoid buying SQL where we didn't have it already because we had JET.
September 2, 2002 at 4:17 pm
Here is some info from Microsoft's web site on MSDE:
http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply