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.

Mounting a large database slow

2 posts in General Discussion Last posting was on 2012-01-06 03:26:11.0Z
Luis Andrei Cobo Posted on 2012-01-05 16:28:09.0Z
Sender: 2fd3.4f05bd59.1804289383@sybase.com
From: Luis Andrei Cobo
Newsgroups: sybase.public.ase.general
Subject: Mounting a large database slow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f05cf99.3410.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Jan 2012 08:28:09 -0800
X-Trace: forums-1-dub 1325780889 172.20.134.41 (5 Jan 2012 08:28:09 -0800)
X-Original-Trace: 5 Jan 2012 08:28:09 -0800, 172.20.134.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30813
Article PK: 73701

I have a new installation of 15.7 on Windows XP Pro. I have
a Device of 100gb and made a 50gb Database within it. Why is
it every time the database is stopped and started it takes
an enormous amount of time to start that one database? It is
on FULL durability, but I read that once it loads, it
creates a checkpoint so that it won't have to run recovery
every time the database starts up normally, yet it seems to
be running something for an exceptionally long time when
starting up that particular database, which I'm assuming is
Recovery. Any ideas how to just mount that database straight
away? Or is that even possible?

Thanks!


Manish Negandhi [TeamSybase] Posted on 2012-01-06 03:26:11.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.ase.general
References: <4f05cf99.3410.1681692777@sybase.com>
Subject: Re: Mounting a large database slow
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f0669d3@forums-1-dub>
Date: 5 Jan 2012 19:26:11 -0800
X-Trace: forums-1-dub 1325820371 10.22.241.152 (5 Jan 2012 19:26:11 -0800)
X-Original-Trace: 5 Jan 2012 19:26:11 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30816
Article PK: 73707

You might want to see what is going on during recovery using DBCC
SHOWRECOVERY command.

-HTH
Manish Negandhi
[TeamSybase]

<Luis Andrei Cobo> wrote in message
news:4f05cf99.3410.1681692777@sybase.com...
>I have a new installation of 15.7 on Windows XP Pro. I have
> a Device of 100gb and made a 50gb Database within it. Why is
> it every time the database is stopped and started it takes
> an enormous amount of time to start that one database? It is
> on FULL durability, but I read that once it loads, it
> creates a checkpoint so that it won't have to run recovery
> every time the database starts up normally, yet it seems to
> be running something for an exceptionally long time when
> starting up that particular database, which I'm assuming is
> Recovery. Any ideas how to just mount that database straight
> away? Or is that even possible?
>
> Thanks!