I have 2 identical databases (one larger, one smaller) with identical views. Recently a view on the smaller DB started timing out.
Google searches seems to point to deadlocking of some sorts. If I execute the view (it should return 48 records) it keeps running forever while
tempdb keeps growing until all disk space is consumed.
If I run a top 48 query against the view it returns the data. If I run a
select * query it times out.
Where do I start looking for the problem. Any help appreciated.