Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

SQL Server 2005 Memory Pressure

Avatar of qisadmin
qisadmin asked on
Microsoft SQL Server 2005
4 Comments1 Solution699 ViewsLast Modified:
I believe my SQL 2005 server may be experiencing memory pressure.  Users are experiencing hour glass waits on numberous occasions.  I have been running performance couters for some time now and see absolutly nothing in reqard to hardware.  CPU is under 30% 90% of the time, there is always at least 10Gig of memory available during peak times and the disk activity is pretty low when it comes to queue lenghts.  I have been using the performance dashboard for a period of time as well to watch SQL and when the users report these delays i see alot of wait alerts.  They are all over the place when it comes to type but they have been several seconds in lenght and one after the other.  My perfmons are monitoring some SQL counters and the only one that seems to stand out is the \SQLServer:Buffer Manager\Page life expectancy.  I have read that this should never go below 300.  When these delays happen they go as low as 1 and are usually always below 300 during this time.  SQL is set to the default min and max memory settings but i never see SQL use more than 1.7gig.  I have not watched this concistenly but it never seems to change.  My knowledge of SQL is limited so i have been relying on whatever i can find for recommendations online right now to point me in a direction to monitor to try and understand why things are so slow with a box that seems to have way more than enough horse power behind it to keep up with SQL.
ASKER CERTIFIED SOLUTION
Avatar of hp8165809
hp8165809

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers