mah_j (12/16/2012)
I created partition over [TransDate] and all the indexes ON DB_PartitionScheme ([TransDate]),but the logical reads of this table and cpu time increase in test db.
Not surprising.
I don't know why it is in this way?what should I do?
Because partitioning is not primarily for performance. It's for maintainability, data loads. You can get performance improvements out of partitioning, but usually not automatically.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability