Re: sql server2005 for a change in 3TB range

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Fri, 9 Nov 2007 10:39:08 +0000 (GMT)
Message-ID: <707525.36149.qm@web27806.mail.ukl.yahoo.com>

Hi Peter

I appreciate your inputs very much.

Yep this is a transactional web enabled database.

rebuilding indexes hmm..

regards
Hrishy
--- Peter McLarty <peter.mHi
clarty_at_pacificdbms.com.au> wrote:

> Its not that it is impossible, but if I was going to
> do it I would
> firstly have GOLD support with MS, because when
> things go wrong you
> might just wish you had it.
> You need a very well architected application, that
> is written to handle
> the idiosyncrasies of SQL Server locking, or you
> will constantly have
> issues with it. There is a new feature called read
> consistent snapshot
> that I would recommend, that should alleviate it
> somewhat.
> You will need to provide a fair amount of TLC if
> this is a frequently
> changing database to keep it running optimal,
> rebuilding indexes,
> amongst other tasks. You may not be able to run
> maintenance tasks during
> normal hours due to their impact on the system.
> You will want quality backup tools for the restores,
> quick efficient and
> reliable.
>
> If this is to use for a DW with all the above
> caveats you should be ok,
> for a transactional DB I am not sure I would want to
> go there
>
> Cheers
>
> Peter
>
> On Thu, 2007-11-08 at 10:50 +0000, hrishy wrote:
>
> > Hi
> >
> > I know this is a oracle mailing lists but just
> wanted
> > opinion from folks here if your environments hosts
> any
> > Terrabyte DB on Sqlserver 2005.
> >
> > regards
> > Hrishy
>
>
>
> >
> >
>

---

Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 09 2007 - 04:39:08 CST