Re: NT server, pro/con
Posted in 1995
Topics: Performance & Tuning, Stored Procedures & SPL, Server Administration, Platform-Specific Issues
In article <D4668H.H9K@world.std.com>, <shf@world.std.com> writes: > Newsgroups: comp.databases,comp.databases.oracle,comp.databases.sybase,comp.databases.progr ess,comp.databases.informix,comp.databases.ingres,comp.databases.pick,comp.data bases.ms-access > Path: interramp.com!psinntp!psinntp!sed.psrw.com!eff!news.duke.edu!zombie.ncsc.mil!ne ws.mathworks.com!uunet!world!shf > From: shf@world.std.com (Stephen H Fick) > Subject: NT server, pro/con > Message-ID: <D4668H.H9K@world.std.com> > Summary: Seeking NT server pro/con dimensions > Keywords: NT, server > Organization: The World Public Access UNIX, Brookline, MA > Date: Sat, 18 Feb 1995 00:19:29 GMT > Lines: 20 > Xref: interramp.com comp.databases:7707 comp.databases.oracle:14263 comp.databases.sybase:8837 comp.databases.progress:296 comp.databases.informix:6286 comp.databases.ingres:4340 comp.databases.pick:3616 comp.databases.ms-access:14606 > > While working on an assignment to choose a database product, > I've just been asked to look into using an NT server > rather than a Sun Solaris 2.x server. > > I'm interested in hearing people's evaluation of the merits > and demerits of an NT server in a server/client RDB > environment. Speed, reliability, security, expandability, > ease of learning the system administration work, ease of > performing it--talking here about the NT side of things, > not the RDB side--are obvious areas of concern. Are there > others? How does NT stack up, to date? > > As you may have deduced, I have plenty of Unix experience, > none with NT. > > Will be glad to post a summary, or to forward to individual > responders. > > Tia, > Steve Reliability: I have been running OR7 under windows NT for about 1 year (7.0.16). The Only problem we have is with stored procedures. Sometimes after we recompile the database shuts down. Mostly I think it's something we have been doing wrong. It also runs out of virual memory for no apparent reason sometimes. There are some added worries about device drivers and how well they are tested, a bad device driver can cause strange things to happen under NT. Backup packages are OK, ArcServe Should be available under NT shortly and that will improve the situation. Expandibility: You can get SMP machines that run NT with up to 16+ processors, As far as I know RAM is 1 gig, and hard drive space is what ever you can stick on. Performance: Pretty good, Better than netware (for application serving not file serving) when you use two processors. Disk access is pretty much limited to SCSI II. Not very many drivers for the SCSI III or better disk interfaces. Security: Good, but Oracle and NT security are not integrated like on some platforms. ie Netware, UNIX. System Administrator / Ease of use: Documentation sucks, but if you have ever used windows you can get around the administrative functions. Once NT is up, there is almost nothing to do but watch it run. All utilities are point and click and pretty much work like they are supposed to. Any more questions, just drop a line. Shawn. :)