Server becomes very slow [RESOURCE

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Server becomes very slow [RESOURCE_SEMAPHORE]...

35 posts, Page 4 of 4

«««1 2 3 4

Server becomes very slow [RESOURCE_SEMAPHORE] waittype.

Rate Topic

Display Mode

Topic Options

Author

Message

andyansryan

Posted Wednesday, September 19, 2012 1:07 PM

Forum 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

Marios Philippopoulos

Posted Wednesday, September 19, 2012 5:14 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:10 AM
Points: 1,824, Visits: 3,477

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 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

himanshu827 21014

Posted Thursday, September 20, 2012 3:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 3, Visits: 79

Hi

Did you try installing SP4 for 2005 . See if that can help.

Post #1362336

TheSQLGuru

Posted Thursday, September 20, 2012 3:22 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 3,578, Visits: 5,119

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

Gail Wanabee

Posted Monday, January 21, 2013 12:26 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:26 PM
Points: 254, Visits: 1,029

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

« Prev Topic | Next Topic »

35 posts, Page 4 of 4

«««1 2 3 4

Permissions