SNIReadSync runs for 120-500 ms for a simple request. What am I looking for?

Question

I execute a simple query to SQL Server 2005:

protected static void InitConnection(IDbCommand cmd) {
        cmd.CommandText = "set transaction isolation level read uncommitted ";
        cmd.ExecuteNonQuery();            
    }

Whenever I look at dotTrace 3.1, it claims that the SNIReadSync method takes from 100 to 500 ms.

What things do I need to look for to get this time?

Thank!

Answer 1

I have not tested, but would have wondered if you have the same problem if you used TransactionScope with the IsolationLevel.ReadUncommitted options. You will need to encapsulate the full set of calls, and this should negate the need for this statement. I understand that this statement is not your main concern, but in general.

, , - DBConnectionScope ( ) .

Answer 2

, . Pooling = True . , .

. , .