Hi, We have a report which run 15 store procedures to fetch the data. This report takes 1 hours to process during non buisness hours and about 4 hours during buisness hours. The majority of data is pulled form two large tables by using a join. Each containing about 30 millows rows each. To improve the performace, we are looking at the following options: Create a view on these tables Optimise the stored procedures So I need some guidance in my action plan: Put a trace to check how much time sp are taking to execute. -- any scripts to check the execution time ?? Create the view and check how much time the sp would take. Any other alter ways to improve performance.