• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • 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
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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