Post reply

Which version of SQL Server do I need?

  • December 2, 2004 at 4:19 pm

    #87230

    Hi - I'm currently running MSDE on my site - and can see it beginning to creak.

    Having an idea of the cost of SQL Server, what is the most basic version I can purchase to install on a server (W2003 Web Edition - 1 processor), which will allow any number of site visitors to use the data within a database in Sql Server?

    Do the CALs I keep hearing about refer to the people using my site, and using pages which query the SQL Server?

    Would the Standard edition be acceptable for this?

    Thanks, Mark

  • December 2, 2004 at 5:43 pm

    #532323

    If SQL Server is powering a web app, you cannot buy a licence that refers to CALs and must instead purchase a 'processor' licence.

    So you need the standard edition with a single processor licence. Hope your site generates a lot of revenue to pay for it!

    Phil

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • December 2, 2004 at 5:56 pm

    #532324

    If your website is for authenticated people in your company, you'd use CALs. If it's the internet and anonymous people, it's per CPU.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • December 3, 2004 at 7:35 am

    #532435

    Explain how "MSDE is Creaking along"???

  • December 3, 2004 at 7:56 am

    #532454

    I know it almost sounds like blasphemy in this place, but have you considered the use of an open source system?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 3, 2004 at 8:13 am

    #532460

    Hi - MSDE is creaking (imo) because in the event logs I see the 'exceeded 8 concurrent connections' too many times.  The site is not busy yet either!  What I was trying to find out is if my interpretation of the event logs, is resulting in a visible effect on performance for visitors to the site.  From what I've read though, the delays introduced are minimal, and most likely have no visible effects (the queries/SPs I run only return small amounts of data anyway).

    I have, and do use MySQL elsewhere - but went to MSDE as it was part of a windows server package I lease - and it works well with .Net data providers.

    I know MySQL 5 now has SPs, but I would be uncomfortable transferring the tables and data to another database.  Eg. how would I transfer three tables which have a one to many to many relationship?  Autonumber fields are generated by the db server are they not?  If there's a way around this, then I most likely would consider that option until the site is busy enough to justify a proper SQL licence.

    Thanks again, Mark

  • December 3, 2004 at 8:20 am

    #532466

    MySQL is just one Open Source system. PostGreSQL is quite popular, MaxDB, the former SAPDb and many others.

    Btw, MySQL supports also such a thing as Autonumber, but there it's called AutoIncrement. AFAIK, there are tools that will assist in the move, but if you really consider this an option you might be better off asking this on a MySQL mailing list at http://www.mysql.com.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 6, 2004 at 4:24 am

    #532609

    Wat version of msde are you using? MSDE 2.0 has support for 25 concurrent users MSDE 1.0 for 5....

    (I think you are on 1.0 so an upgrade to 2.0 could buy you some time...)

  • December 6, 2004 at 3:16 pm

    #532763

    Hi - thank you, I wasn't aware there was another version - I'm presuming I have V1.0 - is there a way I can tell? Also, does V2 have the same licence agreement?

    I'm presuming that it's not SQL Server 2005 Express (which you can't use in a live environment yet) that you're referring to?

    Thanks again, Mark

  • December 7, 2004 at 5:59 am

    #532807

    The version of sql server: Select @@version

    I do not know of the licence agreement is suited for your situation (You have to check it yourself)

    SQL Server 2005 Express is the stripped SQL server 2005

    MSDE v2/MSDE 2000 is the stripped SQL 2000 version

    Greetings, Henry

     

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply