Usually querying the table is in the millisecond range at most. But sometimes it takes 30 seconds and then times out.
What could cause
SELECT smallColumn FROM SomeTable WHERE pkID=@pkID to be slow?
If I had to guess, I'd say the query is being prevented from being run because another query is altering the table in some way, but my knowledge of locking is severely limited. Or it could be possible, maybe?, that another transaction is holding the table even though the table isn't really being used anymore for that transaction.
I can't use a SQL Profiler. Is there some list of things I can systematically go through to check?
Thanks in advance.