how to know DSS tables and OLTP tables !? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to know DSS tables and OLTP tables !?

hi all !<br />how to know in database which tables are DSS, and which are OLTP in sql 2000 !?<br />is there a way to determine which tables are frequently read and which ones are frequently written !???<br />by counting read and write counters in a representative trace made by Profiler !???<br />if i put each table in one specific database file, i could use :fn_virtualfilestats and get read/write stats but…. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />))<br /><br />thanks for help !!!<br />
I don’t know of any easy way to do this. I took a few minutes to see if I could do it with Profiler, but couldn’t come up with any good ways to make it work. Might I ask why you want this? The reason I ask, is that if you want some more information to help you better tune your database, an alternative method, which is easy to do with Profiler, is to identify those queries with the longest duration, and then focus on them, one at a time. Also, you could collect the read and write data for these long queries, and use this information to know if the table(s) being affected are mostly read or write orientated. ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com
]]>