Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lwrg
Starting Member
1 Post |
 Posted - 2007-03-07 : 09:14:35
|
What are the benefits of the Enterprise edition over the standard edition of SQL 2005?I am developing a large database which will be holding up to 300 GB of data at any given time. There are also a lot of queries that are being used and (at the moment) run quite slowly on our standard edition of SQL.Basically what i'm asking is would upgrading to the enterprise edition improve the performance of my sql queries? Is there anything else that would justify all that extra money spent on a enterprise edition?Many thanks in advance! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-03-07 : 09:30:51
|
| Check this article for comparison between standard edition and Enterprise edition:[url]http://www.microsoft.com/sql/editions/enterprise/comparison.mspx[/url]Also, upgrading to Enterprise Edition will not automatically improve your query performance. You need to make effort to tune them.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-07 : 11:20:58
|
| "run quite slowly on our standard edition of SQL"Posting one/some of them here and seeking suggestions for performance improvements would probably be a good idea before spending ANY money on Hardware / Enterprise ...300GB is a large database, I would expect any reasonable complex query (e.g. its not just a range on the Clustered Index!) to need careful tuning.Have you got decent maintenance routines in place? (Update stats, rebuild indexes, recompile slow-running procedures, etc?)Is any of this SQL dynamic?Kristen |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Benefits of Enterprise edition?