Viewing 15 posts - 31 through 45 (of 313 total)
TL: I found "Disk Queue Length" and watched the number before the package ran. Before the package ran, the number was mostly zero, with some fluctuations between 0.01 to 0.30...
July 22, 2020 at 7:20 pm
TL: Neither the old system nor the new system is Azure.
Here's what I've been told: The old system has 2 cores and the new one has 2 or 4. (I...
July 22, 2020 at 4:56 pm
Steve Jones: At first the job seemed to be stopping at different points. However, over the last couple of days, it seems to always load the same first two tables...
July 22, 2020 at 4:20 pm
Jeff Moden: I don't know what you mean by "check what code is running on the server."
If you mean looking at the profiler, then yes. After a few seconds, the...
July 22, 2020 at 3:13 pm
William Rayer: I should also add for interest sake: Out of desperation, I did a test earlier where I changed the compatibility level of the local SQL Server database to...
July 21, 2020 at 5:55 pm
William Rayer: I'm saving your valuable post, because I think it is going to be relevant and *very* helpful in a couple of months. I'll tell you why I don't...
July 21, 2020 at 3:25 pm
Jeffrey Williams: Thanks for the additional thoughts! I can respond to a couple points and will have to research/test the rest.
As for the destination database/tables, none of the tables are...
July 20, 2020 at 4:09 pm
Update For Anyone Interested
I have spent the last couple of days trying to chase theories of memory problems and/or network problems. I would be happy to share the memory research...
July 17, 2020 at 10:16 pm
Jeffrey Williams: Thanks for the link! Much appreciated. I will definitely be looking at that.
July 16, 2020 at 10:33 pm
Jeffrey Williams: Oh that's simple: Because I had never really heard of Integration Services Catalog before your post. (sigh) I did see the text "Integration Services Catalog" in Object Explorer...
July 16, 2020 at 8:36 pm
Phil Parkin: I researched the MaxConcurrentExecutables property. Thanks for bringing it to my attention.
As you suggested, I changed the value to 1 and re-imported the package into the MSDB database. ...
July 15, 2020 at 11:15 pm
Thank you Phil Parkin! The package definitely does not have any encroaching tasks. I will give your suggestion a try.
July 15, 2020 at 10:22 pm
Mr Brian Gale: Thanks for the added clarification.
I have some more info in case that sparks any more thoughts for you:
You asked about whether the SSIS package had been updated....
July 15, 2020 at 10:19 pm
Chris Harshman: Thanks for the added input. Much appreciated.
I think I remember reading about that Cardinality Estimator thing you are talking about. I didn't understand what the Estimator is, but...
July 15, 2020 at 10:00 pm
Mr. Brian Gale: Thank you soo, sooo much! I will look into all of these things and let you know what happens.
July 15, 2020 at 7:49 pm
Viewing 15 posts - 31 through 45 (of 313 total)