Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL ERROR LOG Expand / Collapse
Author
Message
Posted Tuesday, November 24, 2009 8:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 03, 2014 1:59 PM
Points: 41, Visits: 295

Hi,

can anyone know where the sql server stores the sql error log configuration settings info.

we want to monitor the sql error log settings so is it possible to monitor them.

By default the value is between 6-99 error logs we can have... how can we monitor them and where does it store the config setting information in like(sys table,registry etc)..

can anyone help me with this...

Thanks in advance
Post #824272
Posted Tuesday, November 24, 2009 9:30 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947
HVPR (11/24/2009)

can anyone know where the sql server stores the sql error log configuration settings info.

There is SQL Server error log, not aware of "sql error log configuration settings info"

Find the article below, would that help your case?

Working with SQL Server Error Logs


we want to monitor the sql error log settings so is it possible to monitor them.

By default the value is between 6-99 error logs we can have... how can we monitor them and where does it store the config setting information in like(sys table,registry etc)..


Would you like to view the error logs or view the settings? Either case, in the object explorer, under Management Node, on SQL Server Logs right click and select Configure or select View to view the Error logs.

UPDATE: Updated the link to the blog post



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #824286
Posted Tuesday, November 24, 2009 9:45 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 03, 2014 1:59 PM
Points: 41, Visits: 295

Hi Bru,

Thanks for the reply...

Ya I know where to look at log files but we are implementing some standards at server level.

so we are looking to write a script to monitor the sql error log setting.

if sql server error log is configured to store 6 or 20 or 30 logs..where does this info store in the system
(system table,registry etc) it should somewhere store the details right.so that we can write a script to go and get the error logs value on each server.
Post #824290
Posted Tuesday, November 24, 2009 10:24 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947
This should solve..

USE [master]
GO
EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs'
GO




Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #824300
Posted Tuesday, November 24, 2009 10:26 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947
This should solve..

USE [master]
GO
EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs'
GO




Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #824301
Posted Thursday, November 26, 2009 1:26 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 03, 2014 1:59 PM
Points: 41, Visits: 295
Thanks Bru,


It was very helpful to me..for getting the default value made a small change.

declare @NumErrorLogs int
exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'NumErrorLogs', @NumErrorLogs OUTPUT
print @NumErrorLogs


Thanks.......

Post #825345
Posted Thursday, November 26, 2009 10:52 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 23, 2013 10:41 PM
Points: 310, Visits: 649
Better use GUI instead of this query.

  Post Attachments 
ErrorLogConfig.bmp (33 views, 736.15 KB)
Post #825454
Posted Friday, November 27, 2009 5:36 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947
luckysql.kinda (11/26/2009)
Better use GUI instead of this query.

Have you read the Original Post ?

The OP wanted to monitor through script on all Server. OP has mentioned about seeing in GUI.

I had already written an article on SQL Server Error Log in my site found in my signature. I know it is can be seen in SSMS (GUI).



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #825571
Posted Friday, November 27, 2009 12:45 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 1:28 PM
Points: 1,141, Visits: 326
Right Click SQL Server Agent in SSMS and select Properties.
Post #825728
Posted Friday, November 27, 2009 12:54 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947
cathy.baker (11/27/2009)
Right Click SQL Server Agent in SSMS and select Properties.


For what?



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #825735
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse