Looks multiple problems, query is bad but ran on test system I/o issues in report server.  ran blitzio and got some scary results with stall time over 40ms

just started here as dba so change probably not it is 133 million rows index seemed to help will look at cleanup just in case  thanks for help

thanks I am new DBA at company so just trying to navigate now will work with our vmware/storage team