Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Server becomes very slow [RESOURCE_SEMAPHORE] waittype. Expand / Collapse
Author
Message
Posted Wednesday, September 19, 2012 1:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 14, 2012 1:02 AM
Points: 3, Visits: 49
We had the same issue. Initially we did not think it was memory bottlenecks since cache hit ratio was around 100. But we increased the server memory and the issues went away for now.
Post #1361580
Posted Wednesday, September 19, 2012 5:14 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
andyansryan (9/19/2012)
We had the same issue. Initially we did not think it was memory bottlenecks since cache hit ratio was around 100. But we increased the server memory and the issues went away for now.


Page life expectancy, along with memory stalls per sec and lazy writes per sec, is a more reliable indicator of memory pressure than cache-hit ratio. Should be over 1000-2000 sec, depending on server memory.


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1361693
Posted Thursday, September 20, 2012 3:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 3, 2014 11:14 AM
Points: 3, Visits: 84
Hi

Did you try installing SP4 for 2005 . See if that can help.
Post #1362336
Posted Thursday, September 20, 2012 3:22 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:44 AM
Points: 4,400, Visits: 6,260
Please don't post to 2 year old threads.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1362346
Posted Monday, January 21, 2013 12:26 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 16, 2014 8:24 AM
Points: 258, Visits: 1,099
TheSQLGuru (9/20/2012)
Please don't post to 2 year old threads.


Why not? If the information people post is useful, what does the age of the thread have to do with anything?

When I search for information on this website, I search on keywords, irrespective of the date the information was posted.
Post #1409676
Posted Tuesday, June 11, 2013 1:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 6:58 AM
Points: 26, Visits: 513
Hi ,

Last week we increased RAM and processors. now ,In our environment we have 2 processors,6 cores and hyper threading present ,so a total of 24 processors (6*2*2) available with 48GB RAM. I gave 28gb for sql as max server memory. in event viewer after a day i got insufficient memory to run the query. There are lot of blockings so that application gets hanged and nothing is working fine. Could anyone suggest me in which aspect i should check the performance of sql.

Now i have increased as 38 gb out of total of 48 gb for sql server.

Server:sql server 2012 enterprise
OS:Windows server 2012 standard

In our applications we have long running threads with many joins ,but before there was no issues like blocking as of now.....Need to resolve blockings and run apps fastly . Any one please help me !!!!
Post #1462360
Posted Tuesday, June 11, 2013 2:11 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 20,734, Visits: 32,500
vishalsurya50 (6/11/2013)
Hi ,

Last week we increased RAM and processors. now ,In our environment we have 2 processors,6 cores and hyper threading present ,so a total of 24 processors (6*2*2) available with 48GB RAM. I gave 28gb for sql as max server memory. in event viewer after a day i got insufficient memory to run the query. There are lot of blockings so that application gets hanged and nothing is working fine. Could anyone suggest me in which aspect i should check the performance of sql.

Now i have increased as 38 gb out of total of 48 gb for sql server.

Server:sql server 2012 enterprise
OS:Windows server 2012 standard

In our applications we have long running threads with many joins ,but before there was no issues like blocking as of now.....Need to resolve blockings and run apps fastly . Any one please help me !!!!


Duplicate post. Please post any responses here.

Please don't make multiple posts. It will simply fragment any responses you may get regarding your problem.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1462371
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse