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 SQL Server?

Hello,
I have a request from a client to have monitoring of a specific
database in case any errors arise to help them isolate the problem.
Would using Profiler accomplish this? Is there a way to set it up so
it's only logged during working hours?Yes, you can set a filter to only cature events for a given time period.
"JSM" wrote:
> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>|||Hi
Look at creating a scheduled server side trace, although if there is alot of
activity you may be logging a significant amount of information. Jasper Smith
has a 1 hour trace http://www.sqldbatips.com/showcode.asp?ID=7 which you can
change to be (say) 9 hours and start before the beginning of the day in a SQL
Agent job.
John
"JSM" wrote:
> Hello,
> I have a request from a client to have monitoring of a specific
> database in case any errors arise to help them isolate the problem.
> Would using Profiler accomplish this? Is there a way to set it up so
> it's only logged during working hours?
>

Monitor only reads on just specific table

Can the profiler be set up to monitor only reads on just a specific
table?Hello Jim,
This is possible, you could add the following filter:
DatabaseName Like
ObjectName Like
Writes Less than 0
Reads Greater or equal 0
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: Jim Weiler <jim.weiler@.staples.com>
| Subject: Monitor only reads on just specific table
| Date: Thu, 1 Sep 2005 15:59:18 -0400
| Message-ID: <MPG.1d81260c38d3ad90989680@.msnews.microsoft.com>
| Organization: Staples
| MIME-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-15"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: MicroPlanet Gravity v2.60
| Newsgroups: microsoft.public.sqlserver.security
| NNTP-Posting-Host: 66.181.92.2
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:5925
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| Can the profiler be set up to monitor only reads on just a specific
| table?
|