February 21, 2008 at 4:19 pm
Hello 2 all,
anyone can give me some tips for following:
A) How can I check which tables are heavily used within db? Have found some tsql that shows me index usage. Should I use this as base for table usage? More index use = more table use?
B) I also would like to check disk performance. IOMeter seems to do the trick, but how can I determine how much reads & writes the server does? Again, some sql fn 'virtualfilestats' shows me some read & write info. Are these results ok to get %read & %writes to disks? Alternatively, DiskMon (ex- sysinternals) can 'record' all disk activity and then output results to file. But maybe this tool uses resources it should not.
Not even talking about how to get % random & %sequential 😉
Thanks for any input,
Rgds,
T .BE
February 21, 2008 at 5:43 pm
A) Depends what you mean by heavily used. Are you talking size or reads/writes? Size is easy - use sp_spaceused. You could always run SQL Profiler for a week and see what you get.
B) How about using the tools that come with Windows - System Monitor. Lots of stuff in there you could use. And you can even correlate it with your trace in SQL Profiler.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply