Home
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.
SQL server parallelism optimization
BigFix Inventory follows the process mentioned in SQL Server parallelism optimization to improve the database performance.

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

SQL server parallelism optimization

BigFix Inventory follows the process mentioned in SQL Server parallelism optimization to improve the database performance.