Developer Edition? Why am I only able to use 1 processor and 1GB memory

  • Hi,

    I purchased a developer license for $80 whatever bucks and downloaded what I thought was a developer version. I expected it to walk and talk like Enterprise.

    The iso mounts as SQL2014_enu_x64 I installed, created our production databases on the new dev server and set up replication for the developers. I noticed it ran very slow so check the CPU and memory in SSMS. Its only using 1 processor and 1GB memory on our VPS 4 processor 8GB memory VPS.

    Select @@version returns

    Microsoft SQL Server 2014 - 12.0.2254.0 (X64)

    Jul 25 2014 18:52:51

    Copyright (c) Microsoft Corporation

    Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)

    Any ideas what went wrong? Is the $80buck developer license really a crippled Enterprise evaluation? Did I get ripped off?

    John

    SQL 2012 Standard VPS Windows 2012 Server Standard

  • Looks like you installed using the wrong license or wrong binaries.

    During setup it asks whether you want to enter a product key or use a free edition, such as Enterprise Evalution.

    That said, even if it was an evalutation edition, you should be seeing all CPUs in the machine.

    What does this query return?

    SELECT COUNT(*)

    FROM sys.dm_os_schedulers

    WHERE status = 'VISIBLE ONLINE'

    -- Gianluca Sartori

  • Gianluca,

    Thanks for replying. The response to your query is 1

    I recall selecting 'enter a product key' as opposed to trial version but I can't be sure. I did not recall recieving a product key after supplying my credit card... I just got an installer download and started downloading.

    How can I determine if I have the wrong binary?

    John

    SQL 2012 Standard VPS Windows 2012 Server Standard

  • As far as I know, if you have the FULL media, it should contain all editions and the product key decides which edition you are installing.

    See this question on dba.stackexchange for more info: http://dba.stackexchange.com/questions/35774/sql-server-media-belongs-to-which-edition

    -- Gianluca Sartori

  • However, seeing just one scheduler in Enterprise Edition is weird, even if it is an evalutation edition.

    -- Gianluca Sartori

  • So I'm still not sure what I should do. Is there a chance to 'upgrade' enterprise evaluation to developer? I can't find the receipt and product..... doh!!!

    SQL 2012 Standard VPS Windows 2012 Server Standard

  • I can't find my developer product key and I'm not sure if I can upgrade Enterprise Evaluation to Developer.

    SQL 2012 Standard VPS Windows 2012 Server Standard

  • I found the product key and am now experimenting with the upgrade vs new install option.

    SQL 2012 Standard VPS Windows 2012 Server Standard

Viewing 8 posts - 1 through 7 (of 7 total)

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