SQL Server Performance

Table Archiving and Partitioning

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by ruancra, Jan 13, 2009.

  1. ruancra New Member

    Hi guys
    What is a general rowcount for a table before it needs to get archived or partitioned? If its a table that gets queried quite often?
    Thank you
    Ruan
  2. FrankKalis Moderator

    I don't think there are hard-coded rules and figures when a table becomes a good candidate for special treatment like you mentioned.It really depends on the whole system, the usage, the workload. etc...
    Are you facing any severe performance and/or maintenance issues?
  3. satya Moderator

    A billion or Trillion, what is your assumption and current status within your environment?

Share This Page