在不同磁盘上设置文件组时，性能是否会改变? [英] Is performance change when set filegroups on different disk?

问题描述

我已经为数据库创建了一个分区表，并在"C:"中设置了主文件(.mdf)和日志文件(.ldf)路径，在"D:"中设置了辅助文件的s(.ndf)路径在同一个硬盘中.然后做了一些查询性能.很好.

现在，我的疑问是，如果将主文件放在一个硬盘中，将辅助文件放在另一个硬盘中，它的性能是否很好.
这两个任务之间的性能差异是什么??
请任何人说.....

提前谢谢！！ ...

Hi,
I''ve created one partitioned table for a database and set primary file(.mdf) & log file(.ldf) path in "C:" and set secondary file''s(.ndf) path in "D:" are in same hard disk. then did some queries performance. its well.

Now, my doubt is, If I will set primary file in one hard disk and secondary file in another hard disk, is it perform well.??

what is the performance difference between for both task???
pls, anyone say.....

advance thanks!!...

推荐答案

hii ..
如果在单独的磁盘上创建辅助数据文件(.ndf)...则在查询时会获得更好的性能...
请参阅以下链接..

http://sqlserverpedia.com/wiki/配置_数据库_文件_用于_最佳性能 [ ^ ]

hii..
if you create your secondary datafile(.ndf) on seprate disk... then while querying you will get better perforamnce...
see the below links..

http://sqlserverpedia.com/wiki/Configuring_Database_Files_for_Optimal_Perfomance[^]
http://stackoverflow.com/questions/2707403/what-are-ndf-files[^]

将数据拆分到多个磁盘上可以加快数据库中的物理操作.但是，有很多因素会影响到这一点:

• 磁盘实际上是分开的物理磁盘吗?
• 您是否可以控制磁盘以指示物理位置(例如，考虑使用RAID 5)
• 拆分磁盘的计划是什么?数据，只需让SQL Server对其进行拆分或进行更彻底的控制
• 磁盘是否具有单独的控制器或是否已共享，等等...

Splitting the data across several disks speeds up the phydical operations in the database. However, there are lots of things that affect this:

• Are the disks actually separate physical disks
• Do you have control over the disks to instruct the physical location (for example consider RAID 5)
• What is the plan to split the data, just let SQL Server to split it or control more thoroughly
• Do the disks have a separate controller or is it shared and so on...

这篇关于在不同磁盘上设置文件组时，性能是否会改变?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！