Viewing 15 posts - 1 through 15 (of 294 total)
I enjoyed the article. Fun read.
I do have a different take on one point. Oftentimes when I face a thorny problem, I find it helpful to take a break. While...
October 21, 2020 at 9:01 pm
Thanks Jeff! So fun to get to work with the RBAR guy. 🙂
July 30, 2020 at 11:15 pm
*** FINAL ANSWER ***
Bottom Line: A change of vCPUs from 4 to 8 fixed the hanging problem.
WHAT ABOUT RAM?
I tried to argue for 16 GB RAM not only to possibly...
July 29, 2020 at 10:34 pm
Thanks Jeff! I really appreciate the support. When I think about how many *weeks* I have spent trying to figure this problem out (long before I posted here), I feel...
July 24, 2020 at 11:36 pm
Phil Parkin: Thanks for the encouragement and making me not feel so bad. You are right that I have learned a lot. That's the silver lining.
TL and frederico_fonseca: That is...
July 24, 2020 at 8:42 pm
kaj: That was a great idea. I'm all about long shots at this point, but this particular shot didn't help this problem. Doesn't matter, because that is something I should...
July 24, 2020 at 4:12 pm
Update For Anyone Interested
I figured out how to create a 'Credential' on the server. The Credential is linked to my Windows account. Then I created a Proxy which is linked...
July 23, 2020 at 12:10 am
Mr Brian Gale: I love how you think outside the box. To answer your questions: I just asked and was emailed back, "Resource governor is not configured on [OurNewServer] and...
July 22, 2020 at 9:59 pm
Steve Jones and Jeffrey Williams: Sorry, I've been trying to do tests and typing replies as fast as I can when your posts come in. So, I'm not responding to...
July 22, 2020 at 8:37 pm
re: "I think you need to be looking at the Sybase system to see what is executing on that system."
That possibility makes sense to me too. However, I may...
July 22, 2020 at 8:20 pm
re: "If it hangs in SSIS, can you get it to hang in SSMS?"
I think you mean to try this?: Open Integration Services in Object Explorer in SSMS. Then...
July 22, 2020 at 7:58 pm
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