|
Comments
|
|
Okay. The topic is huge. Quite a few things left out...
|
|
Brian Savoie on
10/28/2009
I really dig this site! I really look forward to these emails every day!
|
|
|
This is very helpful as I am working to better understand how logs in SQL Server can help me.
|
|
|
It would be nice to run a troubleshooting series based on the error logs.
|
|
Bruce Bealer on
10/28/2009
Screen too small
|
|
|
learned: sp_cycle_errorlog
|
|
|
Great and concise explanation of sp_cycle_errorlog. Looks like a candidate for a sql server job. Thank you.
|
|
|
Never heard of sp_cycle_errorlog before; cool!!
|
|
|
is the any advantage in clearing the logs daily, or some other regular interval
|
|
Andy Warren on
10/29/2009
The main advantage is keeping the size manageable. Depending on your server you might cycle them daily, weekly, or monthly. It's not the end of the world if you don't, the worst that happens is that it takes a while(!) for it to load when you view it.
|
|
Steve Harris on
10/30/2009
perhaps talk about what would be bad to see in the logs
additionally, maybe discuss how to use sp_cycle_errorlog (the parameters and such)
|
|
|
Thanks. I'm just starting to learn about server logs, so this was very timely.
|
|
|
Another winner! Very useful information.
|
|
Steve Culshaw on
11/6/2009
Nice overview
|
|
|
If there is not a best practice for doing this is there a concenses as to how best determine the cycle perion and set it up as a scheduled task?
|
|
Mark Holahan on
12/3/2009
Nice overview. A good sequel would be a discussion on the types of errors you may encounter in the log.
|
|
|
Good
|