Wednesday, March 7, 2012

Database maintainance

I am about to work with a database of approx 200GB on RAID5 volume. This database is very crutial and there should absolutly no/very less downtime. Since I've never worked so huge database and that too running on RAID 5. So can anyone help me in describing the steps or the check list to be prepared before working with its maintainance or may I be provided with cautions I supposed to takeHi Sunny.
If your database is crucial, then there will be many things you need to take
into consideration. Raid5 may be good enough, especially if your database is
read intensive but if the database is write intensive, (more inserts,
updates, deletes than selects) then raid5 is probably not the best choice as
raid10 will offer better write performance (costs more).
There are just so many issues that you need to consider when planning a
crucial database that need to be up all of the time. I suggest you at least
have a look at some of the good articles on Microsoft's website:
http://www.microsoft.com/sql/techinfo/administration/2000/default.asp
& good luck!
Regards,
Greg Linwood
SQL Server MVP
"Sunny" <anonymous@.discussions.microsoft.com> wrote in message
news:621B8B20-724A-4D31-AB80-7FEB66443B53@.microsoft.com...
> I am about to work with a database of approx 200GB on RAID5 volume. This
database is very crutial and there should absolutly no/very less downtime.
Since I've never worked so huge database and that too running on RAID 5. So
can anyone help me in describing the steps or the check list to be prepared
before working with its maintainance or may I be provided with cautions I
supposed to take.
>

No comments:

Post a Comment