Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Monday, 11 July 2016

What are Minimum/Basic of PreRequests/HardWare Requirements/Memory in Installation of SQL Server?

 Minimum/Basic of  PreRequests/HardWare Requirements/Memory in Installation of SQL Server

The following memory and processor requirements apply to all editions of SQL Server 2016:
ComponentRequirement
Memory*                                                           Minimum:

                                                       Express Editions: 512 MB

                                                      All other editions: 1 GB

                                                      Recommended:

                                                      Express Editions: 1 GB

                                                      All other editions: At least                  4GB                                            be  increased as database size increases to ensure optimal performance.
Processor SpeedMinimum: x64 Processor: 1.4 GHz

 Recommended: 2.0 GHz or faster
Processor Typex64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support


Hard Disk         SQL Server 2016 requires a minimum of 6 GB of available hard-disk space.

.NET Framework            SQL Server 2016 RC1 and later require .NET Framework 4.6
                                        for the Database Engine, Master Data Services, or Replication.
                                        SQL Server 2016   setup automatically installs .NET Framework.
                                        You can also manually install .NET Framework from
                                        Microsoft .NET Framework 4.6 (Web Installer) for Windows.

                                       Windows 8.1, and Windows Server 2012 R2 require KB2919355
                                       before installing .NET Framework 4.6.

SQL Server 2012 Enterprise &Developer & Standard Edition:     

 System Memory(RAM) :

Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.


Drive Space:


SQL Server 2012 requires a minimum of 6 GB of available hard-disk space.

Processors:

Minimum:
  • x86 Processor: 1.0 GHz
  • x64 Processor: 1.4 GHz
Recommended: 2.0 GHz or faster

 .Net FrameWork:

SQL Server Setup installs the following software components required by the product:
  • .NET Framework 3.5 SP11
 
SQL Server 2008 R2 Enterprise &Developer & Standard Edition     

System Memory(RAM) 
 
                     Minimum 512 MB for SQL Server Express with Tools,                                                                               

Drive Space:
  • 2.2 GB of Disk Space


.Net FrameWork:

First, the SQL Server setup program requires Microsoft Windows Installer 4.5 or later. All the x86 and x64 editions of SQL Server, except the SQL Server Express versions, require .NET Framework 3.5 SP1. SQL Server 2008 R2 Express requires .NET Framework 2.0


Processors:
Microsoft requires a minimum processor speed of 1.4GHz but recommends systems with 2.0GHz or faster


SQL Server 2008 Enterprise &Developer & Standard Edition:      

System Memory(RAM) 
                                                                                                    
  • Minimum: 512 MB
  • Recommended: 2.048 GB or more

Drive Space:
verify that you have at least 2.0 GB of available disk space on the system drive for these files 

.Net FrameWork:
NET Framework 3.5 SP11

Processors:
Recommended: 1.0 GHz or faster 

SQL Server 2005 Enterprise &Developer & Standard Edition     

System Memory(RAM) 
                                                                                                     Minimum Memory 1 GB
                                                                                                     Recommended: 1 GB or more

Drive Space:
Before you run Setup to install or upgrade to SQL Server 2005, verify that you have 2.0 GB of available disk space on the system drive for these files

.Net FrameWork:
SQL Server 2005 Express Edition does not install the ..NET Framework 2.0. Before installing SQL Server 2005 Express Edition, you must download and install the .NET Framework 2.0 

Processors:
Minimum: 600 MHz
Recommended: 1 GHz or higher

SQL Server 2000 Enterprise &Developer & Standard Edition

System Memory(RAM) 

Memory: 64MB (128MB recommended for Enterprise edition)

Drive Space:

Hard Disk: 250MB for a typical SQL Server database installation, 130MB for Analysis Components, 80MB for English Query



Operating System:
 Windows NT Server 4.0 (With SP5) or Windows NT Server 4.0 Enterprise Edition (With SP5) or Any version of Windows 2000 Server

Processors:

CPU: Intel-compatible 166MHz or higher 




Some details about SQL 2000 Installation:

Ref:
http://www.databasejournal.com/features/mssql/article.php/1442281/SQL-Server-2000-Installation.htm

Hardware and Software Requirements

Hardware requirements:
  • Intel or compatible platform
  • Pentium 166 MHz or higher (Pentium II, Pentium III and compatible)
  • 32MB RAM (minimum for Desktop Engine), 64MB RAM (minimum for all other editions) 128 MB RAM or more recommended
  • 270MB (full installation), 250MB (typical), 95MB (minimum), 44 MB (Desktop Engine) plus Analysis Services: 50 MB minimum and 130 MB typical and 80MB for the English Query
  • By the way, there is no hardware restriction on the processor speed (you can run SQL Server 2000 on the Pentium with minimum mhz), I have checked it on Pentium 120, but don't use this hardware on production server, only for the test purpose.
    SQL Server 2000 will run under Windows 98, Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5 or later and Windows 2000 (all editions).
    SQL Server 2000 also requires Internet Explorer 5.0 or later, as it is required for Microsoft Management Console and HTML Help. Internet Explorer is not required to be the default browser and a minimal install is sufficient.


    SQL Server Editions

    There are three main SQL Server 2000 editions:
  • Personal Edition
  • Standard Edition
  • Enterprise Edition
  • Personal Edition can works on the Windows 98, Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5 or later and on the all editions of Windows 2000. This edition is related to SQL Server 7.0 Desktop Edition


    This edition has some restrictions:
  • maximum 2 CPU
  • no Distributed Partitioned Views
  • no Log Shipping
  • no Parallel DBCC
  • no Parallel index creation
  • no Failover clustering
  • no publishing for transaction replication
  • maximum 2Gb RAM
  • Standard Edition can works on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.
    This edition has the following restrictions:
  • maximum 4 CPU (up to 8 CPU on the Windows NT Enterprise Edition)
  • no Distributed Partitioned Views
  • no Log Shipping
  • no Parallel index creation
  • no Failover clustering
  • maximum 2Gb RAM
  • Enterprise Edition can works on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.
    This edition can uses:
  • up to 32 CPU on the Windows 2000 DataCenter up to 8 CPU on the Windows 2000 Advanced Server and on the Windows NT Server 4.0 Enterprise Edition up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000 Server
  • up to 64Gb RAM on the Windows 2000 DataCenter up to 8 Gb RAM on the Windows 2000 Advanced Server up to 4 Gb RAM on the Windows 2000 Server up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition up to 2 Gb RAM on the Windows NT Server 4.0
  • Distributed Partitioned Views
  • Log Shipping
  • Parallel index creation
  • Failover clustering
  • There are also Developer Edition, Desktop Engine, SQL Server CE and Evaluation Edition.
    The Developer Edition can be used by developer to create and debug stored procedures, triggers used by client applications. This edition comes with its own compact disc and can be upgraded to SQL Server 2000 Enterprise Edition.
    The Desktop Engine has no graphical user interface and is related to the MSDE, not to the SQL Server 7.0 Desktop Edition. The size of Desktop Engine databases cannot exceed 2 GB. The Desktop Engine can use maximum 2 CPU.
    The SQL Server CE edition can works only on the Microsoft Windows CE, so it has all restrictions of this operation system (can use only 1 CPU, no Parallel index creation, no Full-Text Search and so on).
    The Evaluation Edition can be used only for the test purposes to learn more about the new features and enhancements and should be uninstalled after a 120-day evaluation period.


    Installation Types

    SQL Server Setup offers three installation types in the Setup Type dialog box, when you install the SQL Server 2000 Enterprise Edition, SQL Server 2000 Standard Edition, or SQL Server 2000 Personal Edition, There are three installation types:
  • Typical
  • Minimum
  • Custom
  • Typical

    The Typical installation option is recommended for most users. This is the default installation options. The Typical option installs the upgrade tools, replication support, client management tools, online documentation and so on.

    Minimum

    This installation can takes only 95Mb on your hard drive and contains the minimum configuration necessary to run SQL Server.
    There are no upgrade tools, full-text search, client management tools, online documentation, development tools and code samples.
    Microsoft recommends this installation for users who have computers with minimum available disk space.

    Custom

    This type of installation allows you to change any or all of the default options. Custom installation is recommended for advanced users. You can install code samples, choose to install the development libraries, network libraries, code samples and so on.


    Testing an installation

    There are several ways to test SQL Server 2000 installation. When the installation is complete, you can verify SQL Server installation with osql (or isql) utility. This is the description: 1. Start MSSQLServer service.
    You can start MSSQLServer service by entering from a command prompt:
    net start mssqlserver
    
    or by run SQL Server Service Manager and start MSSQLServer service manually.
    2. Run osql utility.
    Once the server is running, type the following command-line options:
    OSQL -Usa -P
    
    If successful, this osql prompt appears:
    1>
    Now you can verify SQL Server 2000 installation by entering this simple query:
    SELECT @@SERVERNAME
    GO
    
    If successful, this query returns the name of the server on which SQL Server 2000 is running. Now you can exit by typing exit command.