DBA Notes Lecture 2

 

DBA Notes Lecture -2

Pre Installation Step of SQL Server

        1.     Check SSD or HDD Size

        2.     Check Version

        3.     Size of database

        4.     RAM

Prerequisites of SQL Server

Depending on the individual version and deployment environment, there may be different requirements for installing Microsoft SQL Server 2019. The general requirements for SQL Server 2019 are as follows, though:

    1.     Operating System: Windows Server 2019, Windows Server 2016, Windows 10, and Windows 8.1

    2.     Hardware Requirements: 4GB RAM, 100 GB HDD

    3.     .NET Framework: .NET Framework 4.8.

It's important to consult the official Microsoft documentation for SQL Server 2019 to get the most up-to-date and accurate information on prerequisites based on your specific deployment requirements and edition of SQL Server 2019.

Notes: Always check prerequisites based on your specific deployment requirements and edition of SQL Server on official Microsoft website.

 

Instance - Copy of SQL Server (50)

Instance is a separate or copy of SQL Server and we can make up to 50 Instances on a Single Machine.

1.     Each SQL Server instance is identified by a unique name and can host multiple databases. By default, the default instance is named "MSSQLSERVER," but you can specify a custom name during installation.

2.     Port and Network Protocols: Each SQL Server instance is assigned a default network port (1433)

3.     SQL Browser -1434

4.     SQL Browser allow multiple port to communicate with applications.

Installation of SQL Server 2019

·      Step By Step Installation Of Microsoft SQLServer On Windows

Please Review 

    ·      Data Directories – Keep files in seprates drives(mdf, ndf and ldf files).

    ·      Tempdb - One tempdb data file per logical processor up to 8 data files.

    ·      MaxDOP-  Default is the same as the number of the cores.

    ·      Memory – 80% Memory of whole Server.

Note: Focus On Business Needs/Requirements.