Is there any way to find out how many times tables have
been accessed? What I am interested in... is getting a
list of tables and a number of times a table has been
accessed in a day or so.
I would like to do it without loading production server if
possible.
Any thoughts, Ideas or help would be greatly appreciated.
Thanks,
AtulSQL Server does not keep this type of statistics, imagine the overhead
everyone would pay...
You can have a profiler trace running, possibly storing into a file or table
and then run reports against that file/table.-
--
Tibor Karaszi
"Atul" <anonymous@.discussions.microsoft.com> wrote in message
news:0ded01c3a21f$7cc384a0$a401280a@.phx.gbl...
> Is there any way to find out how many times tables have
> been accessed? What I am interested in... is getting a
> list of tables and a number of times a table has been
> accessed in a day or so.
> I would like to do it without loading production server if
> possible.
> Any thoughts, Ideas or help would be greatly appreciated.
> Thanks,
> Atul
No comments:
Post a Comment