10 Replies Latest reply on Jun 26, 2009 1:32 PM by Todd Puckett

SQL server recomendations

Jason Capriotti Jun 24, 2009 9:17 PM

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

SQL server recomendations

Devon Sowell Jun 25, 2009 1:06 PM (in response to Jason Capriotti)

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 Likes(0)

Actions
- SQL server recomendations
  
  Todd Puckett Jun 25, 2009 1:32 PM (in response to Devon Sowell)
  
  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 Likes(0)
  
  Actions
  - SQL server recomendations
    
    Joy Garon Jun 25, 2009 1:35 PM (in response to Todd Puckett)
    
    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 Likes(0)
    
    Actions
    - SQL server recomendations
      
      Todd Puckett Jun 25, 2009 1:44 PM (in response to Joy Garon)
      
      Joy,
      Does this include the 64 bit version?
      
      Like Show 0 Likes(0)
      
      Actions
      - SQL server recomendations
        
        Joy Garon Jun 25, 2009 2:19 PM (in response to Todd Puckett)
        
        Hi Todd,
        
        Yes - it is all on one DVD now...
        
        Joy
        
        Like Show 0 Likes(0)
        
        Actions
  - SQL server recomendations
    
    Jason Capriotti Jun 25, 2009 5:18 PM (in response to Todd Puckett)
    
    Todd, are you using the PSL license?
    
    Like Show 0 Likes(0)
    
    Actions
    - SQL server recomendations
      
      Todd Puckett Jun 25, 2009 8:58 PM (in response to Jason Capriotti)
      
      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 Likes(0)
      
      Actions
      - SQL server recomendations
        
        Jason Capriotti Jun 25, 2009 9:05 PM (in response to Todd Puckett)
        
        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 Likes(0)
        
        Actions
        
        SQL server recomendations
        
        Todd Puckett Jun 26, 2009 1:32 PM (in response to Jason Capriotti)
        
        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 Likes(0)
        
        Actions
SQL server recomendations

1-YJ1IM Jun 25, 2009 9:43 PM (in response to Jason Capriotti)

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 Likes(0)

Actions

Go to original post