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.

Tunning an I/O intensive database server

2 posts in Windows NT Last posting was on 1997-08-29 18:09:03.0Z
Jaime Barillas Posted on 1997-08-29 13:51:41.0Z
From: "Jaime Barillas" <barillas@gbm.net>
Subject: Tunning an I/O intensive database server
Organization: Banco Ahorromet
Message-ID: <01bcb48b$ab2f7840$292e6a64@jmbarillas.sal.gbm.net>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Fri, 29 Aug 1997 09:51:41 -0400
Lines: 12
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5564
Article PK: 1081640

We are migrating data from an old mainframe to a four Pentium 166Mz
processor, 256 Mb RAM, we've found that the new transactions take a lot of
I/O, more than CPU and memory, and ocassionally the server seems very slow.
The server is going to be an OLTP server, because of the kind of
transactions (actually we´re working on a transaction monitor, our business
is banking).
There is something we can tune on NT or Sybase to gain performance.
TIA


David Lance Wolf Posted on 1997-08-29 18:09:03.0Z
Message-ID: <3407103F.8DF3E05E@sybase.com>
Date: Fri, 29 Aug 1997 11:09:03 -0700
From: David Lance Wolf <dwolf@sybase.com>
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: Tunning an I/O intensive database server
References: <01bcb48b$ab2f7840$292e6a64@jmbarillas.sal.gbm.net>
Content-Type: multipart/mixed; boundary="------------3BA55113904382D9EA3753BF"
Newsgroups: sybase.public.sqlserver.nt
Lines: 39
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5563
Article PK: 1081639

Jamie-

Can you run a sp_sysmon and post it, or email it to me? That will help us
alot. There are a TON of things we can fiddle in SQL Server 11. The sp_sysmon
output will let us know where to start.

Dave Wolf
Sybase Professional Services.

Jaime Barillas wrote:

> We are migrating data from an old mainframe to a four Pentium 166Mz
> processor, 256 Mb RAM, we've found that the new transactions take a lot of
> I/O, more than CPU and memory, and ocassionally the server seems very slow.
> The server is going to be an OLTP server, because of the kind of
> transactions (actually we´re working on a transaction monitor, our business
> is banking).
> There is something we can tune on NT or Sybase to gain performance.
> TIA


Download VCard vcard.vcf