I have Sybase SQL Anywhere v5.x and MS
SQL v7.0 installed on my comp whose specs are:Win 2k Professional Edition,
1.4 G P-4 processor, 2G Hz RAM. I have a databse which is around 600MB in
size and my problem is the SQL server is using up like 1.5G of RAM!!! Is
there anyway I could make the SQL server to use (as little as possible) of
the RAM usage. Please help me out.
Originally posted by bpdWork
If Enterprise Manager is not on the server, it should be on your Client machine (Enterprise Manager is part of client tools). Unless you are using MSDE and not SQL Server, in which case you are SOL.
Thanks for the reply, but I DO NOT find the Enterprise manager in either the server/client comp. Any thoughts on this?
sp_configure 'show advanced options', 1
sp_configure 'min server memory', <value in Mb>
sp_configure 'max server memory', <value in Mb>
sp_configure 'show advanced options', 0
Make min and max the same if you want an easy life. And restart after the change never goes amiss.
Thanks for the info,
should I just create a new procedure and paste whatever you have written and execute it or am i doing it the wrong way...since when I right click on the sp_configure procedure in sybase central I do not get any advanced properties. I am a newbie, so pls bear with me and help me out!