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.

zombi again

3 posts in Windows NT Last posting was on 2001-03-05 08:31:21.0Z
Andrey V. Kolchanov Posted on 2001-02-16 11:34:35.0Z
Sender: andrey@orion.int.fct.ru
Subject: zombi again
From: andrey@fct.ru (Andrey V. Kolchanov)
Date: 16 Feb 2001 14:34:35 +0300
Message-ID: <m3g0hec14k.fsf@orion.int.fct.ru>
Lines: 13
User-Agent: Gnus/5.0807 (Gnus v5.8.7) XEmacs/21.2 (Persephone)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: FCT Ltd
Cache-Post-Path: gatekeeper.fct.ru!unknown@orion.int.fct.ru
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: gatekeeper.fct.ru 212.113.103.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1215
Article PK: 1088689

Hi all.

We often have locks on killed "zombi" process, and then we have to
reboot server.
Locks are held on user (not tempdb) databases.
Does exists any solutions or recomendations?

@@version:
Adaptive Server Enterprise/11.9.2.3/1156/P/SWR 9160 ESD 2/NT (IX86)/OS 3.51,4.0/FBU/Thu Jul 27 05:46:21 2000


--
~= Andrey V. Kolchanov =~


Mark Posted on 2001-03-01 15:10:56.0Z
From: Mark
Date: Thu, 1 Mar 2001 10:10:56 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: zombi again
Message-ID: <97F2FAD03BE29A110053664985256A02.0012E045852569FB@webforums>
References: <m3g0hec14k.fsf@orion.int.fct.ru>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1164
Article PK: 1088618

Hi
I've seen lots of these. and as you say - rebooting does seem to be the
only solution although sometimes they will disappear after 2 or 3 hours!

One thing - are the tables the locks are being held on badly fragmented?


Andrey V. Kolchanov Posted on 2001-03-05 08:31:21.0Z
Sender: andrey@orion.int.fct.ru
Subject: Re: zombi again
References: <m3g0hec14k.fsf@orion.int.fct.ru> <97F2FAD03BE29A110053664985256A02.0012E045852569FB@webforums>
From: andrey@fct.ru (Andrey V. Kolchanov)
Date: 05 Mar 2001 11:31:21 +0300
Message-ID: <m33dcs1usm.fsf@orion.int.fct.ru>
Lines: 10
User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.2 (Persephone)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: FCT Ltd
Cache-Post-Path: gatekeeper.fct.ru!unknown@orion.int.fct.ru
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: gatekeeper.fct.ru 212.113.103.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1156
Article PK: 1088650

Mark writes:

> Hi
> I've seen lots of these. and as you say - rebooting does seem to be the
> only solution although sometimes they will disappear after 2 or 3 hours!
>
> One thing - are the tables the locks are being held on badly fragmented?

How can I see table fragmentation?
--
~= Andrey V. Kolchanov =~