I was trying to trace timeouts in Profiler on a particular database.
Using the lock: timeout parameter I would get timeouts with a LoginName of 'sa'
there would be an ObjectID, StartTime, SPID and nothing else.
sa isn't used by any process in this app and nothing else runs on the server.
All db options except AUTO_UPDATE_STATS have been turned off and I that
isn't even running when this happens.
I checked a few of our other SQL Servers and databases and the same thing
happens there too.
Why is this happening?