SQL Server on Linux :- Qualification Process

Background

Let us make sure that we can install SQL Server on our Linux system.

System Requirements

Here are the System Requirements.systemRequirements.20181121.0914AM

Outline

Here are the checks that we will perform :-

  1. Disk
    • File System
      • File System Type ( XFS, EXT4 )
  2. CPU
    • Processor Speed ( 2 GHz )
    • Architecture ( 64-bit )

 

Qualify

Disk

File System

File System Type

Objective

The supported File System types are:-

  1. Supported
    • XFS
    • EXT4
  2. Unsupported
    • BTRFS
Code

df -hT

Output
Output – Computer #01
fileSystemType.20181121.0800AM
Explanation #1
  1. Our File System is reiserfs
Output
Output – Computer #02
fileSystemType.computer02.20181121.1143AM.PNG
Explanation #1
  1. File System
    • Syntax :- /dev/mapper/<computer>
    • Sample :- /dev/mapper/centos_adriel-home
      • xfs

 

CPU

Clock Speed

Let us quickly review our CPU’s clock speed.

lscpu

Objective

Invoke lscpu

Code
Syntax
lscpu
Sample

lscpu | grep "CPU"

Output
Output #1 ( Computer – 01 )
cpu.clockSpeed.lscpu.comp1.20181121.0842AM.PNG
Explanation #1
  1. CPU(s) :-2
  2. CPU MHz :- 1997.386 MHz ( 2 GHz)
  3. NUMA node 0 CPU(s) :- 0,1
    • 2 Core
Output #2 ( Computer – 02 )
cpu.clockSpeed.lscpu.comp2.20181121.1150AM.PNG
Explanation #2
  1. CPU(s) :- 4
  2. CPU MHz :-
    • CPU MHz :- 1102.642 MHz ( 2 GHz)
    • CPU max MHz :- 3100.0000 MHz ( 3 GHz)
    • CPU min MHz :- 400.0000 MHz ( 0.4 GHz)
  3. NUMA node 0 CPU(s) :- 0,3
    • 2 Core

 

/proc/cpuinfo

Objective

Please issue cat against /proc/cpuinfo

Code
Syntax

cat /proc/cpuinfo
Sample
cat /proc/cpuinfo | grep "processor\|cpu"
Output
Output #1
cpu.clockSpeed.comp1.20181121.0836AM
Explanation #1
  1. We appear to have two CPUs, 1997 MHz ( 2 GHz)
Output #2
cpu.clockSpeed.comp2.20181121.1209PM.PNG
Explanation #1
  1. We appear to have four CPUs, 1010 MHz ( 2 GHz) and 2 Cores

 

Architecture

Are we 32 or 64 bit?

lscpu

Objective

Invoke lscpu

Code
Syntax

lscpu
Sample

lscpu | grep Architecture

Output
Output #1
cpu.clockSpeed.lscpu.architecture.comp1.20181121.0855AM
Explanation #1
  1. Architecture
    • x86_64

uname

Objective

Please run uname

Code
Syntax
uname -m
Sample

uname -m

Output
Output #1
uname.-m.20181121.0905AM.PNG
Explanation #1
  1. uname -m
    • 64 bit
      • x86_64
    • 32 bit
      • i686 or i386

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s