479 reputation
414
bio website
location
age
visits member for 2 years, 3 months
seen Jul 16 at 21:48

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.
Jan
23
asked Is ASYNC_NETWORK_IO wait type anything to worry about?
Jan
23
comment How to improve Procedure Cache Hit Ratio?
@AaronBertrand I am using Confio Ignite8 which is pretty adept at aggregating data and pointing out bottlenecks.
Jan
23
comment How to improve Procedure Cache Hit Ratio?
@AaronBertrand Yes, the first thing I'll look at is adding OPTION (RECOMPILE) to some sprocs that use a massive amount of dynamic SQL. The strategy is to go after sprocs that take the most time in aggregate and see if that makes a difference. But nothing concrete yet.