Post reply

Viewing SQL Server Logs with many records

  • August 7, 2006 at 5:10 am

    #172051

    Is there a better way to view the sql server logs other than the inbuild log viewer (maybe a system view that I could query)?

    My trouble is that the log viewer insits on pulling down all the log records which now number somewhere above 20 million (I got bored around this point and had to kill the process). Thus some way of telling the server to rotate the logs every million records or so would also be helpful.

  • August 7, 2006 at 9:19 am

    #653648

    You can cycle your error log   sp_cycle_errorlog  creates a new log, I normally schedule these just after midnight at a frequency which suits as required, e.g. every sunday, every night.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • August 7, 2006 at 10:19 am

    #653673

    Thats what I was looking for, thanks.

  • August 9, 2006 at 6:49 am

    #654051

    Still after cycling the errorlog I sometimes have a large errorlog - specielly when audit level is full - and the I use UltraEdit, but any other editor will do the trick. One benefit is that in the editor, it's easy to search in the errorlog.

    /Niels Grove-Rasmussen

  • August 9, 2006 at 11:45 am

    #654152

    I have simply changed ours to audit only failed logins attempts. Why on earth would you want to see every single good login ?  No wonder your logs are so large.

  • August 10, 2006 at 2:22 am

    #654219

    It is only auditing the failed attempts .

  • August 10, 2006 at 4:58 am

    #654257

    It always depends upon what your concept of large is .. when I've enabled deadlocking trace flags I've often ended up with 80Mb logs per day - the easisest way to view these was wordpad, copy the current log first. depends how often you need to view your logs.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply