Recommended setting for 'Cost Threshold' for Parallelism on the SQL Instance hosting an ePolicy Orchestrator database
Last Modified: 2022-04-21 11:34:43 Etc/GMT
Affected Products
Languages:
This article is available in the following languages:
Trellix CEO, Bryan Palma, explains the critical need for security that’s always learning.
As per Gartner, "XDR is an emerging technology that can offer improved threat prevention, detection and response."
Trellix announced the establishment of the Trellix Advanced Research Center to advance global threat intelligence.
Trellix Advanced Research Center analyzes threat data on ransomware, nation-states, sectors, vectors, LotL, MITRE ATT&CK techniques, and emails.
As of May 14, 2024, Knowledge Base (KB) articles will only be published and updated in our new Trellix Thrive Knowledge space.
Log in to the Thrive Portal using your OKTA credentials and start searching the new space. Legacy KB IDs are indexed and you will be able to find them easily just by typing the legacy KB ID.
Recommended setting for 'Cost Threshold' for Parallelism on the SQL Instance hosting an ePolicy Orchestrator database
Technical Articles ID:
KB91991
Last Modified: 2022-04-21 11:34:43 Etc/GMT Environment
ePolicy Orchestrator (ePO) 5.x Microsoft SQL Servers — all supported versions For details of ePO and SQL supported environments, see KB51569 - Supported platforms for ePolicy Orchestrator. Summary
We recommend increasing the 'Cost Threshold' for the Parallelism setting on the SQL instance hosting the ePO database. Change the default value of 5 to 50. For more information about this setting and instructions on how to change it, see this Microsoft documentation. NOTE: Changing this setting doesn't require a restart of SQL services to take effect. Affected ProductsLanguages:This article is available in the following languages: |
|