All DB's in the same Storage Group?
Exchange Server Forum Index Exchange Server
Discussion forums for Microsoft Exchange Server users.
Microsoft Outlook
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web ExchangeServerHelp.com
All DB's in the same Storage Group?

 
Post new topic   Reply to topic    Exchange Server Forum Index -> Design
Author Message
SM
Guest





Posted: Thu Dec 02, 2004 3:14 am    Post subject: All DB's in the same Storage Group? Reply with quote

We're getting ready to setup EX2003 on a new box. Currently we have 1
mailbox database and 1 public store database. To help improve recovery
speed the mailbox database is going to be broken into 3 databases. Here's
the question... Is it better to put each DB into it's own Storage Group
(thus using all 4 SG's)? It seems like more overhead, but I was thinking
that in the event of a restore it might be nice to have seperate transaction
logs. What's common practice?

Thanks in advance.

-SM

Back to top
Jan Englund
Guest





Posted: Fri Dec 03, 2004 1:43 am    Post subject: Re: All DB's in the same Storage Group? Reply with quote

Hi
If you are going to be running on a Enterprise licens and the server is well
eqipped hardwarewise i would actually dived the users into as many databases
as possible (20) (19 if you need 1 for the PF).
This would give you the best restore time overall.
And yes an increase of storagegroups will add more load on the server so
only do this if you have a low baseline.
But if you compare this with what you suggest i think you will find this to
be a better solution restorewise.


--
Best Regards
Jan Englund
Capgemini Sweden
MCSA 2000/2003, MCSE NT4/2000/2003
MCSA 2000/2003:Messaging MCSE2000/2003:Messaging
www.se.capgemini.com
"SM" <sm@mail.org> wrote in message
news:ON106q%231EHA.2316@TK2MSFTNGP15.phx.gbl...
Quote:
We're getting ready to setup EX2003 on a new box. Currently we have 1
mailbox database and 1 public store database. To help improve recovery
speed the mailbox database is going to be broken into 3 databases. Here's
the question... Is it better to put each DB into it's own Storage Group
(thus using all 4 SG's)? It seems like more overhead, but I was thinking
that in the event of a restore it might be nice to have seperate
transaction
logs. What's common practice?

Thanks in advance.

-SM

Back to top
SM
Guest





Posted: Fri Dec 03, 2004 8:47 pm    Post subject: Re: All DB's in the same Storage Group? Reply with quote

Jan, thanks for the feedback. Sorry I didn't mention the database size
before, it's about ~120GB. Restore times would be quicker, but I think
having 20 DB's would be overkill for our organization (more chance for one
of them to fail, plus alot of overhead and very little single instance
storage). I'm thinking maybe I'll use 2 SG's with something like the
following?

SG1
*Pub Folder ~35GB
*Exec users ~ 10GB

SG2
*A-G ~30GB
*H-N ~ 30GB
*O-Z -30GB

Thanks again,
SM

"Jan Englund" <Jan.englund@NOSPAM.capgeminidotcom> wrote in message
news:e$ZX3cK2EHA.924@TK2MSFTNGP14.phx.gbl...
Quote:
Hi
If you are going to be running on a Enterprise licens and the server is
well
eqipped hardwarewise i would actually dived the users into as many
databases
as possible (20) (19 if you need 1 for the PF).
This would give you the best restore time overall.
And yes an increase of storagegroups will add more load on the server so
only do this if you have a low baseline.
But if you compare this with what you suggest i think you will find this
to
be a better solution restorewise.


--
Best Regards
Jan Englund
Capgemini Sweden
MCSA 2000/2003, MCSE NT4/2000/2003
MCSA 2000/2003:Messaging MCSE2000/2003:Messaging
www.se.capgemini.com
"SM" <sm@mail.org> wrote in message
news:ON106q%231EHA.2316@TK2MSFTNGP15.phx.gbl...
We're getting ready to setup EX2003 on a new box. Currently we have 1
mailbox database and 1 public store database. To help improve recovery
speed the mailbox database is going to be broken into 3 databases.
Here's
the question... Is it better to put each DB into it's own Storage Group
(thus using all 4 SG's)? It seems like more overhead, but I was
thinking
that in the event of a restore it might be nice to have seperate
transaction
logs. What's common practice?

Thanks in advance.

-SM





Back to top
Al Mulnick
Guest





Posted: Sat Dec 04, 2004 5:00 am    Post subject: Re: All DB's in the same Storage Group? Reply with quote

In that case, you won't really meet your requirements then, will you?
I wouldn't have any qualms about putting the user DB's in their own SG as
much as possible. There is overhead in terms of memory and log files IOPS to
work out, but I think it's worth it in terms of recovery/backup scenarios.
You can backup/restore in parallel at the SG level, not the DB level. That
can significantly impact your backup and recovery *time*. You need the
throughput either way, so don't forget to plan for it.

Al


"SM" <sm@mail.org> wrote in message
news:edst6bU2EHA.1564@TK2MSFTNGP09.phx.gbl...
Quote:
Jan, thanks for the feedback. Sorry I didn't mention the database size
before, it's about ~120GB. Restore times would be quicker, but I think
having 20 DB's would be overkill for our organization (more chance for one
of them to fail, plus alot of overhead and very little single instance
storage). I'm thinking maybe I'll use 2 SG's with something like the
following?

SG1
*Pub Folder ~35GB
*Exec users ~ 10GB

SG2
*A-G ~30GB
*H-N ~ 30GB
*O-Z -30GB

Thanks again,
SM

"Jan Englund" <Jan.englund@NOSPAM.capgeminidotcom> wrote in message
news:e$ZX3cK2EHA.924@TK2MSFTNGP14.phx.gbl...
Hi
If you are going to be running on a Enterprise licens and the server is
well
eqipped hardwarewise i would actually dived the users into as many
databases
as possible (20) (19 if you need 1 for the PF).
This would give you the best restore time overall.
And yes an increase of storagegroups will add more load on the server so
only do this if you have a low baseline.
But if you compare this with what you suggest i think you will find this
to
be a better solution restorewise.


--
Best Regards
Jan Englund
Capgemini Sweden
MCSA 2000/2003, MCSE NT4/2000/2003
MCSA 2000/2003:Messaging MCSE2000/2003:Messaging
www.se.capgemini.com
"SM" <sm@mail.org> wrote in message
news:ON106q%231EHA.2316@TK2MSFTNGP15.phx.gbl...
We're getting ready to setup EX2003 on a new box. Currently we have 1
mailbox database and 1 public store database. To help improve recovery
speed the mailbox database is going to be broken into 3 databases.
Here's
the question... Is it better to put each DB into it's own Storage
Group
(thus using all 4 SG's)? It seems like more overhead, but I was
thinking
that in the event of a restore it might be nice to have seperate
transaction
logs. What's common practice?

Thanks in advance.

-SM





Back to top
 
Post new topic   Reply to topic    Exchange Server Forum Index -> Design All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




Windows Server Dedicated Servers
Contact Us
New Topics Powered by phpBB