Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server 2008 memory utilization Expand / Collapse
Posted Thursday, August 19, 2010 9:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 8, 2010 1:47 AM
Points: 6, Visits: 42
We have our application using SQL Server 2008 running on windows 2008 64 bit machine. The application was working fine for some days. Now the client has started reporting that the application hangs after certain transactions and that the cpu utilization of SQL Server 2008 is very high.

After analyzing this problem, we increased the max memory settings, AWE enabled options on that machine. After doing the setting changes, the application worked fine for two weeks. After two weeks the same problem has appeared again. The application has started hanging when the SQL Server cpu utilization is high.

RAM on the machine is 8GB. So we have configured 7 GB of RAM (max server settings) for SQL Server 2008.

Is this known issue wiith SQL Server 2008? Is there any solution to this problem? What can be done to stop my application from hanging?

Thanks in advance

Post #972267
Posted Friday, August 20, 2010 1:58 AM



Group: General Forum Members
Last Login: 2 days ago @ 5:18 AM
Points: 45,619, Visits: 44,147
Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to:

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #972341
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse