Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ServerProtect - Slow SQL Checkpoint

Status
Not open for further replies.
Aug 10, 2005
3
GB
Hi All,

I have one server which when starting SQL the checkpoint pages/sec is around 150 (should be around 10 times this), and the Average Disk Queue Length doesn't climb above 1 (tends to rise to over 100 during a checkpoint).

When the Trend serverProtect service is stopped on this one server, checkpointing returns to around 1500 pages/sec and the average disk queue length is in line with the checkpointing.

I am running version 5.58 Build 1230. I have logged a call with Trend Support, but as always they are taking an age to come back to me, so if anyone knows of a fix for this issue it would be appreicated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top