MS SQL Server
-
Should I buy Standard or Enterprise? I have to run it on a dual processor Windows 2000 Server, not clustered. But, I need to optimize it for performance. Is there any place, where I can get a comparison of these two? Thomas
You can get a 120 day trial version of both at MS. My latest articles: XOR tricks for RAID data protection Win32 process suspend/resume tool
-
You can get a 120 day trial version of both at MS. My latest articles: XOR tricks for RAID data protection Win32 process suspend/resume tool
Thank you. Actually I do have both from MSDN. But, I wanted to see which one of them suits me more based on some tests or documentation by Microsoft or some one else, which would suggest the situations where each of them is suited for, rather than me taking a decision solely based on a few performance tests that I do (I am already doing my own tests.). I have to buy SQL Server before I can use it for production. The pricing is quite high for enterprise. So, I want to find out, if I am missing any info when I am making this choice (right now, leaning towards standard :) ) Thank you
-
Should I buy Standard or Enterprise? I have to run it on a dual processor Windows 2000 Server, not clustered. But, I need to optimize it for performance. Is there any place, where I can get a comparison of these two? Thomas
You can check this URL: http://www.microsoft.com/sql/evaluation/features/choosing.asp[^] and check which features you need. Mauricio Ritter - Brazil Sonorking now: 100.13560 MRitter :jig: I've gone sending to outer space, to find another race :jig:
-
Should I buy Standard or Enterprise? I have to run it on a dual processor Windows 2000 Server, not clustered. But, I need to optimize it for performance. Is there any place, where I can get a comparison of these two? Thomas
Hiya! There is some docs on the SqlServer product site as well as books online that gives a feature list broken down by version. I'm actually a SQLServer DBa (among others) and generally most apps will run ok on Standard. The only time I consider Enterprise is when I start looking at much larger boxes (8procs, 4gig or more memory). will you get the absolute best performance out of Standard? Probably not, but it really depends on how your apps work whether it will make that much of a differencec going up to Enterprise and getting the enhanced parallelism. Mark Conger
-
Hiya! There is some docs on the SqlServer product site as well as books online that gives a feature list broken down by version. I'm actually a SQLServer DBa (among others) and generally most apps will run ok on Standard. The only time I consider Enterprise is when I start looking at much larger boxes (8procs, 4gig or more memory). will you get the absolute best performance out of Standard? Probably not, but it really depends on how your apps work whether it will make that much of a differencec going up to Enterprise and getting the enhanced parallelism. Mark Conger
Thank you for the info. My apps run very short duration single row update/inserts from stored procdures. The system uses an offline method to update the database. So, the availability is not critical. When the server comes back up, all data will be synchronized with an in-memory database. I went to the other links also (given in the other replies), and it so seems that I need a Standard, because I have less than 4 processors, only 512 MB RAM and my database will be much smaller than 2GB. Thank you again.
-
Thank you for the info. My apps run very short duration single row update/inserts from stored procdures. The system uses an offline method to update the database. So, the availability is not critical. When the server comes back up, all data will be synchronized with an in-memory database. I went to the other links also (given in the other replies), and it so seems that I need a Standard, because I have less than 4 processors, only 512 MB RAM and my database will be much smaller than 2GB. Thank you again.
If all you're doing is single row inserts then I would never consider the Enterprise unless you are dealing with many thousands of transacts a sec. Mark
-
Thank you. Actually I do have both from MSDN. But, I wanted to see which one of them suits me more based on some tests or documentation by Microsoft or some one else, which would suggest the situations where each of them is suited for, rather than me taking a decision solely based on a few performance tests that I do (I am already doing my own tests.). I have to buy SQL Server before I can use it for production. The pricing is quite high for enterprise. So, I want to find out, if I am missing any info when I am making this choice (right now, leaning towards standard :) ) Thank you
The enterprise edition really only buys you clustering ability, ability to have indexed views, more than 2GB of RAM, more than 4 CPU's. I've used both editions and haven't seen any major performance difference. Although I've only ever run enterprise on mission critical sites under heavy load. See http://www.microsoft.com/sql/techinfo/planning/ChoosEd.doc for more info. Hope this helps. Jason Cono, MCSD jcono@ripedev.com