MsDtsSrvr.exe memory leak?

In our current environment, we are running about 10,000 packages per day on a given 64 bit SSIS server.

The MSDtsSrvr.exe (SSIS service) process' memory working set size continues to grow until it consumes the memory on the machine.

Some of the packages do use a custom component. Could this be responsible for leaking memory in the MSDtsSrvr.exe process? Has a memory leak been confirmed in this process for the "first-party" components anyway?

More information about the possible memory leak.

The packages are run in in a CLR process with calls Package.Execute(), rather than being executed via dtexec or dtexecui or the designer. The reason for this approach is the ability to write a custom event handler with access to the package pointer, which other log handlers cannot do. The process runs Package.Execute() and exits, so there are 10,000 short-lived processes, each of which call Package.Execute() once.

To be slightly more specific about what the packages are doing, each of the 10,000 packages generally correlates to 1 source file, loading in dummy (aka inferred) dimension records, and then populating a fact table via a surrogate key pipeline.

MSDTC stopped working after reboot

I have:
w2k3 enterprise server
A/P Cluster
Sql 2000 sp4
All was well until we did a scheduled reboot. Now, DTS packages report that
the MSDTC is not running. I checked the Cluster Admin and services, all is
well.
I down loaded the DTSTester, and it fails. Unable to attach. Mentions FW,
DNS, ETC. I ran these down and nothing is out of wack.
Any Ideas? Thanks!Hi
Did you try DTCPing? This may help
http://support.microsoft.com/defaul...kb;en-us;306843
John
"tbithoney" wrote:

> I have:
> w2k3 enterprise server
> A/P Cluster
> Sql 2000 sp4
> All was well until we did a scheduled reboot. Now, DTS packages report th
at
> the MSDTC is not running. I checked the Cluster Admin and services, all i
s
> well.
> I down loaded the DTSTester, and it fails. Unable to attach. Mentions FW
,
> DNS, ETC. I ran these down and nothing is out of wack.
> Any Ideas? Thanks!
>|||Apparently, there is a HOTFIX for this issue.
the error is:
Server: Msg 8501, Level 16, State 3
As described in:
http://support.microsoft.com/defaul...kb;en-us;889706
Have you tried this before?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Did you try DTCPing? This may help
> http://support.microsoft.com/defaul...kb;en-us;306843
> John
> "tbithoney" wrote:
>|||Hi
I have not tried this, it would be good practive to try it on a different
system first.
John
"tbithoney" wrote:
[vbcol=seagreen]
> Apparently, there is a HOTFIX for this issue.
> the error is:
> Server: Msg 8501, Level 16, State 3
> As described in:
> http://support.microsoft.com/defaul...kb;en-us;889706
> Have you tried this before?
>
> "John Bell" wrote:
>

MSDTC stopped working after reboot

I have:
w2k3 enterprise server
A/P Cluster
Sql 2000 sp4
All was well until we did a scheduled reboot. Now, DTS packages report that
the MSDTC is not running. I checked the Cluster Admin and services, all is
well.
I down loaded the DTSTester, and it fails. Unable to attach. Mentions FW,
DNS, ETC. I ran these down and nothing is out of wack.
Any Ideas? Thanks!
Hi
Did you try DTCPing? This may help
http://support.microsoft.com/default...b;en-us;306843
John
"tbithoney" wrote:

> I have:
> w2k3 enterprise server
> A/P Cluster
> Sql 2000 sp4
> All was well until we did a scheduled reboot. Now, DTS packages report that
> the MSDTC is not running. I checked the Cluster Admin and services, all is
> well.
> I down loaded the DTSTester, and it fails. Unable to attach. Mentions FW,
> DNS, ETC. I ran these down and nothing is out of wack.
> Any Ideas? Thanks!
>
|||Apparently, there is a HOTFIX for this issue.
the error is:
Server: Msg 8501, Level 16, State 3
As described in:
http://support.microsoft.com/default...b;en-us;889706
Have you tried this before?
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Did you try DTCPing? This may help
> http://support.microsoft.com/default...b;en-us;306843
> John
> "tbithoney" wrote:
|||Hi
I have not tried this, it would be good practive to try it on a different
system first.
John
"tbithoney" wrote:
[vbcol=seagreen]
> Apparently, there is a HOTFIX for this issue.
> the error is:
> Server: Msg 8501, Level 16, State 3
> As described in:
> http://support.microsoft.com/default...b;en-us;889706
> Have you tried this before?
>
> "John Bell" wrote:

MSDTC stopped working after reboot

I have:
w2k3 enterprise server
A/P Cluster
Sql 2000 sp4
All was well until we did a scheduled reboot. Now, DTS packages report that
the MSDTC is not running. I checked the Cluster Admin and services, all is
well.
I down loaded the DTSTester, and it fails. Unable to attach. Mentions FW,
DNS, ETC. I ran these down and nothing is out of wack.
Any Ideas? Thanks!Hi
Did you try DTCPing? This may help
http://support.microsoft.com/default.aspx?scid=kb;en-us;306843
John
"tbithoney" wrote:
> I have:
> w2k3 enterprise server
> A/P Cluster
> Sql 2000 sp4
> All was well until we did a scheduled reboot. Now, DTS packages report that
> the MSDTC is not running. I checked the Cluster Admin and services, all is
> well.
> I down loaded the DTSTester, and it fails. Unable to attach. Mentions FW,
> DNS, ETC. I ran these down and nothing is out of wack.
> Any Ideas? Thanks!
>|||Apparently, there is a HOTFIX for this issue.
the error is:
Server: Msg 8501, Level 16, State 3
As described in:
http://support.microsoft.com/default.aspx?scid=kb;en-us;889706
Have you tried this before?
"John Bell" wrote:
> Hi
> Did you try DTCPing? This may help
> http://support.microsoft.com/default.aspx?scid=kb;en-us;306843
> John
> "tbithoney" wrote:
> > I have:
> > w2k3 enterprise server
> > A/P Cluster
> > Sql 2000 sp4
> >
> > All was well until we did a scheduled reboot. Now, DTS packages report that
> > the MSDTC is not running. I checked the Cluster Admin and services, all is
> > well.
> >
> > I down loaded the DTSTester, and it fails. Unable to attach. Mentions FW,
> > DNS, ETC. I ran these down and nothing is out of wack.
> >
> > Any Ideas? Thanks!
> >|||Hi
I have not tried this, it would be good practive to try it on a different
system first.
John
"tbithoney" wrote:
> Apparently, there is a HOTFIX for this issue.
> the error is:
> Server: Msg 8501, Level 16, State 3
> As described in:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;889706
> Have you tried this before?
>
> "John Bell" wrote:
> > Hi
> >
> > Did you try DTCPing? This may help
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;306843
> >
> > John
> >
> > "tbithoney" wrote:
> >
> > > I have:
> > > w2k3 enterprise server
> > > A/P Cluster
> > > Sql 2000 sp4
> > >
> > > All was well until we did a scheduled reboot. Now, DTS packages report that
> > > the MSDTC is not running. I checked the Cluster Admin and services, all is
> > > well.
> > >
> > > I down loaded the DTSTester, and it fails. Unable to attach. Mentions FW,
> > > DNS, ETC. I ran these down and nothing is out of wack.
> > >
> > > Any Ideas? Thanks!
> > >