Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Performance on partition table

Author  Topic 

DMP
Starting Member

41 Posts

Posted - 2015-02-19 : 07:22:54
How to assure partition table is giving better performance than non-partition table ?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-02-19 : 09:34:57
benchmark it before and after using typical workloads.

Note that partitioning is not a panacea for performance problems. It needs to be used appropriately. e.g. having more than one partition on the same disk will have little to no performance benefit.
Go to Top of Page
   

- Advertisement -