Database Memory Tool

Hi,
I'm wondering, is there any option/tool that could let me
monitor a database's memory. There's a maximum amount
that we can allow, and it would be nice to have some kind
of alarm/warning message that would tell us we're at our
maximum, or close to it.
Thank you kindly.
Marc
Marc wrote:
> Hi,
> I'm wondering, is there any option/tool that could let me
> monitor a database's memory. There's a maximum amount
> that we can allow, and it would be nice to have some kind
> of alarm/warning message that would tell us we're at our
> maximum, or close to it.
> Thank you kindly.
> Marc
You can use performance monitor to watch memory used by the SQL Server
service. If you have SQL Server set up to automatically configure memory
usage, it will use much of the server memory and not release any until
the OS requests it do so. Using a lot of memory does not necessarily
mean there is a problem. Since pages are moved into memory and kept
there, if your database is much larger than your memory footprint,
you're likely to see SQL Server using a lot of memory after enough
queries are run and pages read into memory. Certainly, adding as much
memory as SQL Server can handle is the best way to go, given how cheap
memory is and how slow disk access is. If you see a lot of disk activity
(also monitored from performance monitor), you may try and tune your
queries. Eliminating unnecessary reading of data keeps the data in cache
from moving out. Things like table scans cause a lot of data to move
into cache and forces data that can benefit from being in cache out.
Reading from disk is slow.
David Gugick
Imceda Software
www.imceda.com

Database master key

There's a conflict on my understanding of the database master key in
SQL Server 2005.
Reading from the book, it mention database master key is optional.
But when I try to create certificate, it prompt me error:
======
Msg 15581, Level 16, State 1, Line 1
Please create a master key in the database or open the master key in
the session before performing this operation.
======
After I create the master key, then create the certificate again, it
works fine. It means that the database master key is mandatory IF I'm
going to use encryption.
Anyone can clarify this?
Thanks.
wodoy.peter
You need to use the ENCRYPTION BY PASSWORD clause.
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1170010225.064765.151440@.l53g2000cwa.googlegr oups.com...
> There's a conflict on my understanding of the database master key in
> SQL Server 2005.
> Reading from the book, it mention database master key is optional.
> But when I try to create certificate, it prompt me error:
> ======
> Msg 15581, Level 16, State 1, Line 1
> Please create a master key in the database or open the master key in
> the session before performing this operation.
> ======
> After I create the master key, then create the certificate again, it
> works fine. It means that the database master key is mandatory IF I'm
> going to use encryption.
> Anyone can clarify this?
> Thanks.
>
> wodoy.peter
>
|||Thanks.
On Jan 29, 12:46 pm, "Mike C#" <x...@.xyz.com> wrote:[vbcol=seagreen]
> You need to use the ENCRYPTION BY PASSWORD clause.
> "wodoy.peter" <wodoy.pe...@.gmail.com> wrote in messagenews:1170010225.064765.151440@.l53g2000cwa.g ooglegroups.com...
>
>
>
>