Home » RDBMS Server » Performance Tuning » distributing datafiles in server (Win 2000,8.1.7)
distributing datafiles in server [message #480611] Tue, 26 October 2010 01:24 Go to next message
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
Senior Member
Hi,

Could someone please tell me how to distribute the datafiles among various disks of a server, so that I/O operations are improved.

I mean is there any area we need to focus while distributing the disk like:
1)Particular types of datafiles should be placed in one disk.
2)Temp/Undo/Rollback tablespaces in another disk.
3)Indexes in another disk

Is this a right way? Please guide me if i am wrong.

Best Regards,
Re: distributing datafiles in server [message #480613 is a reply to message #480611] Tue, 26 October 2010 01:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Stripe everything on all disks (and if you can separate redo logs on other ones).

Regards
Michel
Re: distributing datafiles in server [message #480625 is a reply to message #480613] Tue, 26 October 2010 02:44 Go to previous messageGo to next message
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
Senior Member
Since data is mission critical, we need higher availablity and Max performance. Which RAID level will be good RAID 5 or RAID (1+0 or 0+1).


Could you also please explain me briefly your statement:

Quote:
Stripe everything on all disks (and if you can separate redo logs on other ones).

Re: distributing datafiles in server [message #480629 is a reply to message #480625] Tue, 26 October 2010 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Did you read the link I provided?
Did you try to search on the web?
Do you think you are the first one to ask this question?

Regards
Michel
Re: distributing datafiles in server [message #480630 is a reply to message #480629] Tue, 26 October 2010 02:49 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.google.com/search?hl=en&source=hp&q=stripe+and+mirror+everything&aq=2&aqi=g1&aql=&oq=stripe+and+mi &gs_rfai=

Regards
Michel
Previous Topic: Difference in query performance
Next Topic: DBMS Stats gathering
Goto Forum:
  


Current Time: Fri Nov 22 07:47:09 CST 2024