May 11, 2016 at 6:57 am
I'm curious if there's a setting or something somewhere to increase the performance of my external connections. I'm finding that both my linked server connections and my ftp connections (when writing code that runs an ftp file inside of a stored procedure) are extremely slow as of the last few weeks.
May 11, 2016 at 8:15 am
check the wait statistics for those queries while they are running to understand where the slowdown is occurring. It's possible it's the memory, cpu or I/O of your local system. If it's the network, no, there's no setting within SQL Server that makes the network run faster, especially if we're talking about something that has changed behavior recently. Instead, go to the network people and understand if they are having issues or have changed something recently.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply