• Ken Simmons (11/26/2008)


    Failed logins are really the most important. It just depends on how busy your system is. It is all preference on what you would like to monitor.

    I use the maintenace database to hold procedures and tables for...

    reindexing, capturing database size for trending, capturing critical events from the error log, etc.

    Jonathan Kehayias did a real good presentation called Automating Common DBA Tasks that has a lot of other good ideas. It can be found under the live meeting recordings here.

    http://www.sqlpass.org/Community/SIGs/DatabaseAdministrationSIG/tabid/80/Default.aspx

    Thank-you Mr. Ken. I'll add that to my articles to read/watch ;-). Thanks again for a important article :D.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].