Re: E2K7 SP1 Configuring Storage

On Wed, 17 Dec 2008 12:12:00 -0800, -harri
<harri@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Mark

Thank you for all your responses. I have an important conf call tomorrow
and I am prepared.

But, I could not find anything on the Inet to how storage groups were
organized. With E2K3, I organized databases according to groups, ie,
engineering has a db; sales and marketing a db but I am not sure if this is
the way to go with E2K7.

So any info you can provide on how NetApp has their databases or storage
groups organized would be so much appreciated.

And to all who responded many thanks and if you want to join in on this one,
I welcome any ideas!

-harri

On NetApp:
One Volume has one LUN in it and one database inside that LUN.
On Exchange:
One Storage Group contains one database.
Fifty databases (or five for Standard) per server

Put the SNAPINFO on the same LUN as the transaction logs. Yes, the
Logs volume & LUN needs to be larger than you might expect, unless of
course you're only keeping a couple of days worth of snaps.

It's irrelevant who you put inside the stores. One important thing
though is to spread out those BlackBerry users so you're not hammering
a set of logs.

Also, talk to NetApp about your aggregates. Old style best practices
call for two aggregates and for the logs and stores to be split, much
like traditional RAID. Under a lot of circumstances we no longer say
to split the aggregates. Logs and Stores can go on the same agg.
Benefits are that you get all that extra spindle performance but the
downside is that some people will be rolling the rosaries and
clutching their chest in mock shock.

If you want formal advice from NetApp just engage your partner. If
they need to engage a NetApp CSE and you're on the east coast then I
look forward to speaking to you!
.

Relevant Pages

  • Re: Question about Exchange Logs and DBs Best Practice
    ... Yes, even from 5.5 days, the primary reason you separate logs from databases ... For Exchange news, links and tips, check: ... > If you put ALL the databases in one RAID set, then if that one RAID set ...
    (microsoft.public.exchange2000.admin)
  • Re: Dirty Shutdown, VSS and time frame
    ... This is what SME does when you do a verification. ... THe restore process need at least the "required logs" and if you have "up ... contains the metadata for the exportable snapshot and the archived logs. ... In order to perform a restore you need the db lun, the log lun, and the ...
    (microsoft.public.exchange.admin)
  • Re: Disk Partitioning/RAID recommendations
    ... Probably the best thing you can do is to separate the databases and logs ... However, you may be tight for space on the mirror this way, so you could ... Repartitioning drives as we move from Exchange 2000 to ...
    (microsoft.public.exchange2000.setup.installation)
  • Sql server active/passive scenario
    ... We just bought a Netapp Fas 270 appliance. ... The plan I have in mind is to have all the system databases and the user ... I install sql 2000 on the first host with the ... the second host is supposed to have another sql server executable ...
    (microsoft.public.sqlserver.clustering)
  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... Yes, you are right, I read that Michelle is writing about logs not log, is ... there possibility that she looks at transaction logs on databases with full ... > You cannot set the recovery model in tempdb. ... >> We have at least two databases on this server in simple recovery model. ...
    (microsoft.public.sqlserver.server)