This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I would you like to know if there is a page describing the exact SQL SERVER and Agent log structure.
For what I see below... there are only 4 fields, is it true?
Is there an explicit field to understand the type of message (info, warning, error)?
I usually read these infos in the text (especially for the error).
THANK YOU
Alen
The information is the same as you see in the SQL Server errorlog, which I assume that you are familiar with. The entry in the Windows event log has one additional entry, which tells you that the message comes from, yes, the SQL Server errorlog.
Else there is a date, and the spid that reported the error. Here it says spid13s. I assume s stands for "system process".
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 77%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
This error message is telling you that your sql server is under memory pressure and thus its paging out to virtual memory on disk and thus your queries will perform slower.
You can read this information by executing sp_readerrorlog procedure in ssms new query window.
You need to go and check the server max memory for this sql server and total memory in OS and allocate it accordingly or add more or fix the queries which are taking up all the memory.
maybe I explained myself wrong ... it is not necessary to clarify the type of error ... but my question was about the log trace, if there is a page that I can describe or I am based on the 4 fields that I have exposed.
You can find the info about errors from sys.messages
SELECT message_id AS Error, severity AS Severity, [Event Logged] = CASE is_event_logged WHEN 0 THEN 'No' ELSE 'Yes' END, [text] AS [Description] FROM sys.messages WHERE language_id = 1040 /* replace 1040 with the desired language ID, such as 1033 for US English*/ ORDER BY message_id;
And there is also a list here : Link
These errors are logged in sql server and sql agent log and then read from there using procedures to create a view and result set is thus displayed
You can do sp_helptext 'sp_readerrorlog'
to see the code in that storedprocedure that sql server use to do that for you in the background.
Hi @Alen Cappelletti ,
As Shivam already mentioned, your SQL Server seems to be under pressure.
You should check the configuration of your SQL Server, mostly it it the max memory setting (Instance properties -> memory -> max memory which is still on default or set to a too high value.
Normally it should be set to something like 10% RAM for OS and 90% RAM for SQL (if there is only a DBEngine running without any other apps)
And you can find more information about your "error" here:
mssqlserver-17890-database-engine-error
Thanks for your reply, but maybe I explained myself wrong ... it is not necessary to clarify the type of error (it's clear to me... but it's my LAB : ) )... but my question was about the log definition format, if there is a page that I can describe or I am based on the 4 fields that I have exposed.
ALEN
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Alen Cappelletti ,
Welcome to Microsoft Q&A!
You should be more concerned about the message of the error log. Of course, the date is also something to be concerned about.
In addition, please refer to this document about Monitor and Troubleshoot Memory Usage
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.