>I wouldn't expect a deadlock on two or more SELECT queries.
>
>>What would cause Deadlock errors while you're doing queries? I'd understand the larger potential for deadlocks during UPDATEs, but not for SELECTs.
We're getting deadlock errors at peak times during the day on SELECTs. There are also concurrent UPDATEs and INSERTs going on, but we may have reached some limit. Any tips, pointers, adjustments, reading material you can point me to on tuning for this? We don't appear to be processor bound, but me may have a memory problem. (Dual 650's 1.5GB ram, about 250 users) TIA