I use SQL Server 2000, sp4 and I would like to know what are the most used objects and how they are used on a DB.
I tried profiler, but it is showing just stored procedures use, no table or index use.
To test it, I selected a table 5 times, and these selects did not appear on the table where I saved profiler data.
Is there any way to monitor that kind of stuff?
Thanks in advance.