489 reputation
516
bio website
location
age
visits member for 2 years, 5 months
seen Oct 3 at 23:34

Nov
5
awarded  Popular Question
Oct
30
awarded  Notable Question
Oct
28
awarded  Popular Question
Sep
12
awarded  Popular Question
Jul
16
accepted Why is there ASYNC_NETWORK_IO wait type on Shared Memory connections?
Jul
2
awarded  Curious
Jun
20
awarded  Yearling
Jan
29
revised Does RAM taken up Shared Memory connection counts against Max Server Memory?
added 18 characters in body
Jan
29
asked Does RAM taken up Shared Memory connection counts against Max Server Memory?
Jan
29
awarded  Notable Question
Jan
28
comment Why is there ASYNC_NETWORK_IO wait type on Shared Memory connections?
@AaronBertrand It was partially answered in the linked question. I just wanted to make sure that this type of wait can also be applied to a non-network issue.
Jan
28
asked Why is there ASYNC_NETWORK_IO wait type on Shared Memory connections?
Jan
27
accepted Is ASYNC_NETWORK_IO wait type anything to worry about?
Jan
24
comment Is ASYNC_NETWORK_IO wait type anything to worry about?
For bullet point 2. The application is on the same box as SQL and the connection is via Shared Memory method. So theoretically that should be super fast.
Jan
24
comment Is ASYNC_NETWORK_IO wait type anything to worry about?
For bullet point 1. The data retrieval is done via ADO.NET using standard code: var dataSet = new DataSet(); var da = new SqlDataAdapter(command); da.Fill(dataSet); So I am not sure what exactly could be slow.
Jan
23
comment Is ASYNC_NETWORK_IO wait type anything to worry about?
@EricHiggins Just a local set of RAIDed hard drives.
Jan
23
comment How to improve Procedure Cache Hit Ratio?
@AaronBertrand That is certainly possible - I will have to definitely measure the impact.
Jan
23
comment Is ASYNC_NETWORK_IO wait type anything to worry about?
It's the default connection type - nothing special - so it's using Shared Memory. Both apps using the same set of cores - there is no affinity.
Jan
23
comment How to improve Procedure Cache Hit Ratio?
@AaronBertrand The guy who did the demo for us said that the overhead is almost immaterial (1-2%), but I didn't know the right questions to ask since I am a C# dev who is very occasionally a reluctant DBA.
Jan
23
comment How to improve Procedure Cache Hit Ratio?
@AaronBertrand It aggregates it by the amount of time that the database waits on a sproc. So if 50k calls 500 ms each would show up as 416 minutes of wait.