August 4, 2010 at 9:47 am
Sorry I should have posted both KB articles. We are on AMD also.
August 4, 2010 at 10:00 am
Excellent!!! I will start down a new path and take a look at this HOTFIX.
thanks
August 4, 2010 at 1:59 pm
Looking over the HOTFIX seems to point to the slow server issue I am having. What can be looked at to see that the condition is the server not responding while flushing pages? Is there a perfmon or some other calibration that can be looked at to see this is the case?
thanks
August 5, 2010 at 5:36 am
Well still no luck. I downloaded and applied this HOTFIX and still horrible performance. SP_WHO3 takes 12 to 25 seconds at times to come back when only about 25 users are connected to the server.
Still looking for that bit to turn off or on to get this server moving as advertised.
September 1, 2010 at 12:41 pm
You may want to check this article out. Worked with Microsoft on this one and they are claiming this is a bug with the install. This helped us out initially and improved our perfomance dramatically, but we are still seeing slight performance issues.
September 1, 2010 at 1:05 pm
We applied that KB to our server. We also applied the below fix that was recommended by quite a few post:
http://support.microsoft.com/kb/2265716
We did these late last week and we have seen huge improvements on the server.
Another recommended by Microsoft is KB 982383. We did not see disk I/O as being a problem so we have not applied this yet.
While we did make two changes at once which is not a good idea to figure out which really made the difference our power options were already set for the most part the way Microsoft recommended in the KB.
thanks
September 1, 2010 at 1:22 pm
karmour (9/1/2010)
We applied that KB to our server. We also applied the below fix that was recommended by quite a few post:http://support.microsoft.com/kb/2265716
We did these late last week and we have seen huge improvements on the server.
Another recommended by Microsoft is KB 982383. We did not see disk I/O as being a problem so we have not applied this yet.
While we did make two changes at once which is not a good idea to figure out which really made the difference our power options were already set for the most part the way Microsoft recommended in the KB.
thanks
Thanks for the feedback.
Are these improvements visible in the metrics (stats io, time on, DMV ...) ? ( io/cpu/.../perfmon)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 1, 2010 at 1:32 pm
Yes, you can see improvement on proc execution time, but not really on CPU or resources because that is what this power save option is doing so your CPU will look really good. Check out this article as well, which explains a generic test with these 3 power plan options.
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!3642.entry
September 1, 2010 at 3:16 pm
Overall the server performance is night and day. The power changes I do not think was the change that made the difference. Prior to the patch we applied the server would pause but nothing in PerfMon indicated the pause other than running PerfMon at 1 second interval versus my normal 15 seconds. When using 1 second you could see in PerfMon choppy graphs.
The SQL was very slow and my traces indicated everything SQL was okay but just lots of waits. While the DMV's helped, the waits were not easy to nail down as a operating system issue. All traces indicated a lot of improvement after the patch. All items that started to show on the trace because of slow duration stopped appearing. The benchmark I had from the previous server helped to identify that these queries should not be showing up.
This was a major pain tracking this down. Now that it is running "Great" I hesitate to try any more paches until the SP has been fully tested.
September 2, 2010 at 3:08 am
Thank you for sharing your findings and observations.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 10 posts - 16 through 24 (of 24 total)
You must be logged in to reply to this topic. Login to reply