Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dteshome
Starting Member
3 Posts |
 Posted - 2010-02-01 : 14:17:30
|
| I have a problem in our Prod env. There is this intermittent degradation of performance two to three times per week and it prevents the website from functioning – becomes very, very slow. Using your sp, “sp_whoisactive”, I notice a lot of ASYNC_NETWORK_IO wait type for the login acct that the web server is using to access the db. This coincides with the perf degradation. Also, recently, I noticed that I get error 7886 and The following msg in event log: A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.I know that ASYNC_NETWORK_IO means that the client isn't absorbing the rows fast enough. I need to know what the client was doing, i.e. actual stored proc, or process that caused this w/o impacting performance.Please help.ThanksDan |
|
|
|
|
|
Profiler Trace of ASYNC_NETWORK_IO and 7886 errore