June 10, 2004 at 7:50 am
I am running a two node sql 2000 cluster.
Using performance monitor on the primary node; SQLServer: Databases Active transactions is showing a _Total count of 4.29 billion active transactions. Yet under the individual database transactions there should be a total of 0-10 active at any given time. I have failed over to the secondary node and the transactions return to normal 0-10 active. But upon failing back to the primary after a few hours the transactions return to 4.29 billion.
Does anyone know why / what may be causing these miscellaneous transactions or had something similar happen. Is there anything I can do to purge the miscellaneous transactions.
Operating systems - Advanced server with SQL enterprise edition. Service pack 3A ; MDAC 2.8 ;4 2.6 xeon processors , 4 GB ram with pae (memory Extension); 100 GB RAID 5 for sql data ; 100 GB RAID 5 for sql log file; 30 GB quorum drive ; 60 GB temp drive
There are also 4-5 webservers connecting to the cluster using custom applications and 0-200 active users at any given time.
June 14, 2004 at 8:00 am
This was removed by the editor as SPAM
June 14, 2004 at 10:22 am
maye use CHECKPOINT.
BOL says:
Forces all dirty pages for the current database to be written to disk. Dirty pages are data or log pages modified after entered into the buffer cache, but the modifications have not yet been written to disk.
Max
June 14, 2004 at 12:53 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply