November 21, 2014 at 11:56 am
Hi
I have several SQL servers. One collects the information of others, we call this server "central" , using software developed in VB comunición established by the ADODB.Connection object. We have noticed that when all servers agree in sending the information to the "central" server SQL server begins to decrease performance on all servers , apparently a " tail" is created at the time of the insert and one performs an insert while others go into a " sleep mode " and start to hang . For this reason I want to know what is the best alternative that you can use to prevent this from happening.
November 22, 2014 at 8:35 am
Without knowing the software better, I'm not sure what you're referencing. It's possible that the inserts of data from the first server is causing blocking and/or resource contention for the other servers. My suggestion would be to look at active transactions on the main server to understand what resources are being used, what's blocking (if anything), what the wait statistics are before and after your queries run, etc.
"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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply