SQL 7.0 uses a lot of memory

[123gad]

I'm running Win NT 4.0 and SQL Server 7.0. I have 650 MB RAM, SQL is using as per the task manager about 450 MB of RAM, any idea what I can do, I don;t have much HD space, I have about 4 -5 users on at the same time using SQL 7.0 with the program.
any ideas how I can find out what's going on?
Thanks

 

[kim1]

Hi,

In Properties page of the SQL Server, on Memory tab, you can set the maximum memory that SQL Server is allowed or set it to dynamic.

If you have other applications running on that machine, you might want to give a maximum of memory for SQL Server. If you have no application but SQL Server, it is recommended that you leave it to Dynamic.

If you have a users that write poorly query that takes a lot of time, you can also limit the governer cost so that query will end if it takes to much time to execute, that will leave the SQL Server for other user to work normally.


Kim Kim

 

[123gad]

There is no memory tab in the properties page of SQL 7.0, I'm new to SQL, maybe I don't look at the right place, can you tell me exactly where I would find it.
Thanks

 

[kim1]

In Enterprise Manager, when you registered a SQL Server to the SQL Server Group. Select your SQL Server and right-click on Properties.

Kim Kim

 

[123gad]

Hi,
thanks, it is set to the dynamic settings and to use max. memory, any other ideas, users here are not writing there own queries, it is a software program, (transit software) which runs with SQL.
Thanks again

 

[kim1]

Your transit software is an application that is installed in SQL Server? Any other application is running at the same time on the Server?

Is it possible that is your transit application that take all the resources? You have to give more specifications.

Kim