Hello, we have a database that contains three tables. Each table has more than 25,000,000 rows in them. All three tables are in the same file group, array, and drive. Our daily Avg physical I/O is 1,000,000. Our users are complaining that the system is slow daily. Everytime a user writes to any of thos three tables our Avg Disk Queue is 6 and that is when users start calling to complain.
What is best practice in this situation?
Is there a system table i can query to look at how many times data is pulled from any of the tables?
SQL Server 2005
September 24, 2010 8:36 PM
September 24, 2010 9:14 PM