Log File Viewer

Question

Log File Viewer

BigSam

SSCrazy

Points: 2146
More actions
December 8, 2008 at 9:16 am

#198547

Is there a way to 'Filter' the Log File Viewer or stop loading the events, before it displays everything under the sun?

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

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

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 1

You do have quite limit scope to filter events. For example, you can modify security audit levels from an instance properties and configure SQL Server Agent Error Logs.

My understanding is the logs are used for sa. System administrators need all information on the activities of database servers. Although an sa can filter his display, but all activities need to be saved.

BigSam SSCrazy Points: 2146 More actions · Answer 2

When I open the viewer I have to wait 4-5 minutes before I can engage any filtering. What I'd like to do is stop the viewer from loading, so that I can can at least set the date range in the filter.

Yes, sometimes I need to see everything, but not always.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

I generally find it much easier and faster to open the error log in a good text editor (ultraedit, notepad++, etc)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 4

Could these text editor be used to open current log file?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Sure. That's how I used to always read my log files.

Open in ultra edit and set the editor to reload changes any time it got focus.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

BigSam SSCrazy Points: 2146 More actions · Answer 6

I'm not familiar with Ultra Edit, but will give it a look over. I'm more familiar with PSPad & NotePad+ - don't know why I didn't think of these.

Thanks

Sam

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Ultraedit's not free. If you're happy with the other text editors, use those

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass