QUESTION: For SQL Server UNIX or NT ?

QUESTION: For SQL Server UNIX or NT ?

Post by Branda Didie » Sat, 20 Sep 1997 04:00:00



Actually we have a database under HP UX (HP Unix)

Our development department would like to change for NT.

What do you think about it ?

Thanks bye avance.

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Andy Housem » Sat, 20 Sep 1997 04:00:00


We were faced the same choice between Sun Solaris and NT.  I put a similar
question out last year and got a response that was slightly in favor of
keeping Solaris.

My feeling:  the devil you know is better than the devil you don't know.
We kept Solaris (but we did upgrade the hardware from a Sparc 10 to an
Ultraserver 1).  Haven't had any problems.

-- Andy Houseman
Systems Analyst
Horsley Bridge Partners



> Actually we have a database under HP UX (HP Unix)

> Our development department would like to change for NT.

> What do you think about it ?

> Thanks bye avance.


 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Oscar Mack Jr » Sat, 20 Sep 1997 04:00:00


I've used both products, and by-and-large :

the Sybase documentation for NT is not sufficient for the job (registry and
services issues)

The NT scheduler is not as robust as Unix cron.

Sybperl is not available on NT.

Sybase is forced to use ordinary files on NT versus raw partitions available
under Unix.

However,

NT is cheaper and the NT client environment is friendlier

Hope that helps......

Oscar Mack

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Mike » Sun, 21 Sep 1997 04:00:00


We are a HP-UX/Sybase site principally because we understand that Sybase
develop on HP hence fixes/enhancements AND support for the HP platform come
before any other OS.

Concerning NT in particular, my personal opinion is it's great for clients,
but when it comes to Mission Critical servers, I would rather Microsoft
iron out the reliability issues before I'll commit my customer's 7X24
operation to it!

Mike Renshaw, Toronto Star Newspapers Limited.



Quote:> Actually we have a database under HP UX (HP Unix)

> Our development department would like to change for NT.

> What do you think about it ?

> Thanks bye avance.

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Tom Smit » Tue, 23 Sep 1997 04:00:00



> We are a HP-UX/Sybase site principally because we understand that Sybase
> develop on HP hence fixes/enhancements AND support for the HP platform come
> before any other OS.

Gee...that's funny...all of us Solaris people think Sybase codes first
on Solaris and then ports to HP-UX et al....therefore, Solaris fixes and
enhancements should be first in the EBF pipeline.  I think this was the
case prior to System 10, but who knows now?  Pablo?  Bret?  Teresa?

TJ

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Pablo Sanch » Tue, 23 Sep 1997 04:00:00




> > We are a HP-UX/Sybase site principally because we understand that Sybase
> > develop on HP hence fixes/enhancements AND support for the HP platform come
> > before any other OS.

> Gee...that's funny...all of us Solaris people think Sybase codes first
> on Solaris and then ports to HP-UX et al....therefore, Solaris fixes and
> enhancements should be first in the EBF pipeline.  I think this was the
> case prior to System 10, but who knows now?  Pablo?  Bret?  Teresa?

I'm not sure how the fixes get rolled out per platform basis.  

We already have an alpha of 11.5 like the other platforms.  We're
playing with it and trying to break it...  there are benefits to
being on the cutting edge and not... I think nowadays every major
platform comes out pretty much at the same time...
--

--------------+-----------------+--------------------------------------------

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Teresa Lars » Tue, 23 Sep 1997 04:00:00


: >
: > We are a HP-UX/Sybase site principally because we understand that Sybase
: > develop on HP hence fixes/enhancements AND support for the HP platform come
: > before any other OS.
:
: Gee...that's funny...all of us Solaris people think Sybase codes first
: on Solaris and then ports to HP-UX et al....therefore, Solaris fixes and
: enhancements should be first in the EBF pipeline.  I think this was the
: case prior to System 10, but who knows now?  Pablo?  Bret?  Teresa?

Well, Bret and Pablo are the best sources to know for sure, but I too
was always under the impression that Sun was the primary (for lack of
a better word) platform.  But that was back in the *old* SunOS days. :-)

I do remember Sybase executives talking about this at one of their
presentations at an ISUG conference a couple of years back.  It was
regarding all the quality control issues that had everyone up in arms.
I remember a statement to the effect that releases would be done at
the same time for all the platforms so that everyone would be at the
same bug level :-)  and that does, indeed, seem to be the case.

Not exactly a hard core answer, but that's my 2 cents.

                                Teresa Larson

     _________________________________________________________________
    /  Teresa A. Larson                 http://www2.ari.net/jmasino/ /
   /  Bell Atlantic                          Voice: (301) 282-0224  /
  /  13100 Columbia Pike, A-3-3              Fax:   (301) 282-9416 /

/________________________________________________________________/
                      #include <std_disclaimer>

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Al Bleds » Tue, 23 Sep 1997 04:00:00


: >
: > We are a HP-UX/Sybase site principally because we understand that Sybase
: > develop on HP hence fixes/enhancements AND support for the HP platform come
: > before any other OS.
: >

: Gee...that's funny...all of us Solaris people think Sybase codes first
: on Solaris and then ports to HP-UX et al....therefore, Solaris fixes and
: enhancements should be first in the EBF pipeline.  I think this was the
: case prior to System 10, but who knows now?  Pablo?  Bret?  Teresa?

The waterloo people do the workplace ports of sybase to NT. They seem
to be out in front on the 11.5 release.

You can do raw devices with NT. Create a partition but don't format
it. Specify the drive name as the device. Have to use all of device,
and you can only have 4 partitions per drive, at least with 3.51.

"Sybase Server" 2nd Quarter 1997 had an article by Jim Barrett from
Compaq on ASE 11.5 for NT showing use of raw devices. ( But, Jim,

comparisons or reliability factors between NTFS and raw devices.)

I have only been working with Sybase on NT since MAY. Despite
upgrade problems from 10 to 11, uptime is incredible, to my
own surprise. I just installed a Compaq 6000 with 2 Smart-2
Arrays configured Raid 10 across six drives on each controller,
only 4 meg battery backed up cache. Phenominal perf!

The Enterprise 450 was going to be my preference for consolidation,
now, I am rreally having some second thoughts.

Al
( Still hate NT, but, U/WIN 1.3 is helping.)

: TJ

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Eoin Woo » Tue, 23 Sep 1997 04:00:00




> > We are a HP-UX/Sybase site principally because we understand that Sybase
> > develop on HP hence fixes/enhancements AND support for the HP platform come
> > before any other OS.

> Gee...that's funny...all of us Solaris people think Sybase codes first
> on Solaris and then ports to HP-UX et al....therefore, Solaris fixes and
> enhancements should be first in the EBF pipeline.  I think this was the
> case prior to System 10, but who knows now?  Pablo?  Bret?  Teresa?

There are five "primary" platforms:-

        Solaris, HPUX, AIX, Dec Unix and NT.

All of these platforms are treated as equal for release/support purposes
(although perhaps Solaris and NT are sometimes a little "more equal than the
others"! ;-)

Eoin.
--
Eoin Woods, Watford, Hertfordshire, WD1 1PD, UK

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Mike » Wed, 24 Sep 1997 04:00:00


Wasn't Solaris the LAST OS to be converted from 4.x?



> > We are a HP-UX/Sybase site principally because we understand that
Sybase
> > develop on HP hence fixes/enhancements AND support for the HP platform
come
> > before any other OS.

> Gee...that's funny...all of us Solaris people think Sybase codes first
> on Solaris and then ports to HP-UX et al....therefore, Solaris fixes and
> enhancements should be first in the EBF pipeline.  I think this was the
> case prior to System 10, but who knows now?  Pablo?  Bret?  Teresa?

> TJ

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Lyle Gr » Wed, 24 Sep 1997 04:00:00


: I do remember Sybase executives talking about this at one of their
: presentations at an ISUG conference a couple of years back.  It was
: regarding all the quality control issues that had everyone up in arms.
: I remember a statement to the effect that releases would be done at
: the same time for all the platforms so that everyone would be at the
: same bug level :-)  and that does, indeed, seem to be the case.

Well, since it took them almost a full year to release Sybase XI on
OpenVMS for Alpha, I guess that "same bug level" referred to the
various flavors of UNIX... ;-)

Lyle
--
------------------------------------------------------ NON ANIMAM CONTINE

--(My opinions are my own, and do not represent my employer's opinions)--

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Anthony Mandi » Thu, 25 Sep 1997 04:00:00



> You can do raw devices with NT. Create a partition but don't format
> it. Specify the drive name as the device. Have to use all of device,
> and you can only have 4 partitions per drive, at least with 3.51.

        Amazing! And I thought it couldn't be done. But then again,
        I thought NT didn't do async I/O.

> "Sybase Server" 2nd Quarter 1997 had an article by Jim Barrett from
> Compaq on ASE 11.5 for NT showing use of raw devices. ( But, Jim,

> comparisons or reliability factors between NTFS and raw devices.)

        Have you tested it yourself?

Quote:> I have only been working with Sybase on NT since MAY. Despite
> upgrade problems from 10 to 11, uptime is incredible, to my
> own surprise. I just installed a Compaq 6000 with 2 Smart-2
> Arrays configured Raid 10 across six drives on each controller,
> only 4 meg battery backed up cache. Phenominal perf!

> The Enterprise 450 was going to be my preference for consolidation,
> now, I am rreally having some second thoughts.

        Thats funny, I'm trying to ween people here over to the 450
        from Nevell Notware!

-am

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Anthony Mandi » Thu, 25 Sep 1997 04:00:00




> > We are a HP-UX/Sybase site principally because we understand that Sybase
> > develop on HP hence fixes/enhancements AND support for the HP platform come
> > before any other OS.

> Gee...that's funny...all of us Solaris people think Sybase codes first
> on Solaris and then ports to HP-UX et al....therefore, Solaris fixes and
> enhancements should be first in the EBF pipeline.  I think this was the
> case prior to System 10, but who knows now?  Pablo?  Bret?  Teresa?

        I thought Solaris was first too. But who knows. I thought
        I read once in one of Sybase's tech newsletters how it worked,
        and the relationship to the EBF numbers (it varies by platform).
        But one of the latest sic_returns from Sybase seems to
        confuse the issue. Here's a summary from the email I got -

        EBF     Date Avail.     Platform
        7302    9/15/97         Digital UNIX
        7303    9/11/97         HP
        7304    9/11/97         AT&T
        7305    10/31/97        Windows NT
        7306    10/31/97        DEC Alpha NT
        7308    9/11/97         IBM RS6000
        7309    9/30/97         SCO Openserver
        7310    9/11/97         Sequent
        7311    9/11/97         SGI
        7312    9/11/97         Solaris
        7313    9/30/97         SCO Unixware

        This was for 11.0.3.1. So go figure. Certainly HP
        had the earliest release for 11.0.3 (8/27/97).

-am

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Al Bleds » Fri, 26 Sep 1997 04:00:00


: >
: > You can do raw devices with NT. Create a partition but don't format
: > it. Specify the drive name as the device. Have to use all of device,
: > and you can only have 4 partitions per drive, at least with 3.51.

:       Amazing! And I thought it couldn't be done. But then again,
:       I thought NT didn't do async I/O.

: > "Sybase Server" 2nd Quarter 1997 had an article by Jim Barrett from
: > Compaq on ASE 11.5 for NT showing use of raw devices. ( But, Jim,

: > comparisons or reliability factors between NTFS and raw devices.)

:       Have you tested it yourself?

I did install some databases on raw devices. But, I had to reconfigure
the system for Platinum support on the current release we are using.
So, I couldn't test what I was asking Jim about.

I am not sure of the advantage. The Sybase 10 installations are crashing
due to read defer errors, and we have had power outages that Power-chute
didn't catch due to serial cables getting unplugged. Always a
resilient restart! (One time, though, drive names got remapped, after
someone installed anti-virus software off a CD. E: was F: and G:
was H: -- a lot of databases flagged suspect. Some of that
Windows-Not showing through...) Everything in production is NTFS
with async I/O.
: > I have only been working with Sybase on NT since MAY. Despite
: > upgrade problems from 10 to 11, uptime is incredible, to my
: > own surprise. I just installed a Compaq 6000 with 2 Smart-2
: > Arrays configured Raid 10 across six drives on each controller,
: > only 4 meg battery backed up cache. Phenominal perf!
: >
: > The Enterprise 450 was going to be my preference for consolidation,
: > now, I am rreally having some second thoughts.

:       Thats funny, I'm trying to ween people here over to the 450
:       from Nevell Notware!

: -am

 
 
 

QUESTION: For SQL Server UNIX or NT ?

Post by Anthony Mandi » Tue, 30 Sep 1997 04:00:00



> :       Have you tested it yourself?

> I did install some databases on raw devices. But, I had to reconfigure
> the system for Platinum support on the current release we are using.
> So, I couldn't test what I was asking Jim about.

        If I have the opertunity, I might test it myself. Is anyone
        else willing to try it and report their findings?

Quote:> I am not sure of the advantage.

        Apart from reclaiming some space that would otherwise be taken
        by the filesystem, I can't think of any others.

Quote:> The Sybase 10 installations are crashing due to read defer errors,
> and we have had power outages that Power-chute
> didn't catch due to serial cables getting unplugged. Always a
> resilient restart!

        I know that some of the NT guys here were complaining that
        NT interpreted the Powerchute serial cable as a mouse cable
        and were forced to unplug it for that reason.

Quote:> (One time, though, drive names got remapped, after
> someone installed anti-virus software off a CD. E: was F: and G:
> was H: -- a lot of databases flagged suspect. Some of that
> Windows-Not showing through...)

        :-(

-am

 
 
 

1. Tools Oracle on UNIX/NT + SQLServer on NT + Tools for UNIX/NT(system)

Hi!

I  am looking for a combined tool(s) for Oracle on Unix (Sequent) + NT,
SQLServer and tools for the performance/capacity planning on Unix and
NT. They must also been able to send/receive SNMP traps.
So if anybody has experience or knows a good (combined) tool for these
products, please let me know.

Thanks
Paul

2. Bloating Data !!

3. One Instance of App Only

4. OH-COLUMBUS-50088--ORACLE-MS SQL Server-UNIX-Windows NT-MS Office-Client/Server-

5. Few Events, Few Dates and a Tough Query to write.

6. INGRES manuals - machine readable.

7. 22715-GA-ATLANTA-UNIX-Windows NT-ORACLE-Quality Project Manager, Unix, NT, Oracle DDL, DLM

8. NT SQL Server remote connection to Sun server questions

9. BCP UNIX file into NT SQL Server