November 28, 2002 at 6:29 am
Hi all, I have this monitoring job that looks for locks, I check spids that are blocked and have a waittime > 10000 mil seconds. I'm running it on a Cluster, when I fail over SQL Server to the passive node everything runs fine and performance is the same but there are no waittimes in the sysprocesses table, they are all zero. Even for system processes. I have searched every where and have not come up with anything. The only thing I can think of is there is a flag in the registry on the passive node that has to be set in order for SQL Server to write the waittimes to sysprocesses. Any one have any ideas?
Thanks
December 1, 2002 at 7:53 pm
How does your process work? If a job what ouput does the job give and does it show running. If an outside app what happens if you stop and start the app over?
December 2, 2002 at 10:00 am
Are you sure your process is failing over to the correct master db?
Steve Jones
December 2, 2002 at 10:33 am
quote:
Are you sure your process is failing over to the correct master db?Steve Jones
http://www.sqlservercentral.com/columnists/sjones
Yes it is the correct Master db because I can see all the regular processes that are run on a daily basis. I am no longer checking the waitime > 10000 in my script. I am now checking for blocked spids with DATEADD(MS, -10000, GETDATE()) > last_batch.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply