October 25, 2010 at 12:16 pm
I see lot of waits waiting on resource_semophore
Usually server performance is commonly running but when this wait comes
there will be almost 10,000 transactions waiting on resource_semophore
I went through lot of articles about this and I came to know it is waits on memory
but I did'nt found the solution .
If some one who come across the same problem tell me what did you do?
October 25, 2010 at 8:07 pm
Memory is the bottle-neck of your system? sure? if so, can solve the problem by adding more memory.
But, i suggest, firstly, giving your system a whole performance tuning, and find the reason why more memory usage.
Maybe, the problem is fixed after tuning some T-SQL, SP or system structure.
Ha-ha, good luck.:-P
October 25, 2010 at 8:10 pm
Is this a new development or has the system been slowly stagnating over time?
If it's a new development, and it's a cluster, force a failover. Let the users work off the other box for a while. Why? You need to determine hardware or software failure if it's a new issue.
If it's a slowly building issue that's been getting worse, it's time for an architectural review of the database and all the procs. See what can be put on a diet. Check for swap file usage, see if it's actually waiting on the swapfile while it's waiting for memory.
EDIT: Sorry, I should have added, the queries you'll be looking to optimize are sorting and hashing queries first to help relieve the pressure.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
October 26, 2010 at 1:19 pm
Hey Guys thanks fo rthe replies but I have one question regarding this
My server min memory and max memory
is set to min---'0'
max---'30GB'
Total Ram is 32 GB
2GB left for OS.
Can I change them to defaults Is that would be a problem or no.
Because OS needs 2GB or atleast 1 Gb.
I think server is now limited to use only 30 GB
So thats the reason it won't use .pagefile
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply