Long-running sleeping queries are left open to the SQL Server when the Support Center extension is installed
Last Modified: 2023-08-01 10:39:31 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.
Long-running sleeping queries are left open to the SQL Server when the Support Center extension is installed
Technical Articles ID:
KB92201
Last Modified: 2023-08-01 10:39:31 Etc/GMT EnvironmentProblem
An ePO server with the Support Center extension installed executes queries against the SQL database. In certain circumstances, some of these queries aren't closed and remain in a sleeping state. This action in turn holds a connection open, which can cause The queries in question are as follows: And Select AutoID, ProxyID, Address from [EPORepositoryProxyExclusionList] where ProxyID='1' New instances of these queries are executed on a scheduled basis, so you might see multiple instances of these sleeping queries. Solution
This issue is resolved with Support Center extension 5.10.0 Update 2. Issue resolutions in updates and major releases are cumulative; Technical Support recommends that you install the latest version. To find the most recent release for your product, go to the Product Downloads site.
Our product software, upgrades, maintenance releases, and documentation are available on the Product Downloads site.
NOTE: You need a valid Grant Number for access. See KB56057 - How to download product updates and documentation for more information about the Product Downloads site, and alternate locations for some products. Workaround
If you aren't using the Support Center feature, remove the extension from ePO. This action prevents the long-running connections.
Affected ProductsLanguages:This article is available in the following languages: |
|