dbTalk Databases Forums  

Re: Slowness

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Re: Slowness in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Slowness - 02-12-2004 , 01:32 AM






And what do the packages do?
Have you looked at perfmon?,
does it involve moving stuff across the network?
Slow logon?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Keith" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have several DTS packages that have been copied to several different
servers that are all showing the same problem. The problem is that when the
package is first kicked off it does nothing for the first 40-50 seconds than
the first task is kicked off and the package finishes in a second or less.
The packages in question have not changed for a couple of months now, but
this started happening on the same day for all servers. The problem happens
when run manually or if run through a job or through DTSRun.
Quote:
Has anyone seen a similar problem? Thanks in advance



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.