A short Tidbit about a DMV that I came across today.
When,troubleshooting any issue related to SQL Server, one of the first things we ask the customer is the SQL Server ErrorLog. Many times, we get the question, where is it located?
There are several ways to determine the path of the ErrorLog.
My fellow Microsoft colleague Balmukund has a blog post explaining the various ways to find the path of the ErrorLog.
Apart from the above described methods, One other way, that we could get the path of the ErrorLog in SQL Server 2012,when the SQL Server service is running is through this DMV.
Executing this DMV will give valuable information about the Errorlog like
Hope this helps!!