Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

Create/ ADD a Datafile ONLINE

Experts -

This is a simple question to you, but I just wanted to confirm it before changing anything on the live DB.

Question : Can I add more datafiles  to a new drive just got created while system is online? Does it make any performance impact? Do I have to restart the server? Any concerns?

This is the production system.

Thanks,

~Sve.
0
sventhan
Asked:
sventhan
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, that is perfectly possible without any issues in regards to the online system
0
 
Aaron ShiloCommented:
yes you can add datafiles to exsisting file gorups on an online system with no worries.
no performance degradetion will occour as long as you dont initialize the file with a TOO large value.

Good Luck
0
 
Aaron ShiloCommented:
by large value imean size
0
 
sventhanAuthor Commented:
Thanks for the feedback.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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