HOW TO KNOW THE MOST ACCESED TABLE

• LMtz

  Mr or Mrs. 500

  Points: 514

  More actions

  September 26, 2006 at 3:58 pm

  #62814

  HI, I NEED TO KNOW WHICH ONE OF MY DATABASE TABLES ARE THE MOST ACCESED, CAN I TRACK THESE OR WHAT CAN I DO TO OBTAIN THIS INFORMATION.

  IM RUNNING WIN2003 AND SQL 2000 SP4.

  THANKS FOR ANY ADVICE.

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  September 26, 2006 at 7:29 pm

  #662612

  There was recently an article on main page.

  http://www.sqlservercentral.com/columnists/mmorin/2573.asp

  _____________
  Code for TallyGenerator