Deprecation
Over the years many commands have been depreciated(means No longer authorised to use),i.e. whenever a newer version is released certain commands may hav been
changed to newer style and would come with a warning that older code might be removed in next release of versions.
One example would be DUMP statement which is used in earlier versions for taking backup,this event class is really useful when you want to migrate to a new version and it can help you in identifying what all codes needs to be changed for migration.
Database
This is a collection of events to monitor automatic changes in the database and log file size changes.
Scans
Reports objects for which Table or Clustered Index scan is performed when a particular query is executed.
Security Audit
This events monitor security.Failed logins,password changes,role changes, and so on,are contained in this category.
No comments:
Post a Comment