Derric, sorry for the late reply I forgot checking this forum topic. The queue length is occuring on the RAID 10 drive where the data resides (not...
Ok, Thanks all for your input. I now understand the process what is causing our I/O problem and will go out for some more disks.
Is there a possibility to reduce the dirty pages? I found one update statement that executes reguraly (more than 100 times in 5 min.) that results in...
No we don't have bulk inserts regulary and also no long running transactions. Al inserts and updates affects basically one row per...
The checkpoint does cause meaningful performance degradation. The database is used for an active website. During the checkpoint the site is hardly...
At the moment the number of writes/sec is mostly between 200 and 300 when the queue length goes to 200. If I understand you correct and 4 disks...
Today I had the change to double check the configuration. It appeared that the recovery interval was set to 5 without my knowledge. This explains the...
I have monitored the counter SQLServer:Buffer ManagerCheckpoint pages/sec. This value is continously 0 till the problem arises. Then the value is...
Gurucb, When the queue length is this high, the process who is causing it is sqlsrv. The Disk writes/sec are at that moment much higher than normal...
Thanks. Does this mean you think the database checkpoints every +/-20 min? Is this something we can monitor for instance in perfMon?
I'm not familiar with this. We did not change any recovery time so it will probably be automatic configuration. Can you explain how to set the...
We did this for reads, writes, duration and cpu but not yet for recompiles and deadlocks. However the queries in this period were very normal and...
No there is no virusscan software installed on the machine
We run a transaction log backup every 12 hours and a database backup every 24 hours. The transaction log is on a seperate disksystem (RAID1) and the...
autosrink is off. The database file settings are set to automatically grow file and the recovery model to bulk-logged. The database files have plenty...
Hello, We have a strange problem and I can not figure out what is causing it. About every 20 min (sometimes 25 sometimes 15 min) we have a...
No not yet but that is good idea. I will run it on a quiet moment. Thanks for the suggestion
Luis If this was the case, we would no be missing any records but we do! Unfortunately we don't know which (select) statement is causing this so we...
Hi, We have a huge problem. Almost once every day we get the following error: Page (3:104101), slot 11 for text, ntext, or image node does not...
When I create an empty table, I don't have a problem either. In this case the data comes from an existing table on the first db machine. We use the...
Separate names with a comma.
