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.

Monitoring Disk activity

Whats the best perfmon counter to use to check how many
bytes are being read and written to disk/sec ?
I know most of the read and writes take place within a
virtual buffer cache, but what triggers a read/write from
disk .. I am currently running SQL 2000 if that helps
The Physical Disk: Bytes Read(and Write) / Sec will give you just that. You
can also use fn_virtualfilestats() to get totals.
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a5a01c45ecc$0b2044e0$a301280a@.phx.gbl...
> Whats the best perfmon counter to use to check how many
> bytes are being read and written to disk/sec ?
> I know most of the read and writes take place within a
> virtual buffer cache, but what triggers a read/write from
> disk .. I am currently running SQL 2000 if that helps
|||Hi,
Add on, Have a look into this link.
http://www.sql-server-performance.co...ounters_io.asp
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:#bLPn2sXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> The Physical Disk: Bytes Read(and Write) / Sec will give you just that.
You
> can also use fn_virtualfilestats() to get totals.
> --
> Andrew J. Kelly SQL MVP
>
> "Jamie" <anonymous@.discussions.microsoft.com> wrote in message
> news:23a5a01c45ecc$0b2044e0$a301280a@.phx.gbl...
>
|||I generally start off by observing Physical Disk queue length counters as
this tells you whether the disk subsystem is keeping up with the i/o
requests made by sql (or other apps on the same box) through windows. This
is because i/o requests are queued by windows against the i/o subsystem and
if that queue is too large (more than a few i/o's per phsyical disk) or
growing, you have a clear indication that the disk is a bottleneck (not
keeping up).
If you do see a problem here, you next need to ascertain whether the amount
of work being sent to the disk is excessive, due to inefficient query plans
etc.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a5a01c45ecc$0b2044e0$a301280a@.phx.gbl...
> Whats the best perfmon counter to use to check how many
> bytes are being read and written to disk/sec ?
> I know most of the read and writes take place within a
> virtual buffer cache, but what triggers a read/write from
> disk .. I am currently running SQL 2000 if that helps

Monitoring Disk activity

Whats the best perfmon counter to use to check how many
bytes are being read and written to disk/sec ?
I know most of the read and writes take place within a
virtual buffer cache, but what triggers a read/write from
disk .. I am currently running SQL 2000 if that helpsThe Physical Disk: Bytes Read(and Write) / Sec will give you just that. You
can also use fn_virtualfilestats() to get totals.
--
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a5a01c45ecc$0b2044e0$a301280a@.phx.gbl...
> Whats the best perfmon counter to use to check how many
> bytes are being read and written to disk/sec ?
> I know most of the read and writes take place within a
> virtual buffer cache, but what triggers a read/write from
> disk .. I am currently running SQL 2000 if that helps|||Hi,
Add on, Have a look into this link.
http://www.sql-server-performance.com/performance_monitor_counters_io.asp
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:#bLPn2sXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> The Physical Disk: Bytes Read(and Write) / Sec will give you just that.
You
> can also use fn_virtualfilestats() to get totals.
> --
> Andrew J. Kelly SQL MVP
>
> "Jamie" <anonymous@.discussions.microsoft.com> wrote in message
> news:23a5a01c45ecc$0b2044e0$a301280a@.phx.gbl...
> > Whats the best perfmon counter to use to check how many
> > bytes are being read and written to disk/sec ?
> >
> > I know most of the read and writes take place within a
> > virtual buffer cache, but what triggers a read/write from
> > disk .. I am currently running SQL 2000 if that helps
>|||I generally start off by observing Physical Disk queue length counters as
this tells you whether the disk subsystem is keeping up with the i/o
requests made by sql (or other apps on the same box) through windows. This
is because i/o requests are queued by windows against the i/o subsystem and
if that queue is too large (more than a few i/o's per phsyical disk) or
growing, you have a clear indication that the disk is a bottleneck (not
keeping up).
If you do see a problem here, you next need to ascertain whether the amount
of work being sent to the disk is excessive, due to inefficient query plans
etc.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a5a01c45ecc$0b2044e0$a301280a@.phx.gbl...
> Whats the best perfmon counter to use to check how many
> bytes are being read and written to disk/sec ?
> I know most of the read and writes take place within a
> virtual buffer cache, but what triggers a read/write from
> disk .. I am currently running SQL 2000 if that helps

Monitoring Disk activity

Whats the best perfmon counter to use to check how many
bytes are being read and written to disk/sec ?
I know most of the read and writes take place within a
virtual buffer cache, but what triggers a read/write from
disk .. I am currently running SQL 2000 if that helpsThe Physical Disk: Bytes Read(and Write) / Sec will give you just that. You
can also use fn_virtualfilestats() to get totals.
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a5a01c45ecc$0b2044e0$a301280a@.phx
.gbl...
> Whats the best perfmon counter to use to check how many
> bytes are being read and written to disk/sec ?
> I know most of the read and writes take place within a
> virtual buffer cache, but what triggers a read/write from
> disk .. I am currently running SQL 2000 if that helps|||Hi,
Add on, Have a look into this link.
http://www.sql-server-performance.c...counters_io.asp
Thanks
Hari
MCDBA
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:#bLPn2sXEHA.2816@.TK2MSFTNGP11.phx.gbl...
> The Physical Disk: Bytes Read(and Write) / Sec will give you just that.
You
> can also use fn_virtualfilestats() to get totals.
> --
> Andrew J. Kelly SQL MVP
>
> "Jamie" <anonymous@.discussions.microsoft.com> wrote in message
> news:23a5a01c45ecc$0b2044e0$a301280a@.phx
.gbl...
>|||I generally start off by observing Physical Disk queue length counters as
this tells you whether the disk subsystem is keeping up with the i/o
requests made by sql (or other apps on the same box) through windows. This
is because i/o requests are queued by windows against the i/o subsystem and
if that queue is too large (more than a few i/o's per phsyical disk) or
growing, you have a clear indication that the disk is a bottleneck (not
keeping up).
If you do see a problem here, you next need to ascertain whether the amount
of work being sent to the disk is excessive, due to inefficient query plans
etc.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a5a01c45ecc$0b2044e0$a301280a@.phx
.gbl...
> Whats the best perfmon counter to use to check how many
> bytes are being read and written to disk/sec ?
> I know most of the read and writes take place within a
> virtual buffer cache, but what triggers a read/write from
> disk .. I am currently running SQL 2000 if that helps

Monitoring ...

I want to monitor the activity on a specific table, but I can't seem to get
the Profiler to cooperate. I know this table is active because it is a
locking table that we use to lock interdependant modules from conflicts so
it is constantly being hit with inserts, updates and deletes. I tried
filtering on object name, but the gives me nothing.
Hints and clues most welcome.
Bob Castleman
DBA PoseurWhat events are you monitoring? Are you looking specifically for DELETES,
UPDATES and INSERTS?
"Bob Castleman" wrote:

> I want to monitor the activity on a specific table, but I can't seem to ge
t
> the Profiler to cooperate. I know this table is active because it is a
> locking table that we use to lock interdependant modules from conflicts so
> it is constantly being hit with inserts, updates and deletes. I tried
> filtering on object name, but the gives me nothing.
> Hints and clues most welcome.
> Bob Castleman
> DBA Poseur
>
>|||Yup. I want to know just how active this puppy is.
"Cris_Benge" <CrisBenge@.discussions.microsoft.com> wrote in message
news:B9D551D0-D21C-43DF-9212-BFD2AF1CF7AA@.microsoft.com...
> What events are you monitoring? Are you looking specifically for DELETES,
> UPDATES and INSERTS?
> "Bob Castleman" wrote:
>|||If you've got stored procedures which perform the updates these won't get
listed by profiler.
A possible alternative could be to add some triggers to the table, and use
them to populate an audit table.
That's by best shot on this.
"Bob Castleman" <nomail@.here> wrote in message
news:eVhML$FbFHA.2444@.TK2MSFTNGP15.phx.gbl...
> Yup. I want to know just how active this puppy is.
>
> "Cris_Benge" <CrisBenge@.discussions.microsoft.com> wrote in message
> news:B9D551D0-D21C-43DF-9212-BFD2AF1CF7AA@.microsoft.com...
>

monitor user activity and bandwidth

Hi,
I am running perfomance monitor and I noticed that my network bandwidth is
off the chart.
How can I write a SQL query to find out who and which database is using all
the bandwidth on the SQL Server?
Thanks in advance.You may want to start here;
821914 HOW TO: Troubleshoot Application Performance with SQL Server 2000
http://support.microsoft.com/?id=821914
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

monitor user activity and bandwidth

Hi,
I am running perfomance monitor and I noticed that my network bandwidth is
off the chart.
How can I write a SQL query to find out who and which database is using all
the bandwidth on the SQL Server?
Thanks in advance.This is sql2000 correct?
You could run a sql profiler trace with maybe Audit Login and logout
settings chosen, along with maybe the RPC events. But again, the profiler
will be running and consuming disk space so you'll have to keep recycling
it or run it only during the time you need it.
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 Table Activity

Dear All,
I want to Monitor a table or multiple table activities with the follwing
results.
1. Previous Value
2. New Value
3. Table Row Changed
Thanks in advanceHi,
You have write your own triggers for Insert and Update actions.
Thanks
Hari
MCDBA
"Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
news:OB4LyN#FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> I want to Monitor a table or multiple table activities with the follwing
> results.
> 1. Previous Value
> 2. New Value
> 3. Table Row Changed
> Thanks in advance
>|||THere is also a tool that Lumigent makes which analyzes the T-Log, etc which
( I beleive) can do what you wish... Integra ( www.lumigent.com)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
news:OB4LyN%23FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> I want to Monitor a table or multiple table activities with the follwing
> results.
> 1. Previous Value
> 2. New Value
> 3. Table Row Changed
> Thanks in advance
>|||I have just been playing around with the demo if this software and it seems
really good. Certainly look slike it will save me the many hours of
building an audit trail into my application!
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OmW4dk%23FEHA.576@.TK2MSFTNGP11.phx.gbl...
> THere is also a tool that Lumigent makes which analyzes the T-Log, etc
which
> ( I beleive) can do what you wish... Integra ( www.lumigent.com)
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
> news:OB4LyN%23FEHA.3188@.TK2MSFTNGP10.phx.gbl...
>

Monitor Table Activity

Dear All,
I want to Monitor a table or multiple table activities with the follwing
results.
1. Previous Value
2. New Value
3. Table Row Changed
Thanks in advance
Hi,
You have write your own triggers for Insert and Update actions.
Thanks
Hari
MCDBA
"Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
news:OB4LyN#FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> I want to Monitor a table or multiple table activities with the follwing
> results.
> 1. Previous Value
> 2. New Value
> 3. Table Row Changed
> Thanks in advance
>
|||THere is also a tool that Lumigent makes which analyzes the T-Log, etc which
( I beleive) can do what you wish... Integra ( www.lumigent.com)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
news:OB4LyN%23FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> I want to Monitor a table or multiple table activities with the follwing
> results.
> 1. Previous Value
> 2. New Value
> 3. Table Row Changed
> Thanks in advance
>
|||I have just been playing around with the demo if this software and it seems
really good. Certainly look slike it will save me the many hours of
building an audit trail into my application!
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:OmW4dk%23FEHA.576@.TK2MSFTNGP11.phx.gbl...
> THere is also a tool that Lumigent makes which analyzes the T-Log, etc
which
> ( I beleive) can do what you wish... Integra ( www.lumigent.com)
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Syed Zulfiqar" <zulfiqar_syed@.hotmail.com> wrote in message
> news:OB4LyN%23FEHA.3188@.TK2MSFTNGP10.phx.gbl...
>

Monitor SQL Statements

I would like to monitor any non stored procedure activity on a sql
server (2000 and 2005). Mainly I need to watch for ad hoc sql from
applications and for people running sql from query analyzer.
I think that Profiler will do this, but I have concerns about how much
overhead that will cause. At times, the server is very busy and I have
SLA in place that would cause me to pay a penalty for slow response
time.
Any suggestions?
Jim
St LouisFirst off you should never use Profiler for traces on busy systems. You can
simply use TRACE and send the results to a binary file on a disk attached
locally to the server. Then you can copy them to another machine for
processing or viewing. The easiest way (if you are not familiar with that)
to do that is to briefly use profiler. Set up the events and columns and
filters exactly how you want it. Then run the trace and immediately hit
stop. Then go to File - Script Trace - For 2000. This will generate a tsql
script that you can use to run a trace without the overhead of profiler.
Follow the instructions in the script to add the filename and adjust the
maxfilesize etc. Look up sp_tracecreate in booksonline for more details. If
the sp's are being run as RPC's and not batches you can just look for Batch
Completed events and ignore all the sps.
Andrew J. Kelly SQL MVP
"Jim Youmans" <jdyoumans@.gmail.com> wrote in message
news:1150981788.688853.289590@.u72g2000cwu.googlegroups.com...
>I would like to monitor any non stored procedure activity on a sql
> server (2000 and 2005). Mainly I need to watch for ad hoc sql from
> applications and for people running sql from query analyzer.
> I think that Profiler will do this, but I have concerns about how much
> overhead that will cause. At times, the server is very busy and I have
> SLA in place that would cause me to pay a penalty for slow response
> time.
> Any suggestions?
> Jim
> St Louis
>|||First off you should never use Profiler for traces on busy systems. You can
simply use TRACE and send the results to a binary file on a disk attached
locally to the server. Then you can copy them to another machine for
processing or viewing. The easiest way (if you are not familiar with that)
to do that is to briefly use profiler. Set up the events and columns and
filters exactly how you want it. Then run the trace and immediately hit
stop. Then go to File - Script Trace - For 2000. This will generate a tsql
script that you can use to run a trace without the overhead of profiler.
Follow the instructions in the script to add the filename and adjust the
maxfilesize etc. Look up sp_tracecreate in booksonline for more details. If
the sp's are being run as RPC's and not batches you can just look for Batch
Completed events and ignore all the sps.
Andrew J. Kelly SQL MVP
"Jim Youmans" <jdyoumans@.gmail.com> wrote in message
news:1150981788.688853.289590@.u72g2000cwu.googlegroups.com...
>I would like to monitor any non stored procedure activity on a sql
> server (2000 and 2005). Mainly I need to watch for ad hoc sql from
> applications and for people running sql from query analyzer.
> I think that Profiler will do this, but I have concerns about how much
> overhead that will cause. At times, the server is very busy and I have
> SLA in place that would cause me to pay a penalty for slow response
> time.
> Any suggestions?
> Jim
> St Louis
>

Monitor SQL server activity

Hi,
This question has been asked thousand of times I'm sure
but anyway:
Does it exist an EASY way to monitor, or trace, or log the
activity on a specific database using sql server ?
In fact, I'd like to record all the SELECT made on a
database (having insert, delete, update would also be
great), without using third party tool and having a
readable log file.
Thanks,
OlivierHello,
Have you considered setting up a SQL Profile, and
configuring it to that one database, SQL Commands only ?
Thanks
Peter
>--Original Message--
>Hi,
>This question has been asked thousand of times I'm sure
>but anyway:
>Does it exist an EASY way to monitor, or trace, or log
the
>activity on a specific database using sql server ?
>In fact, I'd like to record all the SELECT made on a
>database (having insert, delete, update would also be
>great), without using third party tool and having a
>readable log file.
>Thanks,
>Olivier
>.
>