Re: SQL or MSDE on a DC?
From: Liz (liz_at_tiredofspam.com)
Date: 05/12/04
- Next message: Sue Hoegemeier: "Re: Taskpad View in Enterprise Mgr"
- Previous message: chris: "when could this restore scenario happen"
- In reply to: HelpPls: "SQL or MSDE on a DC?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 May 2004 22:47:52 -0500
"HelpPls" <smd6169@hotmail.com> wrote in message
news:#JO9Cv7NEHA.1196@TK2MSFTNGP11.phx.gbl...
> I am running a small shop where we have a dual XEON (1) 2003 Standard
Server
> serving as our DC, File & Print and DNS server. We have the opportunity
to
> upgrade to an application we currently use but it will require us to
install
> SQL 2000 or MSDE on this server. My question is this, can SQL 2000 or
MSDE
> exist on the same box?
>
> Thanks - Sean
not enough information, Sean ... RAM ? disk array ? XEON what ? # users ?
typical activity on SQL/other ? you could certainly look at Perfmon for a
while and see how much of the box is being used right now; that'd give you
some indication ... in the end, you can load it all up and if it doesn't
work, you can shop the secondary market for an older box to run SQL 2K; you
can probably find a dual P3 500-600mhz with 1gb for under $1000 and it would
handle a LOT of SQL activity ...
the obvious problem with "trying it out" is if it doesn't work you could put
a real crimp in your business activity while you sort it all out; you can
shut down SQL2K easiliy enough but then you have to reinstall on the 2nd box
...
for example:
http://www.itxchange.com/itxchange/product.asp?category=68000000&find%5Floca
tion=WEB%5FALL%5FLOCATIONS&part%5Fno=100738%2D003%2DG0DA2%2D06&find%5Fcatego
ry=01%2E1&find%5Fdescription=Server+%2D+Pentium+III&find%5Fpart%5Fdesc=&find
%5Fpart%5Fdesc2=&find%5Fpart%5Fdesc3=&find%5Fpart%5Fdesc4=&find%5Fpart%5Fdes
c5=&find%5Fpart%5Fdesc6=&search=multi
Proliant 5500 (refurb), 2 XEON P3 550mhz, 2GB RAM, open bay $423; you need
disks .. refurb 18.2 gb UltraWide SCSI 2/3 go for around $60-100 ... that
still makes for a very nice, very serviceable machine; if you're allergic
to refurbs or have to have the latest processor, get the checkbook out ;)
- Next message: Sue Hoegemeier: "Re: Taskpad View in Enterprise Mgr"
- Previous message: chris: "when could this restore scenario happen"
- In reply to: HelpPls: "SQL or MSDE on a DC?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
