Vous ne pouvez pas remplir de formulaires sur le site de support pour le moment, pour des raisons de maintenance. Si vous avez besoin d’aide immédiatement, veuillez contacter le support technique. Veuillez nous excuser pour la gêne occasionnée.
ApexSQL Audit performance usage - Testing case using SQL Audit auditing technology
Description
ApexSQL Audit performance usage when using SQL Audit auditing technology
Résolution
DISCLAIMER: The following sample represents an insight of resource utilization during overload cases, insinuated with a huge auditing data processing using ApexSQL Audit. 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 obtained results can be considered as a reference guide in building the expectations on how ApexSQL Audit can impact the given environment.
Testing environment specification
Audited instance machine specification:
OS: Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)
SQL Server version: Microsoft SQL Server 2017 (RTM-GDR) (KB4505224) - 14.0.2027.2 (X64) Jun 15 2019 00:26:19 Developer Edition (64-bit)
Performance testing on the audited instance machine
The following data provides an insight of the testing result in a specific environment and displays overall hardware consumption in specific scenarios, showing the graph results in which a dedicated auditing agent is referred to as ApexSQL Audit processor Distributed, which is a core component for data processing and collecting on the audited instance machines.
Testing case using the SQL Audit auditing technology - low impact on resource utilization Input parameters for testing:
Testing duration: 10 minutes
Auditing technology: SQL Audit
Auditing configuration: GDPR
SQL query average length: 80 chars long
Number of executed SQL events: nearly 237.000 events which stand for 395 transactions per second (TPS)
Test results: Graph below showing CPU utilization during test run with Extended Events auditing technology:
Graph below showing memory utilization during test run with SQL Audit auditing technology: Conducted testing shows low impact on CPU and memory utilization regarding ApexSQL Audit Distributed processor when test SQL query was executed simultaneously from 1 application within 10 minutes. Workload during test run per total SQL Server resources (test SQL query vs ApexSQL Audit SQL query): Comparison of applications that executed SQL queries during test run per total SQL Server resources:
Testing case using the SQL Audit auditing technology - high impact on resource utilization
Input parameters for testing:
Testing duration: 6 minutes
Auditing technology: SQL Audit
Auditing configuration: GDPR
SQL query average length: 80 chars long
Number of executed SQL events: nearly 799.000 events which stand for 2.219 transactions per second (TPS)
Test results: Graph below showing CPU utilization during test run with SQL Audit auditing technology: Graph below showing memory utilization during test run with SQL Audit auditing technology: Conducted testing shows low impact on CPU and memory utilization regarding ApexSQL Audit Distributed processor when test SQL query was executed simultaneously from 6 applicatios within 6 minutes. Workload during test run per total SQL Server resources (test SQL query vs ApexSQL Audit SQL query): Comparison of applications that executed SQL queries during test run per total SQL Server resources:
Network utilization During the execution of these tests, due to a large amount of processed audited data, it was expected to find increased network bandwidth utilization. This utilization is the result of transferring audited data packages from the audited instance to the central repository. Our tests have shown 2.5 – 3.5 Gbps bandwidth utilization:
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Contenu recommandé
Produit(s) :
ApexSQL Audit
2021.01
Sujet(s) :
Best Practices
Historique de l’article :
Créé le : 10/18/2022 Dernière mise à jour le : 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Bienvenue dans le support
Vous trouverez le support en ligne correspondant à Quest *produit* sur les sites d’assistance affiliés. Cliquez sur Continuer pour être dirigé vers l’assistance et le contenu correspondant à *produit*.
Les versions 8, 9, et 10 d’Internet Explorer ne sont plus prises en charge.
Le portail Quest Software ne prend plus en charge Internet Explorer 8, 9 et 10. Il est recommandé de mettre à niveau votre navigateur vers la version la plus récente d’Internet Explorer ou de Chrome.
Mise à niveau vers Internet Explorer 11 Cliquez ici
Si vous continuez à utiliser Internet Explorer 8, 9 ou 10, vous ne serez pas en mesure d’exploiter pleinement les excellentes fonctionnalités en libre-service que nous proposons.