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.

ADS TMP File

2 posts in Networking Last posting was on 2007-11-29 21:58:02.0Z
Robert N. Harris Posted on 2007-11-28 11:09:06.0Z
Reply-To: "Robert N. Harris" <robertharris@arh.ie>
From: "Robert N. Harris" <robertharris@arh.ie>
Newsgroups: advantage.networking
Subject: ADS TMP File
Date: Wed, 28 Nov 2007 11:09:06 -0000
Lines: 10
Organization: ARH Software Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 86.43.120.1
Message-ID: <474d4b13@solutions.advantagedatabase.com>
X-Trace: 28 Nov 2007 04:03:47 -0700, 86.43.120.1
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.43.120.1
Xref: solutions.advantagedatabase.com Advantage.Networking:721
Article PK: 1132140

Hi,
Yesterday, a client advised me that their system was running very slow. I
connected, and found am ADS '.TMP' file was in the data directory with a
size in excess of 110GB. How can I avert this happening again, or is there
any clue as to why it happended in the first place??

Thanks for you help.
Rob.


Alex Wong (ADS) Posted on 2007-11-29 21:58:02.0Z
From: "Alex Wong \(ADS\)" <nobody@sybase.com>
Newsgroups: advantage.networking
References: <474d4b13@solutions.advantagedatabase.com>
Subject: Re: ADS TMP File
Date: Thu, 29 Nov 2007 14:58:02 -0700
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.219
Message-ID: <474f34ac@solutions.advantagedatabase.com>
X-Trace: 29 Nov 2007 14:52:44 -0700, 10.24.38.219
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.219
Xref: solutions.advantagedatabase.com Advantage.Networking:722
Article PK: 1132142

Hi Robert,

Does the file name begins with TIM? The likely cause of the .TMP file is
from someone executing an SQL statement. If a poorly constructed SQL
satement is exeucted, it could result in a very large file on the server and
consum a significant amount CPU time. You can find the SQL query that was
executing and the user who is executing the query via the remote server
management tool in ARC. You will then disconnect the user or cancel the
query if it is executed by mistake.

--
Alex

"Robert N. Harris" <robertharris@arh.ie> wrote in message
news:474d4b13@solutions.advantagedatabase.com...
> Hi,
> Yesterday, a client advised me that their system was running very slow. I
> connected, and found am ADS '.TMP' file was in the data directory with a
> size in excess of 110GB. How can I avert this happening again, or is there
> any clue as to why it happended in the first place??
>
> Thanks for you help.
> Rob.
>