AnsweredAssumed Answered

SQL server recomendations

Question asked by Jason Capriotti on Jun 24, 2009
Latest reply on Jun 26, 2009 by Todd Puckett

Like • Show 0 Likes0
Comment • 10

We are about to order a server for the SQL database for Enterprise. We are purchasing the PSL (Processor site license) and I'm concerned about the processor limit. I beleive from what I read in the knowledge base that the PSL means you can only have one processor in the server. Is this correct or can you have more.....our IT dept usually puts in dual quad cores in our servers. I don't want to order it only to find it it won't run.

Should I push for a 2003 server x64 or just go with 32bit 2003? I expect some push back with IT regarding the 64bit OS but I'm concerned about the memory limits of 32bit.

We plan to have 100 license to start and another 100 later so I was wondering how much horsepower we need.

Importing:
40000+ Solidworks files.
10000+ Other file types
50000+ PDF files

No one else has this question

Outcomes

10 Replies

Devon Sowell Jun 25, 2009 1:06 PM
Mark Correct
Correct Answer
Hello Jason-

Ask your reseller for a copy of the SolidWorks Excel spreadsheet that calculates the spec's for server CPU(s), RAM, and Disc space, it's slick.
Like • Show 0 Likes0
Actions
- Todd Puckett @ Devon Sowell on Jun 25, 2009 1:32 PM
  Mark Correct
  Correct Answer
  Jason,
  SQL Server 2005 is provided with EPDMW. We were able to request the 64 bit version and install it on a server with 2 quad core processors without any licensing problems. We have 200 licenses.
  I would definitely choose the 64 bit version for greater memory access. Why have a new robust server and then limit it by using a 32 bit OS?
  
  Todd
  Like • Show 0 Likes0
  Actions
  - Joy Garon @ Todd Puckett on Jun 25, 2009 1:35 PM
    Mark Correct
    Correct Answer
    Hi Jason and Todd,
    
    Just an FYI.. we are now shipping SQL Server 2008 Standard Edition as part of the product.
    
    Regards,
    Joy
    Like • Show 0 Likes0
    Actions
    - Todd Puckett @ Joy Garon on Jun 25, 2009 1:44 PM
      Mark Correct
      Correct Answer
      Joy,
      Does this include the 64 bit version?
      Like • Show 0 Likes0
      Actions
      - Joy Garon @ Todd Puckett on Jun 25, 2009 2:19 PM
        Mark Correct
        Correct Answer
        Hi Todd,
        
        Yes - it is all on one DVD now...
        
        Joy
        Like • Show 0 Likes0
        Actions
  - Jason Capriotti @ Todd Puckett on Jun 25, 2009 5:18 PM
    Mark Correct
    Correct Answer
    Todd, are you using the PSL license?
    Like • Show 0 Likes0
    Actions
    - Todd Puckett @ Jason Capriotti on Jun 25, 2009 8:58 PM
      Mark Correct
      Correct Answer
      I think the copy of SQL 2005 that came with SPDMW 2009 is for one multicore processor.
      Since we are running our SQL server on VMware we have it set to use 2 cores, which is more that adequate, we can always bump it to 4 if necessary. We are not running archive server or web server on this server (I don't think the web server is 64 bit compatable).
      Like • Show 0 Likes0
      Actions
      - Jason Capriotti @ Todd Puckett on Jun 25, 2009 9:05 PM
        Mark Correct
        Correct Answer
        I was meaning the license type you have, did buy the indivdual licenses (Contributor, CAD editor, etc) or the PSL license which allows you use any combination.
        
        I think from what I'm reading, if you buy indivdual licenses of Enterprise, you can make use of as many processors (not cores) as you want. If you buy the PSL license, you are limited to one processor.
        
        If that's the case, is it a performance issue, and can you still install it on a dual processor server.
        Like • Show 0 Likes0
        Actions
        Todd Puckett @ Jason Capriotti on Jun 26, 2009 1:32 PM
        Mark Correct
        Correct Answer
        A dual processor server will work but isn't necessary in my opinion. Our archive server uses very little processor and memory. The database server uses moderate processor and high memory (5 Gb). It also depends on if your going to be using this server for anything other than EPDMW.
        The version of SQL provided with EPDMW is limited to 1 processor, but will install on a multiprocessor server.
        
        We usually have 50 users in the system at any given time. Our vault is 500Gb with over 600,000 files. We do not use workflow. We are not using the Processor Licence for EPDM, 170 Editor and 30 Web.
        Like • Show 0 Likes0
        Actions
1-YJ1IM Jun 25, 2009 9:43 PM
Mark Correct
Correct Answer
Jason, the PSL is misleading. It is not processors, it is clients. A user with a dual core processor of even two processors is only tying up one of the PSL license.
Like • Show 0 Likes0
Actions

SQL server recomendations

Outcomes

Related Content

Recommended Content