SQL Server Audit
E937644
SQL Server Audit is a SQL Server feature that tracks and logs server- and database-level events for security, compliance, and forensic analysis.
All labels observed (1)
| Label | Occurrences |
|---|---|
| SQL Server Audit canonical | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T11656381 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
Target entity: SQL Server Audit Context triple: [SQL Server Authentication, canBeAuditedBy, SQL Server Audit]
-
A.
SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
-
B.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
C.
SQL Server Profiler
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
-
D.
SQL Server Authentication
SQL Server Authentication is a SQL Server login method that uses credentials stored and validated by the database engine itself rather than relying on Windows accounts.
-
E.
SQL Server Agent
SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
Target entity: SQL Server Audit Target entity description: SQL Server Audit is a SQL Server feature that tracks and logs server- and database-level events for security, compliance, and forensic analysis.
-
A.
SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
-
B.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
C.
SQL Server Profiler
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
-
D.
SQL Server Authentication
SQL Server Authentication is a SQL Server login method that uses credentials stored and validated by the database engine itself rather than relying on Windows accounts.
-
E.
SQL Server Agent
SQL Server Agent is a Microsoft SQL Server component that automates administrative tasks such as job scheduling, alerting, and routine maintenance operations.
- F. None of above. chosen
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
ⓘ
auditing mechanism ⓘ |
| configuredWith |
SQL Server Management Studio
NERFINISHED
ⓘ
T-SQL DDL statements ⓘ |
| developedBy | Microsoft ⓘ |
| hasComponent |
Database Audit Specification
NERFINISHED
ⓘ
SQL Server Audit object ⓘ Server Audit Specification NERFINISHED ⓘ |
| introducedInVersion | SQL Server 2008 NERFINISHED ⓘ |
| partOf | Microsoft SQL Server NERFINISHED ⓘ |
| provides |
audit event metadata
ⓘ
centralized audit configuration ⓘ tamper-evident audit trail ⓘ time-stamped audit records ⓘ |
| relatedTo |
Extended Events
NERFINISHED
ⓘ
SQL Trace NERFINISHED ⓘ |
| replaced | many SQL Trace auditing scenarios ⓘ |
| supports |
asynchronous logging
ⓘ
audit action groups ⓘ database-scoped audits ⓘ failure-only auditing ⓘ filtering of audit events ⓘ fine-grained event selection ⓘ grouping of audit actions ⓘ server-scoped audits ⓘ success-and-failure auditing ⓘ synchronous logging ⓘ user-defined audit events ⓘ |
| supportsLevel |
database-level auditing
ⓘ
server-level auditing ⓘ |
| tracks |
data access events
ⓘ
database configuration changes ⓘ database-level events ⓘ failed login attempts ⓘ login events ⓘ permission changes ⓘ role membership changes ⓘ schema changes ⓘ server configuration changes ⓘ server-level events ⓘ successful login attempts ⓘ |
| usedFor |
access tracking
ⓘ
change tracking ⓘ forensic analysis ⓘ regulatory compliance ⓘ security monitoring ⓘ |
| writesTo |
Windows Application log
ⓘ
Windows Security log NERFINISHED ⓘ binary log file ⓘ file target ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Subject: SQL Server Audit Description of subject: SQL Server Audit is a SQL Server feature that tracks and logs server- and database-level events for security, compliance, and forensic analysis.
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.