how to find out number of reads and writes for a table

Question

Post reply

how to find out number of reads and writes for a table

winston Smith

SSCoach

Points: 19500
More actions
July 16, 2008 at 3:12 am

#210003

I need to find out the number of reads and writes , sizes and other such info on tables ( try to identify largest, most heavily read, and most heavily modified tables)
what system tables/views/functions i can use to get this info?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

thasteve SSCrazy Points: 2707 More actions · Answer 1

theres is kinda a ton of them best to check bol for the dynamic management views

http://msdn.microsoft.com/en-us/library/ms188754.aspx

winston Smith SSCoach Points: 19500 More actions · Answer 2

checked that already, there is only index info in the dmv's, but nothing for table size. all i can find to determine tablesize is sp_spaceUsed, but id much rather find if the data is in a DMV/DMF.

thasteve SSCrazy Points: 2707 More actions · Answer 3

true that there is only a system view for index size and sp_spaceused the only way to determine the table size itself

winston Smith SSCoach Points: 19500 More actions · Answer 4

what about for table reads and writes? again, im aware of read and write info for indexes in the DMV's, but not for the actual table.

i could write a query to link tables up to indexes and get index usage, but what if there are queries running that dont use an index?

thasteve SSCrazy Points: 2707 More actions · Answer 5

don't know of a way there only down to database file level for everything more detailed I guess you have to buy some additional software if there is any even providing this kind of information before going straight down the query level.