SQL Server 2012

  1. Number of pages allocated per second from mixed extents. These could be used for storing the IAM pages and the first eight ...
  2. Number of pages allocated per second in all databases in this SQL Server instance. These include pages allocations from both ...
  3. Number of pages deallocated per second in all databases in this SQL Server instance. These include pages from mixed extents ...
  4. Number of pages fetched per second by free space scans. These scans search for free space within pages already allocated ...
  5. Number of plan executions per second in which a plan guide could not be honored during plan generation. The plan guide was ...
  6. Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly. ...
  7. Number of rows estimated by the Query Optimizer for this operator, divided by the actual degree of parallelism (number of ...
  8. Number of scans per second that were initiated to search for free space within pages already allocated to an allocation unit ...
  9. Number of shrink notifications the server issued in the last second. Indicates how often the server believes it is under ...
  10. Number of shrink notifications the server issued in the last second. Indicates how often the server believes it is under ...
  11. Number of threads used by parallel queries in the workload group. Serial queries and the main thread of parallel queries ...
  12. Number of times a leaf page cookie was used successfully during an index search since no change happened on the leaf page. ...
  13. Number of times a tree page cookie was used successfully during an index search since no change happened on the parent page ...
  14. Number of times this event has already fired for the same query and operator. Larger values will mean more significant cardinality ...
  15. Number of transactions which wrote to the mirrored database in the last second, that waited for log to be sent to the mirror. ...
  16. Number of work files created per second. For example, work files could be used to store temporary results for hash joins ...
  17. Number of work tables created per second. For example, work tables could be used to store temporary results for query spool, ...
  18. NumericPrecision descriptor in the descriptor file on path {0} is invalid. The schema table does not contain a column with ...
  19. NumericScale descriptor in the descriptor file on path {0} is invalid. The schema table does not contain a column with the ...
  20. numeric_expression - Is an expression of the exact numeric or approximate numeric data type category, except for the bit ...
  21. Object '%1!s!' is of a data type that is not supported by the CHANGETABLE function. The object must be a user-defined table. ...
  22. Object '{0}' does not have a partition scheme. You must specify a partition scheme before you can add a PhysicalPartition ...
  23. Object ID %1!s! (object "%2!s!"): Computed columns and CLR types cannot be checked for this object because the common language ...
  24. Object ID %1!s! (object '%2!s!'): A deadlock occurred while trying to lock this object for checking. This object has been ...
  25. Object ID %1!s! (object '%2!s!'): DBCC could not obtain a lock on this object because the lock request timeout period was ...
  26. Object ID %1!s!, forwarded row page %2!s!, slot %3!s! should be pointed to by forwarding row page %4!s!, slot %5!s!. Did ...
  27. Object ID %1!s!, forwarding row page %2!s!, slot %3!s! points to page %4!s!, slot %5!s!. Did not encounter forwarded row. ...
  28. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!) , page ID %6!s!, row ID %7!s!. Column ...
  29. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!), data extents %6!s!, pages %7!s!, mixed ...
  30. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!), index extents %6!s!, pages %7!s!, ...
  31. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!), page %6!s!, row %7!s!: Row contains ...
  32. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!): At least one record on page %6!s! ...
  33. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!): Errors found in off-row data with ...
  34. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!): Page %6!s! could not be processed. ...
  35. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!): The ghosted record count in the header ...
  36. Object ID %1!s!, index ID %2!s!, partition ID %3!s!, alloc unit ID %4!s! (type %5!s!): The record count in the header (%6!s!) ...
  37. Object of type '{0}' does not implement the expected component editor interface. Verify that the component editor is installed ...
  38. Object specified in a client request is not an aggregation design object. Only aggregation design objects are allowed for ...
  39. Objects exposing CLR type columns are not allowed in distributed queries. Use a pass-through query to access the remote object ...
  40. Objects exposing columns with CLR types are not allowed in distributed queries. Please use a pass-through query to access ...
  41. Objects highlighted in bold have been renamed to avoid name conflicts with existing local objects. Review the imported calculations, ...
  42. Occurs after a SQL statement is compiled. This event returns an XML representation of the estimated query plan that is generated ...
  43. Occurs after a SQL statement is compiled. This event returns an XML representation of the estimated query plan that is generated ...
  44. Occurs after a SQL statement is executed. This event returns an XML representation of the actual query plan. Using this event ...
  45. Occurs during an online index build process to indicate the progress of the build operation. Each stage of an online index ...
  46. Occurs during updating secondary's recovery forks stack. After deleting extra entries in the secondary stack but before copying ...
  47. Occurs during updating secondary's recovery forks stack. After updating the stack but before saving the recovery LSN in the ...
  48. Occurs every month on day {DayOfMonth} every {TimeInterval} {TimeIntervalUnit} between {StartTimeOfDay} and {EndTimeOfDay} ...
  49. Occurs every time that SQL Server executes a SELECT, INSERT, UPDATE, or DELETE statement. Use this event to monitor if a ...
  50. Occurs every {Frequency} month(s) on day {DayOfMonth} of that month every {TimeInterval} {TimeIntervalUnit} between {StartTimeOfDay} ...
  51. Occurs every {Frequency} week(s) on {DayOfWeekList} every {TimeInterval} {TimeIntervalUnit} between {StartTimeOfDay} and ...
  52. Occurs every {WeekOfMonth} {DayOfWeek} of every {Frequency} month(s) every {TimeInterval} {TimeIntervalUnit} between {StartTimeOfDay} ...
  53. Occurs every {WeekOfMonth} {DaysOfWeek} of every {Frequency} month(s) every {TimeInterval} {TimeIntervalUnit} between {StartTimeOfDay} ...
  54. Occurs for all statements that check for the ALTER TRACE permission. Statements that check for ALTER TRACE include those ...
  55. Occurs immediately before QVM context is serialized and shipped, and immediately after it is received and deserialized. Use ...
  56. Occurs immediately before QVM context is serialized and written back, and immediately after it is received and deserialized. ...
  57. Occurs on classifying current memory consuming remote exchange operator consumes relative small amount of memory, then will ...
  58. Occurs simultaneously with the Lock:Deadlock event class. The Deadlock Graph event class provides an XML description of the ...
  59. Occurs when a background job has terminated abnormally. This condition may require the attention of a system administrator. ...
  60. Occurs when a BEGIN TRANSACTION request that was sent from a client application through the transaction management interface ...
  61. Occurs when a BEGIN TRANSACTION request that was sent from a client application through the transaction management interface ...
  62. Occurs when a COMMIT TRANSACTION request that was sent from a client application through the transaction management interface ...
  63. Occurs when a COMMIT TRANSACTION request that was sent from a client application through the transaction management interface ...
  64. Occurs when a connection is made to an OLE DB provider. This event collects properties from the remote provider from several ...
  65. Occurs when a cursor is converted to a different cursor type because the requested cursor does not support the statement ...
  66. Occurs when a distributed query is run and collects information corresponding to the provider connection. This event class ...
  67. Occurs when a DML operation that is intended to overwrite only part of a large column value is forced to rewrite the entire ...
  68. Occurs when a fine-grain lock is converted into a coarser-grain lock, such as when a row lock is converted into an object ...
  69. Occurs when a lock is acquired on an object. Use this event to troubleshoot data contention issues that are caused by locks ...
  70. Occurs when a lock on an object has been released. Use this troubleshoot data contention issues that are caused by locks ...
  71. Occurs when a page is added to the suspect_pages table in the msdb database. This event is issued asynchronously from the ...
  72. Occurs when a plan is created for a query or batch that includes a plan guide. Use this event to determine when plan guides ...
  73. Occurs when a PROMOTE TRANSACTION request that was sent from a client application through the transaction management interface ...
  74. Occurs when a PROMOTE TRANSACTION request that was sent from a client application through the transaction management interface ...
  75. Occurs when a query accesses a column that does not have statistics available that could have been useful for query optimization. ...