Category
Product Version
Topic
Subtopic
Alerting has a limit of 10 notifications per minute and subsequently causes extensive memory usage and alert duplication (4375495)
Alerting has a limit of 10 notifications per minute.<br><br>Can the way the application forwards and handles notifications in the background between components be addressed, to remove this constraint?<br><br>When communication between the central and the distributed server continuously interrupts, alerts are not sent to the central server, and memory usage significantly increases.
The date range of reports does not include the entire month or includes days from the previous month when "Last one month" is selected as the period for report generation. (4375054)
Start ApexSQL Audit, add a server and database for auditing using any technology ... Go to Start, find Services and stop the Windows time service (to be able to change the date and time on the VM without issues)
SQL Parser throws a syntax error during the parsing of a T-SQL query "EXECUTE AS USER = SUSER_NAME()" (4375069)
Connect to the audited server in SSMS and make sure that the current user (the user which is currently logged in) is mapped to the database you are auditing. ... In the context of the db that is being audited, run the following command: EXECUTE AS USER = SUSER_NAME();
Can ApexSQL Audit monitor scheduled SQL Server Agent jobs? (4373215)
ApexSQL Audit can monitor scheduled SQL Server Agent jobs but for that either SQL Audit or Trace auditing technology must be used, since the Extended events technology have limitation in the way SQL Server is gathering events into a session file.<br><br>So to change auditing technology for the SQL Server that is currently in use within the ApexSQL Audit, please navigate to the Configuration tab, select the SQL Server and click on the Edit button.
Preparing for ApexSQL Audit Upgrade (4372941)
Export the auditing configuration for both server and database levels. ... If the configuration is different across servers, individual templates will need to be exported for each server/database.
ApexSQL Audit installation guides (4211247)
This article provides key information and links to all important ApexSQL Audit installation articles, making it easier for users to locate relevant articles and easy implement ApexSQL Audit into their respective environment.
ApexSQL Audit 2021.01 building up files in Quarantine folder (4373734)
While troubleshooting the reasons ApexSQL Audit stopped, the quarantine folder takes large amount of drive space where the temporary folder is located. ... Package 019e4da6-15a6-49ab-b4a6-285aa44f8449.ApexSqlComplyPackage will be moved to quarantine folder due to following error: Unable to read beyond the end of the stream.<br><br> The query or the information captured goes over the default 512- character limit of the sql data captured and the information is truncated causing the issue.
Installing ApexSQL Audit (4341140)
This article describes how to install ApexSQL Audit and its components. ... Permissions and requirements ... Before proceeding with ApexSQL Audit deployment, please check the Permissions and requirements knowledgebase article to ensure that your target system meets the requirements listed in the article.
Deploying, installing and configuring ApexSQL Audit in a clustered environment (4211283)
<p>ApexSQL Audit supports auditing of SQL Server clusters right out of the box, whether they are in simple Failover mode or with Always On – High availability groups. ... At any moment, the active node is being audited and if the failover occurs, the auditing will switch to the newly activated node automatically.</p>
How to process thousands of packages within the Received Packages_old folder? (4373701)
The above mentioned packages should be moved to the newly created <strong>Received Packages </strong>folder manually, in the times when SQL Server has low traffic.<br>Simply select up to 500 packages from it and move it to the new folder, thus emptying the "old" folder for that amount of packages.<br><br>If there are packages within the <strong>Quarantine </strong>folder as well, than the same process should be repeated when SQL traffic is low, select up to 500 packages from it and
Why is 'Active Traces' folder empty for monitored SQL Server instance? (4373700)
Why is the 'Active Traces' folder empty for a monitored SQL Server instance? When Auto is set for auditing data collection while configuring SQL Server audit technology within the ApexSQL Audit, it will use the latest available technology:<br><br>SQL Server 2005 - Trace<br>SQL Server 2008 - Trace<br>SQL Server 2012 - Extended events (Auto), Trace<br>SQL Server 2014 - Extended events (Auto), Trace<br>SQL Server 2016 - Extended events (Auto), Trace<br>SQL Server 2017 - SQL Audit (Auto), Extended events, Trace<br>SQL Server 2019 - SQL Audit (Auto), Extended events, Trace<br>SQL Server 2022 - SQL Audit (Auto), Extended events, Trace<br><br>For SQL Servers 2017, 2019 and 2022 by default the SQL Audit technology is set and for those instances Active Traces folders should be empty, for other servers where Trace technology is selected those folders will have active traces in it.<br>This is as designed behavior
ApexSQL Audit Processor Distributed process high ram usage (4373694)
ApexSQL Audit Processor Distributed process high ram usage on the machine running the affected SQL Server<br> WORKAROUND<br>The following is the text file of the restart DistributedProcess powershell script:<br><br># Variable for storing the the log file path for ApexSQL Audit process restarts<br>$filePath = "C:\Users\central\Desktop\TestPath\restartingDistributedProcess.txt"<br><br>#Check if the process named "ApexSQL.Audit.Processor.Distributed" is running and restart it (end it)<br>if (Get-Process -Name ApexSQL.Audit.Processor.Distributed -ErrorAction SilentlyContinue) <br>{<br> taskkill /IM ApexSQL.Audit.Processor.Distributed.exe /F<br><br> # Write/append output to the textual log file every time the process is successfully restarted<br> "[$(Get-Date)] ApexSQL.Audit.Processor.Distributed process(es) successfully restarted." | Out-file $filePath -Width 200 -Append<br><br>} <br>else <br>{<br> # Write/append output to the textual log file every time the process is not successfully restarted<br> "[$(Get-Date)] ApexSQL.Audit.Processor.Distributed is not running or the process(es) can not be accessed." | Out-file -Width 200 $filePath -Append<br>}<br><br>Simply schedule the above script in the task scheduler with the admin rights on the machine running the affected SQL Server<br><br>STATUS<br>Waiting for fix in future release of ApexSQL Audit<br><br>DEFECT ID<br>204956
ApexSQL Audit performance usage - Testing case using Trace auditing technology (4369130)
Testing that was performed below provides metrics obtained by the usage of ApexSQL Audit and SQL Server within a specific testing environment with no extra processes running except for SQL engine and auditing.
The "Object reference not set to an instance of an object." error is encountered within the ApexSQL Audit log files when trying to pull back auditing information (4373207)
Stack trace<br> ... at ApexSQL.Audit.UI.Shared.Classes.ViewModel.ReportsViewModel.LoadReportPreview() There are 2 steps that needs to be performed in this situation:<br>1. ... Restart the SQL Server instance you are pulling auditing information from<br>2.
How to check events that are being written in the ApexSQL Audit Central for your reports? (4373206)
If there is a suspicion that something is wrong with the SQL auditing reports, what is the simplest way to check if all its events/data is collected the specific query needs to be performed?<br><br><br><br> To check events that are being written in the ApexSQL Audit Central just run the following query in the SSMS and this will ensure the insight into all those events:<br><br>SELECT [Id]<br> ,[ServerName]<br> ,[StartTime]<br> ,[RowVersion]<br> ,[Duration]<br> ,[ApplicationName]<br> ,[ClientHostName]<br> ,[LoginName]<br> ,[DatabaseName]<br> ,[DatabaseId]<br> ,[Success]<br> ,[ObjectId]<br> ,[SchemaName]<br> ,[ObjectName]<br> ,[TransactionId]<br> ,[TextData]<br> ,[Operation]<br> ,[AccessedObjectsList]<br> ,[Error]<br> ,[EventSource]<br> ,[EventTypeId]<br> ,[BeforeValue]<br> ,[AfterValue]<br> ,[ColumnName]<br> ,[SensitiveColumnName]<br> FROM [ApexSQLCrd].[ApexSQL].[EventView]<br> ORDER BY StartTime DESC
List of actions that are performed when Availability Group is added within the ApexSQL Audit GUI (4373205)
What is the list of actions and steps that are performed when an Availability Group is added through the ApexSQL Audit's GUI.? ... Immediately after the name of the Listener is entered/typed within the ApexSQL Audit GUI:
"Remote server forbidden" message is encountered when using the API (4373204)
When using the API calls to generate SQL auditing reports the "Remote server forbidden" message is encountered WORKAROUND<br>Paste the API call link into a web browser on the remote server (while being logged on as the same AD user which generated the API call).<br>The data can then be copied and saved as a .json file<br><br>STATUS<br>Waiting for fix in future release of ApexSQL Audit<br><br>DEFECT ID<br>228961
ApexSQL Audit Remote/Silent Installation (4372771)
There is a known issue with the way the provided credentials in ApexSQL Audit interact with the remote host. ... There are two workarounds are available. ... <h2>Option 1. ... Command line deployment.</h2>
Understanding the changes implemented in ApexSQL Audit 2021.01.2098 hotfix and using it to retrieve quarantined data information (4372321)
ApexSQL Audit 2021.01.2098 hotfix utilizes a more comprehensive quarantine and processing mechanism which may result in an increase in the number of session files contained in the quarantine folder on the audited server as well as the overall count of events inserted into the central repository.
"Log file "Path to .sqlaudit file" cannot be deleted. Last error code from CreateFile is 32" message is logged on SQL Server when there are no problems with the target file (4372169)
The error is logged in SQL Server as false positive, the target file is properly deleted and auditing sessions are working normally but the message is spamming the SQL Server log. ... None
How can I make my custom applications self auditing? (4300924)
How can I make my custom applications self auditing? "<p>SQL developers are increasingly required to include tracking data changes into their custom applications. ... The information about what change was made – insert, update or delete – who made it, when, and also which computer and application was used, is very useful and can be essential for troubleshooting.</p>
SQL Server database trigger auditing – How to customize data tracking and reporting – Part 2 (4288516)
SQL Server database trigger auditing – How to customize data tracking and reporting – Part 2 "<p> Similarly as Watches, the Lookups feature allows the ApexSQL Trigger report to show a meaningful value from a related SQL Server database table, along with the value of the field that was audited.
SQL Server database trigger auditing – How to customize data tracking and reporting – Part 1 (4293064)
SQL Server database trigger auditing – How to customize data tracking and reporting – Part 1 "<p> ApexSQL Trigger uses SQL Server database triggers for capturing and storing changes that occur on the audited data and schema.
How to implement compliance with the PCI DSS regulatory standard for SQL Server - Part 4 (4277159)
Logs and security events for all system components, must be reviewed to identify anomalies or suspicious activity ... The plan and procedures must be capable of responding immediately to a system breach in order to ensure the process of business continuity and recovery, data backup processes, analysis of the all critical SQL Server components
Audit SQL Server database and see who deleted a column value (4228599)
Audit SQL Server database and see who deleted a column value "<p>Every DBA and developer strives to be in control of SQL Servers, databases and data. ... But, sometimes the situation can get out of control and unusual things start happening.</p> <p>For example, you have noticed that a value from a specific table column in your database has been disappearing.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All