Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Drop Index taking long time to finish

0 views
Skip to first unread message

Nishant Rupani

unread,
Jun 26, 2007, 8:57:59 AM6/26/07
to
Hi All,

I have two ASE servers - SRV_1 (Unix) & SRV_2 (Linux). Configuration
of these two ASE servers are exactly similar as far as I know. But
there is a "drop index" command that is showing huge time difference
between these servers.

In SRV_1 (Unix) it's taking few seconds but in SRV_2 (Linux) it's
taking 40-60 min to execute. There was no lock on the table when the
command was being executed.

Can you all please help me out with the possible reasons behind this?

Regards,
Nishant

Jason L. Froebe

unread,
Jun 26, 2007, 9:05:48 AM6/26/07
to
Nishant Rupani wrote:

Hi Nishant,

Which versions of each server? Are these being written to a raw partition?
Number of locks, objects, indexes, etc are sufficient
(sp_monitorconfig 'all')? etc.
--
Jason L. Froebe

Froebe Fibers http://www.froebe-fibers.com
WebBlog http://jfroebe.livejournal.com
Tech log http://www.froebe.net/blog

Nishant Rupani

unread,
Jun 27, 2007, 7:12:00 AM6/27/07
to
SRV_1 (Unix)
Adaptive Server Enterprise/12.5.3/EBF 13528 ESD#7 ONE-OFF/P/Sun_svr4/
OS 5.8/ase1253/1950/64-bit/FBO/Mon Apr 24 17:57:35 2006

SRV_2 (Linux)
Adaptive Server Enterprise/12.5.4/EBF 14124 ESD#4/P/x86_64/Enterprise
Linux/ase1254/2034/64-bit/OPT/Thu Nov 30 05:39:47 2006

Hi Jason L. Froebe / All,

My apologies to you all. There was a SELECT command going on on the
same table and was blocking the drop index command.

Regards,
Nishant

0 new messages