May 31, 2006 at 1:51 pm
Hi people,
Eu never use the SQL Server X Standard Edition. Always Enterprise.
Now my company need buy a SQL Server 2005. We are 150-200 users simultaneous.
I read an article saying that the performance falls with much access. Is it really?
When use Standar or Enterprise ? based in the experience of you and not articles.
Thanks
B
June 1, 2006 at 7:59 am
It is obvious that the perfomance of any server will be affected by the number of simultaneous users. But 150-200 users is not too many for Standard edition.
Look at the feature lists for Standard and Enterprise and focus on the extra features in Enterprise. Here is a good link: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx . Standard edition 2005 includes several features that were Enterprise only in 2000, such as log shipping and using over 4GB of RAM.
Do you have a server with more CPUs than Standard edition supports (4)? Then you obviously need (and can afford) Enterprise edition. Otherwise there are no hardware limits to base your choice on.
Enterprise edition has a lot of desirable features. Are your tables large enough to consider partitioning? Do you need online index rebuilds because you need 24-7 availability and have no maintenence window? Do you need advanced transforms in Integration Services or advanced features in Analysis Services and Reporting Services? Do you need to do Oracle replication? If you need some of these features, then you need Enterprise edition.
But you don't need Enterprise just to have 200 users connect and run queries. If your hardware is up to the job, Standard edition will handle it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply