Speed advatage/benefit in enterprise edition

Suhani Mody

15y2k

does the speed of our website increase if we host our database on enterprise edition instead of express edition?

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Check this out.

SQL Server 2008 is available in many editions to help meet the needs of your organization.

	Core Editions		Specialized Editions			Free Editions
	Enterprise	Standard	Workgroup	Web	Developer	Express	Compact 3.5
Target Scenarios	Enterprise workloads that need redundancy and built-in Business Intelligence	Shared data scenarios in departments and small to large businesses	Remote offices that need local instances of company data	For web application hosting	Full featured edition for development and testing only	Entry level database, ideal for learning and ISV redistribution	Embedded database for developing desktop and mobile applications
CPU	8 CPU	4 CPU	2 CPU	4 CPU	OS Maximum	1 CPU	OS Maximum
Memory	2 TB Ram	64 GB Ram	4 GB	OS Maximum	OS Maximum	1 GB	OS Maximum
DB Size	524PB	524PB	524PB	524PB	524PB	10 GB	4 GB
Additional Resources	Learn More	Learn More	Learn More	Learn More	Learn More	Learn More	Learn More
How to Buy	Volume Licensing Microsoft Store	Volume Licensing Microsoft Store	Volume Licensing Microsoft Store	Volume Licensing	Volume Licensing Microsoft Store	Download now!	Download now!
Licensing	Server/CAL Per Proc	Server/CAL Per Proc	Server/CAL Per Proc	Per Proc	Developer Tools	Free Editions
Pricing	See our Pricing overview page for more details					Free Editions

For a comparison of the features available in each edition of SQL Server, please see here.

Mahesh Chand15y ago
Expression version also allows only one connection while Enterprise can have 100 or more connections. Expression version is good for development and single user only, and can be used as MS-Access.
0
Vilas Gite15y ago
hi Suhani,

There are data limitation in Express edition elsewhere in Enterprise edition no limitation for data. :)
0
Vijay Yadav15y ago
ok! Suhani. According to me, if you will access the database on same pc by express edition it will also work faster as you said about enterprise edition. Lets other suggest regarding the same. :)
0
Suhani Mody15y ago
what I have got to know from my search is that, express edition can use only one CPU, whereas enterprise edition can use multiple.So, I thought it can make increase in speed while fetching data from db on dynamic websites.
0
Vijay Yadav15y ago
Hi Abhi, you are right i also didn't hear anything like this before. And Suhani if you have any idea then please suggest us as well.
0
Abhimanyu K Vatsa15y ago
I don't think so, because I never seen such words 'speed' increases when we use enterprise instead of express.
0