The following symptoms may indicate that your system could benefit from attention to object placement:
Single-user performance is satisfactory, but response time increases significantly when multiple processes are executed.
Access to a mirrored disk takes twice as long as access to an unmirrored disk.
Query performance degrades as system table activity increases.
Maintenance activities seem to take a long time.
Stored procedures seem to slow down as they create temporary tables.
Insert performance is poor on heavily used tables.
Queries that run in parallel perform poorly, due to an imbalance of data pages on partitions or devices, or they run in serial, due to extreme imbalance.