Welcome
Tuning performance
Learn how to plan the infrastructure of BigFix Inventory and to configure the application server to achieve optimal performance. The following guidelines are applicable in big data environments as well as in smaller environments that are running on low-performance hardware.
Tuning performance in medium and large environments
You can learn the possible causes of the most common performance issues in medium and large environments. Follow the tips and the known solutions to these issues to keep the system in good shape and avoid performance problems.
Tuning MS SQL application database
To avoid performance issues in medium and large environments, configure the location of the transaction log. If you are using MS SQL as BigFix Inventory database, you might want to shrink the transaction log or update query optimization statistics.
MS SQL 2016 or higher: Falling back to Legal Cardinality Estimation
This topic explains the behavior of Microsoft SQL Server 2016 and later versions when the query optimizer falls back to using the legacy cardinality estimation model. It covers the circumstances under which this occurs, the implications on query performance, and how to manage or disable this fallback to ensure optimal query execution plans.

BigFix Documentation Homepage
BigFix 11 Inventory Documentation
Welcome to the BigFix Inventory documentation, where you can find information about how to install and configure BigFix Inventory. The application provides you with information about your inventory and license metrics. You can manage your software assets, gather information about your hardware, and ensure license compliance for your enterprise using BigFix Inventory.
BigFix Platform
BigFix Scanner (New)
Overview
Become familiar with key concepts that are necessary to understand how BigFix Inventory works and learn about features and functions that are introduced in every version of the application.
Installing
Learn about the requirements and available installation scenarios to ensure that the deployment of BigFix Inventory goes smoothly in your environment.
Configuring
After you install BigFix Inventory, configure the application. Create accounts for the users who need access to the application and set up scans to collect software and hardware inventory data from your environment.
Upgrading
A new version of BigFix Inventory is released periodically, typically at the end of each calendar quarter. Upgrade to the new version regularly to take full advantage of new features and application fixes.
Catalog Overview
This section provides information about catalog updates available with every release.
Managing the infrastructure
After you complete the initial configuration of BigFix Inventory, learn how to manage components of its infrastructure: VM managers, server, database, and data sources.
Software inventory and license utilization
You can classify the discovered software so that reports in BigFix Inventory reflect your entitlements and properly show utilization of license metrics by particular products.
Managing security threats
Learn how to use BigFix Inventory to manage security threats in your environment. You can view whether any of the installed components is prone to any Common Vulnerability and Exposure (CVE).
Tutorials
Tutorials help you understand how to use BigFix Inventory. They consist of modules that focus on broad goals. Modules consist of tasks that show how to configure specific settings step-by-step.
Security
Configure different security features to adequately protect business assets and resources in the data model when using BigFix Inventory.
Troubleshooting and support
Learn about solutions to common problems that might arise when you use BigFix Inventory BigFix Inventory and how to find logs and trace files that help you troubleshoot those problems.
Tuning performance
Learn how to plan the infrastructure of BigFix Inventory and to configure the application server to achieve optimal performance. The following guidelines are applicable in big data environments as well as in smaller environments that are running on low-performance hardware.
- Setting up scans and import
  Learn how to improve the scanning and importing activities to optimize the performance in your infrastructure.
- Additional tasks for improving performance
  Learn about additional tasks that you might want to perform to improve the performance in your infrastructure.
- Tuning performance in medium and large environments
  You can learn the possible causes of the most common performance issues in medium and large environments. Follow the tips and the known solutions to these issues to keep the system in good shape and avoid performance problems.
  - Tuning DB2 application database
    To avoid performance issues in medium and large environments, configure the location of the transaction log and adjust the log size. If you are using DB2 as BigFix Inventory database, you might want also to change the swappiness parameter in Linux or configure the DB2_COMPATIBILITY_VECTOR.
  - Tuning MS SQL application database
    To avoid performance issues in medium and large environments, configure the location of the transaction log. If you are using MS SQL as BigFix Inventory database, you might want to shrink the transaction log or update query optimization statistics.
    - Optimizing the tempdb database in Microsoft SQL Server
      tempdb is a system database in SQL Server whose main functions are to store temporary tables, cursors, stored procedures, and other internal objects that are created by the database engine.
    - MS SQL Server transaction log related activities
      Perform the following activities to improve the performance and the reliability of your environment.
    - Rebuilding database indexes
      Rebuilding database indexes and updating the statistics is mandatory for BigFix Inventory to operate smoothly. If you experience a delay in UI response or importing data, make sure to defragment your hard disk and that statistics are up to date.
    - SQL server parallelism optimization
      BigFix Inventory follows the process mentioned in SQL Server parallelism optimization to improve the database performance.
    - MS SQL 2016 or higher: Falling back to Legal Cardinality Estimation
      This topic explains the behavior of Microsoft SQL Server 2016 and later versions when the query optimizer falls back to using the legacy cardinality estimation model. It covers the circumstances under which this occurs, the implications on query performance, and how to manage or disable this fallback to ensure optimal query execution plans.
  - Tuning Java Virtual Machine
    To avoid performance issues in medium and large environments, configure the Java heap space.
- REST API considerations
  You can use BigFix Inventory REST API to retrieve large amounts of data that is related to computer systems, software instances, and license usage in your environment. Such information can then be passed to other applications for further processing and analysis.
Integrating with REST API
External systems integration is one of the key features of BigFix Inventory. Business logic is enabled for integration and interfaces are provided for common integration points.
Glossary
Guide in PDF format
DataFlow ServiceNow Integration
Service Graph Connector Integration

MS SQL 2016 or higher: Falling back to Legal Cardinality Estimation

This topic explains the behavior of Microsoft SQL Server 2016 and later versions when the query optimizer falls back to using the legacy cardinality estimation model. It covers the circumstances under which this occurs, the implications on query performance, and how to manage or disable this fallback to ensure optimal query execution plans.

If you see issues with Data Import steps and the following message appears:

Import log last message entries:
INFO: ETL from SAM::UsageFact: Start
INFO: Parsing raw usage results. This may take a long time.
The import job just hangs and ends only with user interruption.

Change the MS SQL Server BigFix Inventory Database setting "LEGACY_CARDINALITY_ESTIMATION" to "ON".

Perform the following steps to apply the changes:

Stop the data import.
Ensure that the setting in the BigFix Inventory database LEGACY_CARDINALITY_ESTIMATIONis turned on. Use the below command:
```
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = ON
```
Run the import.