SQL 7 (memory usage)

[GenTrac]

We have 2 SQL 7 servers. Both of them are very unreliable and seems to crash quite often every 5 about days. I looked at both SQL servers properties in Enterprise Manager and both of them set to use maximum amount of RAM to 1.5Gb. In Windows task manager on both servers they are currently using about 1.2Gb each which seems a lot to me not being a DBA. My question:

1)Will the database become unstable or stop to function when it reach the limit allocated in SQL Server properties maximum RAM usage?
2)Can I restart the SQL server services every night with a scheduler to release the RAM, is this a standard or something that doesn't need to be done?
3)Is it normal for SQL to to creep up in using RAM over a period of time?

Many Thanks

 

[mrdenny]

It is normal for SQL to use up all the memory in the server if it wants to. How much memory do you have in the server?

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[GenTrac]

We have 2Gb of memory in the server..

 

[mrdenny]

You should have plenty of memory in the server.
1) No, things may slow down a little bit if you hit the max amount of ram configured to the SQL Server.
2) You can, but this shouldn't be needed.
3) Yes. As items are used they will be loaded into the memory cache, and kept in RAM for easy referencing.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[camy123]

SQL server is very resource hungrey esp Ram 2Gb of Ram should be enough for any server are there any other application on the server? and also check are there any client application connecting to your server? Bad client design is the biggest problem for SQL server to crash with Ram problems suchas using client side cursors? esp also check fot Contention locks. ,Sql server is dynamic and releases Majority of Ram when not in use.

HOpe this helps.