Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

What Does System 11 Like Better

4 posts in Windows NT Last posting was on 2000-02-25 16:32:39.0Z
Ted Ghinea Posted on 2000-02-24 19:58:56.0Z
From: "Ted Ghinea" <tghinea@anteon.com>
Subject: What Does System 11 Like Better
Date: Thu, 24 Feb 2000 14:58:56 -0500
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <phaSnIwf$GA.201@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 128.190.154.220
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2504
Article PK: 1089958

In an Nt Environment, what does System 11 like for better performance:

More RAM

Processor Speed

Mult-Processors

Multi Disk (RAID 5)

Thanks


AnaMaria Stirbet Posted on 2000-02-25 16:32:39.0Z
Message-ID: <38B6AEA7.16978178@sybase.com.no.spam>
Date: Fri, 25 Feb 2000 11:32:39 -0500
From: AnaMaria Stirbet <astirbet@sybase.com.no.spam>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: What Does System 11 Like Better
References: <phaSnIwf$GA.201@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 9
NNTP-Posting-Host: astirbet-pc.sybase.com 172.31.140.205
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2499
Article PK: 1089951

Hi Ted,

All the above being said, in most cases on NT I recommend more RAM.

Toate cele bune,

AnaMaria Stirbet
Sybase TS

Ted Ghinea wrote:

> In an Nt Environment, what does System 11 like for better performance:
>
> More RAM
>
> Processor Speed
>
> Mult-Processors
>
> Multi Disk (RAID 5)
>
> Thanks


Bret Halford Posted on 2000-02-24 21:32:56.0Z
Message-ID: <38B5A388.8467B7F4@sybase.com>
Date: Thu, 24 Feb 2000 14:32:56 -0700
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en,ja
MIME-Version: 1.0
Subject: Re: What Does System 11 Like Better
References: <phaSnIwf$GA.201@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 11
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2503
Article PK: 1089955

Hi Ted,

There is no simple answer to this. Different applications and starting
configurations
will have different bottlenecks, and time spent analyzing the current
situation will
be well worth it.

-bret

Ted Ghinea wrote:

> In an Nt Environment, what does System 11 like for better performance:
>
> More RAM
>
> Processor Speed
>
> Mult-Processors
>
> Multi Disk (RAID 5)
>
> Thanks


Gary Estridge Posted on 2000-02-25 01:52:53.0Z
From: "Gary Estridge" <aaaa@aaaa.com>
References: <phaSnIwf$GA.201@forums.sybase.com>
Subject: Re: What Does System 11 Like Better
Date: Thu, 24 Feb 2000 20:52:53 -0500
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <7XVomOzf$GA.265@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 240.orlando-13-14rs.fl.dial-access.att.net 12.77.197.240
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2502
Article PK: 1089956

To really know the answer to that question you need to spend some time
looking at the performance of your server while it is in action. Look at
the online sybooks for sp_sysmon and then in the performance and tuning
manual which will help you interpret the results.

As an example if your server under load has the CPU's running between 50%
to 75% (occasional spikes to 100% is ok) then you probably have enough CPU's
for the current activity level, if higher then adding another processor
would be beneficial. If the usage is lower then you have more CPU then is
optimally needed (money could have better been spent elsewhere if money was
tight).

If your cache hit rates are low, like less then 80% for any of them, then
either more memory would be beneficial, or changing how the memory is used
like adding named caches etc.

If your SP_Sysmon reports show your having IO contention then spreading your
devices over more physical drives or portioning would probably help.

So as you can see, it all really depends on what is happening on your
particular server when it is in use. The more you get to know the tools
available to monitor what is happening, the better you can fine tune the
server to get peak performance out of it.

"Ted Ghinea" <tghinea@anteon.com> wrote in message
news:phaSnIwf$GA.201@forums.sybase.com...
> In an Nt Environment, what does System 11 like for better performance:
>
> More RAM
>
> Processor Speed
>
> Mult-Processors
>
> Multi Disk (RAID 5)
>
> Thanks
>
>