SQL 2012 - Extended Events->System_health->Watch Live Data Output - Security_error_ring_buffer_recorded Events Query
The log i am seeing is
pretty much i have drilled into
the system_health section of management studio in sql 2012
and chose to
"watch Live Data" and i see these are ticking all the time.
When I click
on one of the Displayed events it shows
Ok i will take a look into that article.
I have traced the errors back to two SQL Logins which are used for our main .net Internal Application Client. THe strange thing is that none of the users which use the Application CLient are experiencing any issues.
Anyways i will continue to look into this and see what I can find - thanks
Ask your .net developers to tell you what the SQL logins are used for. Is it a key part of the application, or just something that polls but never gets used, hence the users not experiencing issues.
Also, double-check your SQL Server is in mixed mode, as this is turned off by default from SQL 2005 onwards I think and a SQL Server restart is required to change the setting.
The logins are not used for anything specific .net code wise but moresor are general use login for day to day application use when connecting to the database.
The sql server is already in mixed mode. Please note that if was not in Mixed mode then there would be SQL Server Error logs indicating that there is a logon error and there isn't.
Like I said, there are no SQL Server Error Log entries for Login type errors which corrolate to the Security_error_ring_buffer_recorded Events.
Also none of the Security_error_ring_buffer_recorded Events corrolate to anything in the SQL Error Log.
The ring buffers are used in situations when losing events is not fatal, and other forms of queue management have bigger problems. This extended events means reading the ring buffer, and recording the information to a log file.
It isn't an error. It is detailed logging telling you what it is doing with the security errors (e.g. failed logins) to make sure they don't get lost. So as you post, none of the Security_error_ring_buffer_recorded Events correlate to anything in the SQL Error Log.
For information about this ring buffers events, you can review the following article.
TechNet Community Support
Thanks for your explanation however I still have some questions
Is it something to be concerned about?
How can I trace to find the source as to this why this detailed Log is being generated?
The fact that these "detailed logs" are getting recorded constantly on the production sql server is of a concern to me given that on our other production sql servers they are not occuring.
Should I be concerned in your opinon?
I will continue to do some research on the "detailed log".
Any thoughts appreciated.