September 3, 2008 at 12:45 pm
I got a confirmation from our sysadmin, Hyper-threading was not enabling.
We have 4x4quad CPUs on that box. I am seeing 16 CPUs, this mean HT is not enabled.
Should I tried to set the affinities?
Rem
September 4, 2008 at 12:14 am
Rem,
I would leave the affinity default.
Gail,
Thanks for the bol ref.
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 4, 2008 at 7:57 am
The hardware has 8 CPU (Hyper-Threading). CPUs 0 to 5 are Processors Affinity while 6 to 15 are I/O Affinity (because I was seeing entry like this on e in the log "The time stamp counter of CPU on scheduler id 14 is not synchronized with other CPUs")
You should almost certainly set both affinities back to default. You are getting that timing message because SQL server later versions now log when the clock CPU speeds are different when a thread goes back and forth (or even on the same CPU sometimes). This freq change is due to power conserving stuff built into the newer chips. you should disable this by setting the power savings stuff to Always On. Search the web for further info.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 4, 2008 at 8:16 am
Power Schemes is actually set to "Always On". Not sure what to do next.
Thanks.
September 4, 2008 at 8:20 am
Please note the original post!!!
"
Since a few weeks, our SQL server (2005 64 bits Standard Edition running on Windows 2003 DataCenter) has some issues performance wise. A few times a weeks the dataserver become very slow even unresponsive. I found in the event log the following entry:
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 14419 seconds. Working set (KB): 47888, committed (KB): 161528, memory utilization: 29%%.
Since we are using the standard edition, we can’t use the Lock pages in memory user right. I have no idea what to do next. Can someone has a good workaround?
"
I have change the memory setting to Min & Max memory with different number, and I am still getting the same error. Any more idea of what I should try to do to avoid this problem. Each time I need to reboot SQL Server because the server is unresponsive.
Rem
September 4, 2008 at 8:35 am
I suggest you contact PSS. There are quite a number of bugs that can cause this (the Broadcom adapter one mentioned in the linked article, HP iLO driver, Windows large-file-copy bug, and almost certainly others). PSS can help you quickly determine if you may have any of these.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
September 4, 2008 at 8:42 am
I could see HT causing cache thrashing during heavy usage. Or just lock SQL server to only work with the first half-set of CPU's listed in taskman, as physical CPUs are listed first.
September 4, 2008 at 11:45 pm
Did you try DavidBs workaround ?
What were the results ?
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 5, 2008 at 3:32 am
Did you read and apply the hotfixes mentioned in KB918483 http://support.microsoft.com/kb/918483
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 5, 2008 at 6:39 am
I am not sure which one to try first. Any hints?
September 5, 2008 at 7:03 am
Rem (9/5/2008)
I am not sure which one to try first. Any hints?
Yes: call PSS and pay them the $275 or whatever it is. Had you done this yesterday or the day before when this first hit I am betting your server would be running fine now. How many more hours/days are you going to hunt-and-peck on this forum while you continue to have an unresponsive server?? Makes no sense to me.:blink:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 11 posts - 16 through 26 (of 26 total)
You must be logged in to reply to this topic. Login to reply