CONSTRAINT fk_rental_staff FOREIGN KEY (staff_id) REFERENCES DimStaff (staff_id) , CONSTRAINT fk_rental_customer FOREIGN KEY (customer_id) REFERENCES DimCustomer (customer_id), CONSTRAINT ...
Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...