monitoring memory usage of particular database

We would like to individually monitor the memory usage of all the different
databases on a server. In Current Activity in Enterprise Manager I see Memor
y Usage for the databases - is there a way to log that information? I didn't
see Memory Usage as a data
column in the Trace Properties in the Profiler. Thank you.Could the Perfmon be of any help? You ahve database counters there, depends
on what information you need.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

monitoring memory usage of particular database

We would like to individually monitor the memory usage of all the different databases on a server. In Current Activity in Enterprise Manager I see Memory Usage for the databases - is there a way to log that information? I didn't see Memory Usage as a data
column in the Trace Properties in the Profiler. Thank you.
Could the Perfmon be of any help? You ahve database counters there, depends
on what information you need.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Monitor Server

I have few questions?
1. Can I implement log shipping into two systems which has
a SQL Server Enterprise Manager.
2. We can installed monitoring server on the standby or
have to need the separate server.
Thanks
David
Yes, you can setup Log Shipping between two SQL Servers.
Here is some info:
314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?id=314515
323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
Paper)
http://support.microsoft.com/?id=323135
325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
http://support.microsoft.com/?id=325220
821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
http://support.microsoft.com/?id=821786
321247 HOW TO: Configure Security for Log Shipping
http://support.microsoft.com/?id=321247
329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
Errors
http://support.microsoft.com/?id=329133
I did not understand the second question.
Keith
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:089c01c50314$f10bd180$a601280a@.phx.gbl...
> I have few questions?
> 1. Can I implement log shipping into two systems which has
> a SQL Server Enterprise Manager.
> 2. We can installed monitoring server on the standby or
> have to need the separate server.
> Thanks
>
> David

MOM & SQL Monitoring

Does anyone know the Microsoft SQL site whereby I can
collect information regarding using Microsoft Operations
Manager to Monitor SQL server..
Thanks,
AngelinaThis is your starting point: http://www.microsoft.com/mom/
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Angelina" <anonymous@.discussions.microsoft.com> wrote in message
news:1116901c3f53f$92e65820$a301280a@.phx.gbl...
Does anyone know the Microsoft SQL site whereby I can
collect information regarding using Microsoft Operations
Manager to Monitor SQL server..
Thanks,
Angelina|||Thanks Narayana,
Done that. I'm looking for specifics on how monitoring
can be setup for SQL Server. Just trying to cut down the
chase.
Thanks,
Angelina
>--Original Message--
>This is your starting point:
http://www.microsoft.com/mom/
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Angelina" <anonymous@.discussions.microsoft.com> wrote
in message
>news:1116901c3f53f$92e65820$a301280a@.phx.gbl...
>Does anyone know the Microsoft SQL site whereby I can
>collect information regarding using Microsoft Operations
>Manager to Monitor SQL server..
>Thanks,
>Angelina
>
>.
>