Click here to Skip to main content
11,629,614 members (62,215 online)
Rate this: bad
good
Please Sign up or sign in to vote.
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!!...
Posted 20-Aug-12 23:50pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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...
If you let the SQL Server to split the data, it'll most likely write to all of the files evenly. Depending on the situation, this may not be what you're after. For more control, have a look at the concept of FILEGROUP in CREATE DATABASE[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS


Advertise | Privacy | Mobile
Web01 | 2.8.150723.1 | Last Updated 21 Aug 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100