Sql server view issue : i've ran the select query on a view to check it's count. but the select statement is running continuously and no result set is coming. i've verifued deadlocks and locks on tables etc.. and refreshed the view. but no use.

Any suggestions for me