Re: Powerful server takes more than 30 minutes to run DTS package

Hi,

Can you tell if there is a way to save the results of perfmon and some ideas
as to the kind of things other than CPU, disk IO to monitor as we don't have
permission to run either of these utilities ourselves so will have to rely on
our clients IT team to it and send us the results.

Regards,
Peter

"jhofmeyr@xxxxxxxxxxxxxx" wrote:

On Oct 4, 8:54 am, Devious Devil
<DeviousDe...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi,

Problem Context:
I have a group of related DTS packages each one produces a single CSV file.
I have another DTS package which calls each of the related group one after
another to genereate all the files in one go. The DTS packages are run via a
stored procedure that calls xp_cmdshell that runs DTSRun.exe. The SP is call
from a .NET 2.0 WinForms application. The proxy account has been set and is
used to run the DTS packages. A windows account for the proxy is used and has
access to the destination directory for the files.

For most of our clients it works fine however for 1 of our clients it
timesout. The timeout limit in .NET code for the export is 30 minutes.

Now for the strange bit, on our development server using a copy of the
clients database the export takes between 5 and 6 minutes (well within the 30
minute limit); our server is a 2 CPU, 2 GB RAM, Win 2003 SP1, SQL Server 2000
SP4 machine. The clients server is a 4 CPU, 4GB RAM, Win 2003 SP2, SQL Server
2000 SP4.

There doesn't seem to be anything running on the server that would impact
the SQL Server in any significant way, certainly nothing that would cause
their server to run at least 5 times slower than ours. In fact our server in
theory is under more pressure as developers from other projects also use it.

Anybody with any ideas that we could check or things we could try would be
much appreciated.

Regards,
Peter

Hi Peter,

Have you tried running SQL Profiler and Perfmon to see what it is
actually doing? It seems unlikely that it would be hitting any
resource constraints, more likely there is a permissions issue
somewhere in the chain of events.

Good Luck!
J


.

Relevant Pages

  • Re: Powerful server takes more than 30 minutes to run DTS package
    ... I have a group of related DTS packages each one produces a single CSV file. ... their server to run at least 5 times slower than ours. ... As SSIS tries to do everything in memory, ... I'm not sure about saving Perfmon results sry. ...
    (microsoft.public.sqlserver.dts)
  • Perfmon Query
    ... We are trying to run perfmon on our WIN2K servers from XP ... clients. ... Most of the counters come up when we select the ... We are able to run up perfmon on the server itself whilst ...
    (microsoft.public.win2000.advanced_server)
  • RE: Users Cant Access Documents on Server
    ... Thanks for using the SBS newsgroup. ... As well as we know, if a workstation would not access network shares, then ... Leave the Default Gateway of the internal NIC blank of the server box. ... Clients That Require SMB Signing ...
    (microsoft.public.windows.server.sbs)
  • Re: Users Cant Access Documents on Server
    ... my computer to the network on the server. ... Connection Wizard none of the computers were listed. ... The Mac clients can not communicate with the server box. ... > Error Messages When You Open or Copy Network Files on Windows XP SP1 ...
    (microsoft.public.windows.server.sbs)
  • Re: [SLE] SMTP authentication
    ... So eventhough my local SMTP server dials up to the internet with a certain username and password, that same username and password would not be used as authentication between my local SMTP server and the ISP's one, should it be used as a relay? ... either defer all outgoing mails until you connect to the internet, then flush out all the mails in the queue. ... Your local server would use an external program like fetchmail to poll the mailserver of your ISP, download the mails and feed them to Postfix. ... The test does NOT say "All clients must be in mynetworks, ...
    (SuSE)