Hi,I have a vb exe which ports data from sybase to sql after performing varouis validation ofn data and tranforms data on varoius parameter
This exe is scheuled for every 15 minutes for indefinete period
The exe normally takes around 2 mniutes to execute. But after running for a week or so, time taken t run the exe increase from 2 to 30 to 50 minutes.Once we shut down the server and restart the server it comes back to normal process time of 1.5 minutes to 2 miute
Can any body give anwers to this probelm.

Sounds like something is leaking resources. Check memory.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Hans" <gshivaram (AT) hotmail (DOT) com> wrote

minutes.Once we shut down the server and restart the server it comes back to
normal process time of 1.5 minutes to 2 miutes