Memory Usage

Hi,
Can anyone tell me whats the best way of determining which databases are
using the most physical memory? I have a server with about 10 ms sql 2000
DB's and the server has 1 gigabyte of ram. The problem is that this memory
is almost always used up by sql and it slows the daily administration down.
I have to keep restarting the sql service which is only a temporary measure.
Thankyou,
Jay.
SQL Server will try to maximize the usage of memory to optimal performance.
If you are operating on 10 different databases then the memory usage and
overhead is on the high. I feel you can allocate more memory for the same.
Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
production systems.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me whats the best way of determining which databases are
> using the most physical memory? I have a server with about 10 ms sql 2000
> DB's and the server has 1 gigabyte of ram. The problem is that this memory
> is almost always used up by sql and it slows the daily administration
down.
> I have to keep restarting the sql service which is only a temporary
measure.
> Thankyou,
> Jay.
>
|||Set your max memory setting to around 700MB and see if that helps.
Andrew J. Kelly SQL MVP
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anyone tell me whats the best way of determining which databases are
> using the most physical memory? I have a server with about 10 ms sql 2000
> DB's and the server has 1 gigabyte of ram. The problem is that this memory
> is almost always used up by sql and it slows the daily administration
down.
> I have to keep restarting the sql service which is only a temporary
measure.
> Thankyou,
> Jay.
>
|||Thanks for the reply but I simply wish to find out what databases are using
the most resources and how much. I will probably end up having to add more
memory anyway.
Jay.
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:ugQj#XuIEHA.3032@.TK2MSFTNGP09.phx.gbl...
> SQL Server will try to maximize the usage of memory to optimal
performance.[vbcol=seagreen]
> If you are operating on 10 different databases then the memory usage and
> overhead is on the high. I feel you can allocate more memory for the same.
> Instead of restarting you can use the DBCC FREEPROCCACHE and DBCC
> DROPCLEANBUFFERS to clear the memory cache. I donot recommend this on
> production systems.
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp
>
> "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
2000[vbcol=seagreen]
memory
> down.
> measure.
>
|||Hi,
I agree with Andrew, To add on. check the Virtual memory allocated as well.
If the virtual memory is less then
go for 1048 MB.
One more thing , i feel that there is no option to find out the physical
memory usage per database. Procedure
cache usage can be identified by querying master..sysprocesses table.
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnoooospam@.shadhawk.com> wrote in message
news:O3pdAguIEHA.3444@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Set your max memory setting to around 700MB and see if that helps.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Jay Collen" <jcollen896@.yahoo.com> wrote in message
> news:eQv9qIuIEHA.3572@.TK2MSFTNGP10.phx.gbl...
2000[vbcol=seagreen]
memory
> down.
> measure.
>
|||You cannot get specific Database memory usage as you have asked. You would
have one set for the server level only.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Jay Collen" <jcollen896@.yahoo.com> wrote in message
news:O%23GGZhuIEHA.3988@.tk2msftngp13.phx.gbl...
> Thanks for the reply but I simply wish to find out what databases are
using[vbcol=seagreen]
> the most resources and how much. I will probably end up having to add more
> memory anyway.
> Jay.
>
> "Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
> news:ugQj#XuIEHA.3032@.TK2MSFTNGP09.phx.gbl...
> performance.
same.[vbcol=seagreen]
are
> 2000
> memory
>