<< 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 |