Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Limit the MS SQL 2005 memory usage?

Author  Topic 

dabest_1977
Starting Member

2 Posts

Posted - 2009-12-27 : 21:48:18
Is it safe to limit the memory usage of MS SQL 2005 into a specific (MB)? Currently, we are encountering difficulties with our system. The server has only 4GB system memory. So when the memory usage of MS SQL 2005 reaches 1.60GB, the systems hangs. For in the server, it also has other functions or services running on it. Namely, IIS for our Microsoft Dynamics CRM, Domain controller, acronis backup system.

Hope someone can give us some insights or opinions regarding this issue.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-12-27 : 23:54:42
Yes you can limit it, however you will probably see performance degradation of SQL Server as a result. Any chance you could isolate SQL Server to its own server?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -