Post reply

Finding out network stats in SSIS

  • September 13, 2012 at 10:05 am

    #266567

    I trolled the internet for some direction on this but I am unable to find out how to get the bandwidth consumed by a package.

    In my current setting, we would love to have some statistical information about which package uses more bandwidth than the others. I have a single package that will be used across 140 locations. So, it would make sense to see, which locations consume more network resources. I have a console app that tells me how much bytes the query consumed, but I cannot include the same in the package.

  • September 13, 2012 at 12:34 pm

    #1537402

    You use a combination of PerfMon and a SQL Server server-side trace to monitor the package while it's running.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply