Is performance change when set filegroups on different disk?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

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

cgsabari

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

ssd_coolguy · Answer 1 · 2012-08-21T01:22:00

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[^]

Wendelius · Answer 2 · 2012-08-21T11:17:00

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[^]

Is performance change when set filegroups on different disk?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0