asked on

MS SQL Server possible memory leak

Got a problem with SQL Server process (sqlservr) slowing eating up memory (running SBS 2003).

On the 4Gb RAM machine, the sqlservr seems to be gobble up about 100Mb per day without releasing it (currently up to 1.1Gb RAM today).

The SQL Server is not currently being used by users (but will be very soon), but it is part of the Veritas backup schedule, so SQL Server is being used in this contex at present.

This could be normal operation, but I am trying to rule out the possibilty of a memory leak either in SQL Server or indeed Veritas (10d).

I guess I could restrict memory available to sqlservr, but I don't know if sqlservr will be happy when it uses up its allocation.

Anyone got any comments on why this may be happening and how to stop it, if indeed its a problem.

Thanks
SF

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sheepfarmer

ASKER

Any idea where in the SBS admin the memory is set or restricted, presumably by process?

Thanks
SF

Guy Hengel [angelIII / a3]

unfortunately, no idea about the SBS.
in SQL Server, you can do via a query:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_3wmr.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_0put.asp

sheepfarmer

ASKER

Many thanks