What are the best alerts to set up on a SQL server?

  • Geoff A (4/24/2012)


    opc.three (4/24/2012)


    Geoff A (4/24/2012)


    if you have a high use server with multiple databases in full backup mode with trans logs getting backed up alot, and you do not rotate the logs often, reading the SQL log can be tough on a system. that log does not rotate on its own. only on reboots, restarts and running the following command.

    EXEC sp_cycle_errorlog ;

    Have you seen Trace Flag 3226? If you do not have much need for the log backup entry it can keep your logs tidy.

    i have not and i thank you!

    You're welcome!

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Just want to say a thank you to you all for replying to my post and giving some good advice, I'll be setting those alerts up very soon.

    Regards,

    D.

Viewing 2 posts - 16 through 17 (of 17 total)

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