How to configure Database Activity Monitoring to use In-Process Monitoring in Microsoft SQL Server
Last Modified: 2023-09-13 12:02:09 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.
How to configure Database Activity Monitoring to use In-Process Monitoring in Microsoft SQL Server
Technical Articles ID:
KB87151
Last Modified: 2023-09-13 12:02:09 Etc/GMT EnvironmentDatabase Activity Monitoring (DAM) 4.x
Sensor 4.4.9-17815 and later
Microsoft SQL Server 2008, 2008r2, 2012, 2014 (64-bit only)
SummaryIn-Process Monitoring (IPM) is a DAM method that the Microsoft SQL Server uses. IPM allows you to monitor the SQL Server memory activity in-process. This method is another way to monitor the default memory monitoring technology, which is based on out-of-process memory monitoring.
IPM is achieved by using Windows support to load an application DLL into the SQL Server process. The DLL monitors the SQL Server's activity and communicates with the DAM Sensor. This method allows the Sensor deeper insight into the SQL Server's activity and reduces performance overhead. To configure IPM, perform the following steps:
Related InformationWhen you enable IPM, the SQL Server running process
IMPORTANT: Microsoft SQL 2014 is supported in Sensor 4.7.0 and later.
DAM reports the following SQL command types differently when you enable IPM:
For more information, see KB83070 - How to add an advanced parameter to a Database Activity Monitoring sensor. Affected ProductsLanguages:This article is available in the following languages: |
|