SQL Server Performance

how to know DSS tables and OLTP tables !?

Discussion in 'General DBA Questions' started by skweeky, Jan 22, 2003.

  1. skweeky New Member

    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 />
  2. bradmcgehee New Member

    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

Share This Page