Solved

Software Vendor Recommendation: SQL Standard 2000-Per Processor Version

Posted on 2006-11-20
4
207 Views
Last Modified: 2008-02-01
I am a third-party network administrator.  I am working with a client whose software vendor has recommended upgrading MSDE to SQL 2000 Standard-specifically the "Per Processor" version.  They have stated the following relating to this recommendation:
1-Their product is only supported on SQL 2K Standard up to SP3a......not SP4
2-Their product is not supported on the latest version of SQL Standard (2005?) and support for that version of SQL is at least a year out.

I'm not feeling too warm and fuzzy about this vendor based on these and other recommendations they have made in the past.....and I'm curious what a SQL specialist would say in response to these SQL-related vendor recommendations.  You can email me at <<email removed by kb Experts Exchange Moderator>>  Thanks in advance for your help!
0
Comment
Question by:jdsurette
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 29

Expert Comment

by:Nightman
ID: 17982488
Why is their product not supported on 2K SP4? Anyway, the latest SP is available (and recommended) for standard edition.
Why do they feel the need to upgrade from MSDE to Standard?
0
 
LVL 9

Expert Comment

by:udayshankar
ID: 17982505
Sounds fine to me.
most new apps dont suport 2005 yet. but as long as they are wokring towards it should be fine.

Only thing is. why per processor? if you have very few users you might want to go for "per seat" so thats the only thing i would ask them again. if per prosessor is mandatory.

0
 

Author Comment

by:jdsurette
ID: 17982556
Regarding 2K SP4, they apparently ran into lots of issues with SP4 and have not resolved them yet.  Regarding upgrading from MSDE, they are getting messages in the SQL logs indicating that they have exceeded the concurrent user threshold (8 concurrent user limit??)  

They have recommended per processor licensing to help the client avoid the costs associated with purchasing SQL client licenses for each workstation.
0
 
LVL 29

Accepted Solution

by:
Nightman earned 500 total points
ID: 17982586
SP3a vs SP4 should not be significant. It would be interesting to know what problems they had.
MSDE limit is actually 5 concurrent users - and it throttles performance with more! Also, MSDE has file size limitations (2GB) on the data file.

Do a cost benefit analysis on per seat vs. per processor - whichever is cheaper should be the one you go for (keep in mind increasing connections later, and that I don't think that you can change this in any given year).
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question