September 20, 2008 at 1:53 am
I have a linked server query that has been suspended for the last 5 hrs on ASYNC_NETWORK_IO.
The funny thing is that the linked server is between 2 instances on the same machine!
I didn't think network IO would be an issue in this case.
Can someone please shed some light as to why there would be a network bottleneck in a linked-server query connecting 2 instances on the same machine?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 20, 2008 at 4:18 am
Hello,
Does this problem happen every time or is it just a one of?
If it has just happened once then may be check the account under which you are linking e.g. is it locked out, has the password changed, have permissions been changed on either server.
If it is repeatable then may be look at this thread: http://www.informit.com/articles/article.aspx?p=686168&seqNum=5
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
September 20, 2008 at 5:10 am
John Marsh (9/20/2008)
Hello,Does this problem happen every time or is it just a one of?
If it has just happened once then may be check the account under which you are linking e.g. is it locked out, has the password changed, have permissions been changed on either server.
If it is repeatable then may be look at this thread: http://www.informit.com/articles/article.aspx?p=686168&seqNum=5
Regards,
John Marsh
Thank you, that link was useful.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply