Viewing 15 posts - 1 through 15 (of 93 total)
Thanks for the idea. I didn't use try-catch since I used -errorvariable in my statement, so instead of calling the throw right after the error occurrs, I waited until...
January 15, 2014 at 3:29 pm
Great article Erin!
Do you have any recommendations on good 3rd party tools for baselining?
November 19, 2012 at 7:59 am
The link to the article does not work. Anyone know where to find it?
October 31, 2011 at 8:44 am
Not really. We did find that if we asked the application owner to force a change then it would resolve. At least that way we didn't have to...
October 12, 2011 at 7:19 am
That's what I thought. Thanks!
April 7, 2011 at 1:17 pm
Thank you for your response. Since this will occur after hours I believe the DBs in high performance mode should be fine - I'll just watch the log usage...
March 10, 2011 at 6:54 am
Right, I'm so confused now and I thought I had it figured out!
March 9, 2011 at 7:51 am
Elliot - Genius! I don't know why I didn't think of that from the get-go. I guess I didn't realize SSIS could make the direct connection. I'm...
March 3, 2011 at 1:08 pm
Thanks for the reply.
I can't do the four-part notation because the table is not associated with any local database.
It's like this: MyLinkedServer..OracleSchema.OracleTable
I did try your suggestion anyway with the...
March 3, 2011 at 12:38 pm
Thanks. I'll review the blog.
March 2, 2011 at 7:10 am
Very helpful, thank you.
February 16, 2011 at 1:05 pm
I'll look into it. Thanks.
February 15, 2011 at 2:10 pm
I generally have a server-side trace running that will tell me how many transactions per minute/second/hour/month/whatever,
Are you referring to perfmon? I only see an option for transaction...
February 15, 2011 at 1:25 pm
Did you ever find out the issue? I'm experiencing the exact same thing.
July 20, 2010 at 7:49 am
Thank you for the info. I will look into this.
March 9, 2010 at 2:42 pm