March 22, 2005 at 4:34 am
Hi all,
I would like to know if any of you have any good tips for monitoring process info and logs in SQL Server 2000. Every day I aimlessly look at the processes running and check the log for anything strange, but I sometimes wonder whether I'm being a bit vague. Does anyone have any tips on the specific things I should be looking for, especially in relation to process info? What is regarded as a very long wait time? What units are IO measured in? What is normal memory usage, what is not?
Please help....
Many many thanks
March 23, 2005 at 2:04 am
Please please does anyone know anything about the above topic. for example today I have a process which has a status of rollback and a wait time of 15. What is the '15' measured in? Is it a long wait time or not? Do I need to do anything with this process? If I could just understand how to interpret this information maybe I would know what to do in these situations. I would be very very grateful of any advice, even the tiniest thing.......
March 23, 2005 at 12:57 pm
Humm can't answer your question directly. But I can offer a couple things to look at and maybe you can get more infor and an answer. First try to get a copy of Veritas "SQL Server Performance Series" boo. It is a PDf offered by Veritas and a great reference for setting and values for performance on SQL 2000. Next go check out the free tools offered by Idera. SQLCheck is one of the free utilities. It is a quick and simple way to look at configured values and check some important counters.
This may not help you at all but ......
Good Luck.
March 23, 2005 at 1:46 pm
If you are looking at the wait time in the Current Activity window in Enterprise Manager, wait time is given in milliseconds. So a wait time of 15 is virtually nothing.
You can get more information about the Current Activity window from Books Online by finding "current activity window" in the index.
As an aside, a rollback is going to take roughly the same amount of time that the initial update took. Now, because a rollback is "undoing" a failed or cancelled update, you need to let it complete, otherwise, you could end up with corrupted data.
Steve
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply