Errorlog Summary Detail (PD_ES)
- Organization of this page
Function
The Errorlog Summary Detail (PD_ES) record indicates a summary of the errors that occurred in Microsoft SQL Server. Only one record is created.
If the OS is Windows in Japanese, English or Chinese environment, strings whose meaning correspond to Error in each language are collected. This record is not supported by Windows in other language environments.
This record collects the total number of errors that were output to the Microsoft SQL Server error log. Note that this record counts all errors, even if the number of Microsoft SQL Server errors output exceeds the value set for the instance information item LIMIT_PD_EE_NUMBER.
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
300 |
Y |
|
Collection Offset |
0 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key field
None
Lifetime
From the time the error log file is created until the time it is deleted
Record size
-
Fixed part: 701 bytes
-
Variable part: 0 bytes
Fields
|
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|---|---|---|---|---|---|
|
Errorlog Errors (ERRORLOG_ERRORS) |
Total number of errors recorded in the error log |
-- |
ulong |
No |
Microsoft SQL Server error log |
|
Fatal Errors (FATAL_ERRORS) |
Total number of fatal errors recorded in the error log |
-- |
ulong |
No |
Microsoft SQL Server error log |
|
Internal Errors (INTERNAL_ERRORS) |
Total number of internal errors recorded in the error log |
-- |
ulong |
No |
Microsoft SQL Server error log |
|
Last Error Time (LAST_ERROR) |
Time at which the last error occurred |
-- |
time_t |
No |
Microsoft SQL Server error log |
|
Record Time (RECORD_TIME) |
Interval end time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always ES) |
-- |
char(8) |
No |
Agent Collector |
|
Resource Errors (RESOURCE_ERRORS) |
Total number of resource errors recorded in the error log |
-- |
ulong |
No |
Microsoft SQL Server error log |
|
Start Time (START_TIME) |
Interval start time (GMT format) |
-- |
time_t |
No |
Agent Collector |