SNIReadSync executing between 120-500 ms for a simple query. What do I look for?
Posted
by Mike
on Stack Overflow
See other posts from Stack Overflow
or by Mike
Published on 2009-10-23T00:52:51Z
Indexed on
2010/03/18
15:01 UTC
Read the original article
Hit count: 779
Hi Stackoverflow,
I am executing a simple query against SQL Server 2005:
protected static void InitConnection(IDbCommand cmd) {
cmd.CommandText = "set transaction isolation level read uncommitted ";
cmd.ExecuteNonQuery();
}
Whenever I profile with dotTrace 3.1, it claims that SNIReadSync method is taking between 100 - 500 ms.
What sort of things do I need to be looking for in order to get this time down?
Thanks!
© Stack Overflow or respective owner