• Your query is spending maximum time in Sorting the data. I checked your view and I see it uses "TOP 100 PERCENT " ... If you are getting 100 Percent data then you don't need to use top 100 Percent , even if you remove this it will fetch all records. At first place try to remove this TOP clause and see performance.

    Also remove the order by stoptimestamp clause unless you really need to order the result set in database. You can do the sorting at UI if required.