SQL EATING MY MEMORY 2

[Steelmach]

I am running a SQL app (ecm) and a4w on pervasive. I am running W2000 TS with 4GB RAM. SQL grabs all mem and forces server to look for more VM. Mem therefore running at 80-90% constantly. IS this normal or how can I control the memory better for SQL.

 

[ettienne]

Put SQL on a diet, go to Enterprise Manager, right-click the SQL server and select Properties and go to the Memory tab.
SQL server is pretty memory hungry, what else are you running on the server?
Ideally the server should be dedicated to SQL server.

 

[jayconverse]

There's a little confusion here. Are you running MS-SQL or Pervasive.SQL? If the former, then the memory usage is automatic, and you don't have to worry about it. If the latter, then go to the Pervasive Control Center, and reduce the maximum cache size.

Jay Converse
IT Director
Systemlink, Inc.

 

[Steelmach]

Thanks Guys, I am running eCRM on SQL and ACCPAC ver 5.0a on Pervasive, using TS on Win 2000. On my server SQL using 1.5GB RAM and Pervasive 0.5GB. IS there a memory release using these products on W2000.

 

[jayconverse]

No, there's no "memory release". Just reduce the Pervasive Cache if you want more free RAM. Leave MS-SQL alone, it's dynamic.

Jay Converse
IT Director
Systemlink, Inc.

 

[Relloc]

It all depends on if you running CRM on your SQL box.

http://www.sql-server-erformance.com/sql_server_configuration_settings.asp

We had more or less the same problem and fixed it by setting the Maximum (MB) on MS-SQL Server

 

[ettienne]

http://www.sql-server-performance.com/sql_server_configuration_settings.asp