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.

data load taking long time

2 posts in Backup and Recovery Last posting was on 2001-03-09 02:01:49.0Z
jbuhl Posted on 2001-03-09 01:50:31.0Z
From: "jbuhl" <jbuhl@peerdigital>
Subject: data load taking long time
Date: Thu, 8 Mar 2001 18:50:31 -0700
Lines: 16
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: <5z4Xd3DqAHA.253@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 12.41.162.201
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:438
Article PK: 1060986

Hello,


We just got a requirement to benchmark our database to a size of 20GB. The
production db is on about 2GB. I make a 20 GB database on another server
and load the 2 GB database into it. It takes about the same time to load
but at the end the backupserver give a message of "load complete" but then
hangs out for about 20 minutes before it finaly lets go. The dataserver
process is churning 48% of 1 of 2 cpu's. Thats about the only thing running
on the box as well.

any idea's

Joe Buhl


Anthony Mandic <amandic Posted on 2001-03-09 02:01:49.0Z
Date: Fri, 09 Mar 2001 13:01:49 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: data load taking long time
References: <5z4Xd3DqAHA.253@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <aNvvz8DqAHA.301@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 15
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:437
Article PK: 1060985


jbuhl wrote:

> We just got a requirement to benchmark our database to a size of 20GB. The
> production db is on about 2GB. I make a 20 GB database on another server
> and load the 2 GB database into it. It takes about the same time to load
> but at the end the backupserver give a message of "load complete" but then
> hangs out for about 20 minutes before it finaly lets go. The dataserver
> process is churning 48% of 1 of 2 cpu's. Thats about the only thing running
> on the box as well.

It clearing pages not loaded or not in the original dump file.

-am © 2001