December 17, 2007 at 1:13 am
I am looking for access counters on SQL Server tables, which help me to answer this questions:
-number of read/write access to tables
-date/time of access
-number of accesses over a certain period of time
-number of objects modified/queried
-etc.
December 17, 2007 at 1:26 am
Take a look at SQL profiler. There are counters for object access. Be warned, they are fairly high-frequency events, so you'll get lots and lots of trace data.
If you go this route on a production server I would recommend that you use profiler to create a server-side trace (using the sp_trace* procs) rather than using the profiler GUI. (File-Export-Script Trace Definition)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2007 at 9:01 am
I agree with Gail and I might break these out to a few separate traces (object changes v access) to deal with the data.
Be sure you have a good disk system for the writes and watch for it filling up disk space (or database space if you log there).
December 19, 2007 at 3:26 am
thanks for the replies. anyway, just for my information is there another way than SQLProfiler?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply