Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2008-03-05 : 17:24:09
|
| GUys,Is there any way track tables which have most no of reads and writes from a database of 400 tables.Thanks |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-05 : 17:28:33
|
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/96b28abb-b059-48db-be2b-d60fe127f6aa.htmmaybe that?search BOL for:fn_virtualfilestats
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2008-03-05 : 18:38:52
|
| Thanks for the link.But this gives statistics for the database - I want to find out no of reads and writes per individual table.Any suggestions and inputs should help.Thanks |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 22:32:20
|
| Or use third party sql auditing tool. |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-05 : 23:04:01
|
Oops. Must have pasted the wrong link..now I can't find the one I had that talked about dbcc memusage and some of the new 2005 features that I thought included some stats on which objects were being hit--but I am probably just mistaken..I am sure you will point out the mistake for me.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-05 : 23:17:36
|
| That feature is added in sql2k8. |
|
|
|
SusanthaB
Starting Member
14 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-06 : 22:26:34
|
| Run profiler 24x7? |
|
|
|
|
|
|
Track Reads and Writes