Wednesday, March 7, 2012

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

No comments:

Post a Comment