July 1, 2009 at 7:44 am
Has anyone seen an increase in the SQL waits after installing SP3? We have had the I/O increase and the writelog waits increase around 4 times what is was before SP3 was installed. Has anyone experienced this or have any ideas how to address this issue?
July 1, 2009 at 7:44 pm
I haven't installed SP3 yet, but I don't have a work situation to look at so my personal machine would be a lousy place to find that kind of problem. However, one thing I can think of from a purely logical perspective would be to look at whether your disk subsystem has any kind of "lazy write" activity. If there's a way to turn that off, it may be a way to at least see if it makes a difference. I don't have the knowledge to know how to go about checking that, and I wish I did, as the logic at least appears sound. Of course, if I'm wrong, please correct me so I can learn from it. Thanks.
Steve
(aka smunson)
:-):-):-)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply