46 reputation
4
bio website
location
age
visits member for 2 years, 10 months
seen Jun 16 '11 at 18:01

Jun
16
awarded  Commentator
Jun
16
comment Need help with ASYNC_NETWORK_IO
We're not serving up that much but I know of a few web apps that are bringing back bigger amounts of data. And some of the computers that our users have are slugs and have had problems loading the pages...
Jun
16
comment Need help with ASYNC_NETWORK_IO
Just throwing this out there... If I have an web page that that is bringing back all data from a table - just say 4Gb of data (something big) and the end user is running a slow machine and has to wait for this data would that bottleneck be noticed in ASYNC_NETWORK_IO?? There are a few web pages that are poorly written and are on the list to get fixed.
Jun
16
comment Need help with ASYNC_NETWORK_IO
@gbn - I restarted our web server aboout an hour ago and ASYNC_NETWORK_IO waiting_tasks_count is already up over 100000. Normal? I am also remotely running perfmon on the web server for the next few days to see what I can see. Any other suggestions in the meantime?
Jun
16
comment Need help with ASYNC_NETWORK_IO
@gbn - I'll give that a try then take a look at the logs. Also, does the number of the ASYNC_NETWORK_IO waits seem high for 15 minutes?
Jun
15
comment Need help with ASYNC_NETWORK_IO
@gbn - I'm a bit new to this. Since this are web sites what would the client be? If this is a web site that is the offender then would tracking down the application code and processes be next?
Jun
15
asked Need help with ASYNC_NETWORK_IO
Jun
2
revised SQL Server Backup Process Tuning
added 469 characters in body
Jun
2
comment SQL Server Backup Process Tuning
Thanks. I will be looking into the blocking problem next.
Jun
1
awarded  Supporter
Jun
1
comment SQL Server Backup Process Tuning
Thanks. I will take a look at what you suggested. I will post any new findings.
Jun
1
comment SQL Server Backup Process Tuning
Looks like the actual backup isn't causing the issue. Seems to be something else when SQL Agent is running that seems to be the issue. Still trying to figure this out.
Jun
1
awarded  Editor
Jun
1
revised SQL Server Backup Process Tuning
added 1064 characters in body
Jun
1
comment SQL Server Backup Process Tuning
@SqlACID I appended my results to my original question.
Jun
1
comment SQL Server Backup Process Tuning
I will take a look. I didn't set this up so I will do some investigating.
Jun
1
awarded  Student
May
31
asked SQL Server Backup Process Tuning