Re: Reads and writes to a sql server database per table

Use the sql profiler. In the trace properties make sure you have the
data columns reads and writes selected. you can further filter it down
from there.

mngong@xxxxxxxxx wrote:
Or better find the total reads and writes to all sql server tables

.

Relevant Pages

  • Re: Receive Error: 17805 Invalid buffer received from client
    ... You get capture exceptions using the ... What you filter on depends more on your system. ... least filter out the applications SQL Profiler and SQLAgent% ... >to specify in the trace to identify the transaction that is causing this ...
    (microsoft.public.sqlserver.clients)
  • SQL Profiler
    ... with SQL profiler. ... they say to include some Event Classes and some Data Columns that I do ... Prev by Date: ...
    (microsoft.public.sqlserver.tools)
  • SQL Profiler
    ... with SQL profiler. ... they say to include some Event Classes and some Data Columns that I do ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Re: Access ADP, filter lookup & SQL Server 2000
    ... through the trace that is output by SQL Profiler. ... account does not insert records into the temporary table whereas my account ... could do the filter by form no problem. ... by form rose it's ugly head. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Profiler logging SP:Starting hundreds of times for one SP
    ... However, when we trace it using SQL Profiler, it reports ... >> I realise that we can filter out the duplicates by only capturing ... > It looks like you have a function on a column in the query. ...
    (microsoft.public.sqlserver.tools)