Re: sql server2005 for a change in 3TB range

I've not done enough tests yet, but I currently believe rebuilding sqlserver indexes to be pretty much just as bad a myth as the oracle variety.

Sqlserver will probably scale to the level you suggest - there are probably some SAP installations quoted at around that size on the web that run mssql - but as with building any scalable application it requires that the developers and designers know the architecture. Peter is quite right to point out that to anyone coming from an Oracle background the need to think about locking in the design of your application is a bit weird - conversely for people coming from a sqlserver background the idea of thinking about how to ensure that your sql doesn't trash the shared pool is rather weird.

On Nov 9, 2007 10:39 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:

> 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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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