• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 230
  • Last Modified:

SQL Server 2005 Data Partitioning

Does partitioning a table help if the data partions for the the table are on the same physical disk?
0
mddohm
Asked:
mddohm
  • 3
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
yes it will...
0
 
mddohmAuthor Commented:
How so?  
0
 
TleeyahooCommented:
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
mddohmAuthor Commented:
Can you elaborate how this will help while multiple partitions are on the same physical disk?  Even if it does improve performance, would it be even better to partition accross different physical disks?
0
 
TleeyahooCommented:
Multiple disks are better.  You may get some CPU improvement with all partitions on a single disk but more disks is best
0
 
mddohmAuthor Commented:
Excellent technical reference was provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now