Re: Scenario

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 04/26/04

  • Next message: Theo Jones: "Re: Unable to view drives" 
    Date: Mon, 26 Apr 2004 14:12:15 -0400

    2 web and 1 database is probably a good starting config. I understand
    limited budget, but you may need to point out to management that they will
    be limiting functionality, availability, and performance by limiting the
    budget. As long as you have made them aware of the tradeoffs, you have done
    your job. 

    -- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Johan" <johan@hakksor.mine.nu> wrote in message
news:%23eGFMg7KEHA.624@TK2MSFTNGP11.phx.gbl...
> The SQL-server will only be accessed by the webservers for the webapps. I
> won't be storing any other data in there.
>
> So you would suggest 2 low-end webservers and 1 a little bit more high-end
> SQL?
> Money is very limited... so the cheaper, the better.
>
> "Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
> news:eMgjHFtKEHA.1764@TK2MSFTNGP12.phx.gbl...
> > One, I would separate your web and app servers.  I would go with a
couple
> of
> > lower-end web servers so you have redundancy because you will need to
> > restart them from time to time.  The SQL server needs a decent storage
> > system and memory more than anything else.  You can always add another
web
> > server to deal with growth, but SQL upgrades are usually forklift
> upgrades.
> >
> >
> > -- 
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> >
> >
> > "Johan" <johan@hakksor.mine.nu> wrote in message
> > news:uhSr9UXKEHA.2244@tk2msftngp13.phx.gbl...
> > > Or maybe put the money for the second machine into the first.. to make
> one
> > > more powerful machine with a good RAID system.
> > >
> > > I'm still on the planning stage for this operation.
> > >
> > > "Johan" <johan@hakksor.mine.nu> wrote in message
> > > news:%23PPt8SXKEHA.2580@TK2MSFTNGP12.phx.gbl...
> > > > So what you would suggest, if all I can get are 2 machines, is to
have
> > one
> > > > machine running only SQL and one running only IIS?
> > > >
> > > > "Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
> > > > news:eOUyvOXKEHA.3436@tk2msftngp13.phx.gbl...
> > > > > Lower your expectations.
> > > > >
> > > > > Seriously, web servers generally make poor database servers and
vice
> > > > versa.
> > > > > If you want a common data store, you will need a dedicated machine
> for
> > > > SQL.
> > > > > If you want it to be highly available, you will need a clustered
> > > instance,
> > > > a
> > > > > highly trained staff, and a class A data center to keep it in.  If
> all
> > > you
> > > > > have are two web servers, you do noy have enough gear for a
> > SQL-centric
> > > > web
> > > > > farm.
> > > > >
> > > > > -- 
> > > > > Geoff N. Hiten
> > > > > Microsoft SQL Server MVP
> > > > > Senior Database Administrator
> > > > > Careerbuilder.com
> > > > >
> > > > > I support the Professional Association for SQL Server
> > > > > www.sqlpass.org
> > > > >
> > > > > "Johan" <johan@hakksor.mine.nu> wrote in message
> > > > > news:OtMjuQVKEHA.3216@tk2msftngp13.phx.gbl...
> > > > > > Consider the following scenario:
> > > > > >
> > > > > > I got 2 webservers (2003) using NLB.
> > > > > > I want some kind of common data store (SQL Server).
> > > > > > I need this data store to be fault tolerant.
> > > > > > I don't have any more machines.
> > > > > > I don't have an enterprise licence for windows.
> > > > > >
> > > > > > How do I solve this???
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
  • Next message: Theo Jones: "Re: Unable to view drives"

    Relevant Pages

    • Re: Data Loss?
      ... Is the application using Windows Authentication or SQL Server logins? ... -- "Geoff N. Hiten" wrote in message ... I was able to when the deleting took place,> and the SPID of the user or computer it came from, but apparently SPIDs> change so whoever had that number on the day the deletions occurred has a> different SPID now. ... >> Senior Database Administrator ...
      (microsoft.public.sqlserver.server)
    • Re: Maintenance PLan recommendation
      ... I support the Professional Association for SQL Server ... > I can definitely confirm that what Geoff is stating is true. ... the SQL Service account must have FULL CONTROL ... >>>Senior Database Administrator ...
      (microsoft.public.sqlserver.server)
    • Re: Share Database with 2 SQL Servers.
      ... Why would you need more than 900 bytes in an index key? ... Senior Database Administrator ... I support the Professional Association for SQL Server ... > -0400, Geoff N. Hiten wrote: ...
      (microsoft.public.sqlserver.clustering)
    • Re: Active/Active/Active without SAN
      ... Private assistance is known as "consulting" and is ... Microsoft SQL Server MVP ... >> Senior Database Administrator ... >>> would like to implement a fail safe SQL system. ...
      (microsoft.public.sqlserver.clustering)
    • Re: Cluster will not fail over.
      ... >> Try and run comclust.exe on each node to set MSDTC to cluster mode. ... >> Senior Database Administrator ... >> Microsoft SQL Server MVP ...
      (microsoft.public.sqlserver.clustering)