AA Inputs For Microsoft SQL Server

<< Click to Display Table of Contents >>

Navigation:  Modules > Asset Management > Software License Management > Authorization Analyzer (Complex license types) > Inputs Required >

AA Inputs For Microsoft SQL Server

The following matrix describes the data points used for calculating the license units required for Microsoft SQL Server.  

 

Data Point

Data Type

Field Size

Req/Opt

Notes

Is Virtual

Int

4

Required

0 for no, -1 for yes

Processors

Int

4

Required

# of processors on physical machine

or

# of virtual processors (if VM)

Cores

Int

4

Required

# of cores on physical machine

or

# of virtual cores (if VM)

Hyper-threading (HTT)

Int

4

Required

0 for off, -1 for on

(this is an attribute of the physical asset)

Logical processors

Int

4

Required

(if HTT on)

# of threads on the physical machine if HTT is on.

Physical parent of VM

nvarchar

80

Required

(if VM)

Name of physical machine and/or asset number of physical machine

Processor Manufacturer

nvarchar

80

Required

Processor Manufacturer

Cluster name

nvarchar

80

Required

(if in cluster)

Name of cluster (if participating in cluster).  If VM, physical parent must have this populated if it participates in a cluster)

Cluster node type

nvarchar

50

Required

(if in cluster)

Active or Passive

OEM processor count

Int

4

Optional

OEM standard configuration

OEM core count

Int

4

Optional

OEM standard configuration

Manufacturer

nvarchar

80

Optional

Manufacturer

Model

nvarchar

40

Optional

Model

Product Description

nvarchar

40

Optional

Product Description

OEM Processor Manufacturer

nvarchar

40

Optional

OEM Processor Manufacturer