Re: Scheduling DTS job
From: Sam (anonymous_at_discussions.microsoft.com)
Date: 04/02/04
- Next message: Pete K.: "Missing rows from Transform - Intermittent Issue??"
- Previous message: Baisong Wei[MSFT]: "RE: DTS vs Query performance"
- Next in thread: Allan Mitchell: "Re: Scheduling DTS job"
- Reply: Allan Mitchell: "Re: Scheduling DTS job"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Apr 2004 18:57:30 -0800
hi!
How do i see if there is any difference in the driver
setup?
Thanks!
>-----Original Message-----
>Local System account has unrestricted access to the local
box and cannot see
>off that box.
>The day schedule took just as long as overnight right?
>
>Would this take as long "SQL Server to SQL Server"? i.e.
something in the
>driver setup
>
>--
>
>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>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
>
>
>"Sam" <anonymous@discussions.microsoft.com> wrote in
message
>news:f3cd01c41313$193708c0$a001280a@phx.gbl...
>> The SQL server agent is running as Local System Account.
>> I cannot log in as this account. Is this equivalent to
>> the local administrator? How can I simulate to run?
>>
>> I tried rescheduling during the day, and it took just as
>> long.
>> Nothing has been changed in sybase box.
>>
>> Thanks!
>> >-----Original Message-----
>> >OK so it can be FAST just not when scheduled.
>> >
>> >If that is the only difference then for me you have two
>> routes of
>> >investigation
>> >
>> >1. Accounts
>> >
>> >Log on to the server as the SQL Server Agent account
and
>> execute the
>> >package. Slow? Fast?
>> >
>> >2. Timings
>> >
>> >Can you one day reschedule to sometime in the day?
>> >Can you manually execute at the same time as the
>> overnight job?
>> >
>> >
>> >Is there anything going on the Sybase box
>> >
>> >--
>> >
>> >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> >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
>> >
>> >
>> >"Sam" <anonymous@discussions.microsoft.com> wrote in
>> message
>> >news:f2e001c412fa$00bc7050$a001280a@phx.gbl...
>> >> hi Allan,
>> >> In response to your questions:
>> >> 1. System board was changed in the box
>> >> 2. No.Its a job run at 7.30am, work has not started
yet.
>> >> 3. No one hammering the work. The fact is it is
running
>> >> perfectly alright and no changes has been made over
the
>> >> weeekend except for (1)
>> >> 4. Yes, package involved data transferred from
sybase to
>> >> this SQL server. There are locking when the process
>> >> started, which has never happened before. But i
suspect
>> >> it is due to the slow speed which causes the locking.
>> >> 5. the part where data is transferred from sybase
server
>> >> to this server, sql server. Total 12 tables, about 4
>> >> tables took a long time. but these 4 tables are not
big
>> >> tables.
>> >> 6. not known before.
>> >> 7. Slow whenever i run the job.
>> >>
>> >> I realise that if execute from the package level
(ie,
>> not
>> >> by scheduled job), it is FAST!
>> >> But once i run through scheduling, it is slow.
>> >> Why? Any thoughts?
>> >>
>> >> Thanks!
>> >> >-----Original Message-----
>> >> >There are a whole raft of things which may be
affecting
>> >> the performance.
>> >> >
>> >> >1. Anything changed on the box?
>> >> >2. Anybody doing something at the sme time?
>> >> >3. Does the job involve the network? Anybody
>> hammering
>> >> the network
>> >> >4. Does the package involve SQL Server? locking,
>> >> blocking?
>> >> >5. What parts of the package are taking the time
>> >> >6. Resource issue? perfmon.
>> >> >7. Does this only slow down at this time of the
day or
>> >> is it slow whenever
>> >> >you run it now?
>> >> >
>> >> >--
>> >> >
>> >> >----------------------------
>> >> >
>> >> >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server
MVP)
>> >> >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
>> >> >
>> >> >
>> >> >"sam" <anonymous@discussions.microsoft.com> wrote in
>> >> message
>> >> >news:12f1a01c41216$191d0810$a301280a@phx.gbl...
>> >> >> hi!
>> >> >> Recently my scheduled DTS job slowed down
>> drastically.
>> >> >> Normally it is a 2-3 mins job, but now it took
about
>> 1
>> >> hr.
>> >> >>
>> >> >> Can anyone suggest how can i do troubleshooting
and
>> >> where
>> >> >> can i start from?
>> >> >> Need advice.
>> >> >>
>> >> >> Thanks!
>> >> >>
>> >> >> Rgds,
>> >> >> Samuel.
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: Pete K.: "Missing rows from Transform - Intermittent Issue??"
- Previous message: Baisong Wei[MSFT]: "RE: DTS vs Query performance"
- Next in thread: Allan Mitchell: "Re: Scheduling DTS job"
- Reply: Allan Mitchell: "Re: Scheduling DTS job"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
