Re: sql server2005 for a change in 3TB range
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: Peter McLarty <peter.mclarty@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 9 Nov 2007 10:39:08 +0000 (GMT)
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@xxxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
