P
Paul Koufalis
Guest
Regarding cjbrandt 's suggestion: you need to be certain to correctly assign the DB startup parameters -tablerangesize and -indexrangesize otherwise the broker only tracks statistics for the first 50 tables and indexes. One caveat: _UserTableStat and _UserIndexStat info only live for as long as the user is connected. If an ODBC connection connects, does a quick query, then disconnects, then you're timing will have to be perfect to catch his tablestat activity. Another option is to enable SQL logging. Look in the SQL Reference PDF for SET PRO_CONNECT LOG and SET PRO_SERVER LOG.
Continue reading...
Continue reading...