c#客户端调用sql server 存储过程速度慢的问题

                        SqlConnection connNew = null;

                        connNew = new SqlConnection(@"Data Source="XXX");
                        connNew.Open();

                        SqlCommand commNew = connNew.CreateCommand();
                        commNew.CommandText = "sp_catcher_MeraRptCAV_Insert_detail";
                        commNew.CommandType = System.Data.CommandType.StoredProcedure;
                        commNew.CommandTimeout = 300;

                        commNew.Parameters.Add(new SqlParameter()
                        {
                            ParameterName = "@TVP",
                            SqlDbType = SqlDbType.Structured,
                            Value = GetDataTableParamNew(CANewReport)
                        });

                        //File.AppendAllText(strCurrentPath + @"\test.txt", "Now about to insert report " + reportID + " records into db " + "\r\n");
                        try
                        {
                            commNew.CommandTimeout = 300;
                            commNew.ExecuteNonQuery();

                        }

                        catch (Exception ex)
                        {

                            //Logger.Error("Execute Procedure ‘sp_merarpt_create‘ Failed, Error Message : ‘" + ex.Message + "‘.");
                        }
                        finally
                        {
                            commNew.Dispose();
                            if (commNew != null)
                            {
                                connNew.Close();
                                connNew.Dispose();
                            }
                        }

USE [Smartbilling_AI]
GO
/****** Object:  StoredProcedure [dbo].[sp_catcher_MeraRptCAV_Insert_detail]    Script Date: 10/29/2014 09:28:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_catcher_MeraRptCAV_Insert_detail]
(
	@TVP dbo.MeraRpt_CAV_AI READONLY
)
AS
BEGIN
declare @reportid as int

	SET NOCOUNT ON;

        INSERT INTO MeraRpt_Detail_ByPrefix
        (
		[reportID]
		,[Customer]
		,[Prefix]
		,[Route]
		,[ASRSuccessCalls]
		,[ACDSuccessCalls]
		,[TotalCalls]
		,[TotalMins]
		,[ASR]
		,[ACD]
		,[Fee]
		,[Cost]
		,[Profit]
	)
	SELECT [reportID]
		,[Customer]
		,[Area]
		,[Vendor]
		
		,[ASRsuccessCalls]
		,[ACDsuccessCalls]
		,[totalCalls]
		,[totalMins]
		
		,[ASR]
		,[ACD]
		,[Fee]
		,[Cost]
		,[profix]
		
	FROM @TVP tvp


	select @reportid = max(reportid) from merarpt

	

	--refresh area report
	--exec MeraRpt_Refresh_Area 
	--exec MeraRpt_Refresh_cr

	--Update Report By Prefix
	
	BEGIN TRY
		exec [sp_i_Refresh_Cust_Prefix] @reportid
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Cust_Prefix] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH
	

	--Update Report By Prefix Hourly
	BEGIN TRY
		exec [sp_i_Refresh_Cust_Prefix_hour] @reportid
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Cust_Prefix_hour] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH

	----Update Report By Area
	BEGIN TRY
		exec [sp_i_Refresh_Cust_Area] @reportid
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Cust_Area] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH

	----Update Report By Area Hourly
	BEGIN TRY
		exec [sp_i_Refresh_Cust_Area_Hour] @reportid
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Cust_Area_Hour] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH

	----Update Report By Area Route
	BEGIN TRY
		exec [sp_i_Refresh_Cust_Area_Route] @reportid
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Cust_Area_Route] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH


    --以下是 vendor 部分 

	BEGIN TRY
		exec [sp_i_Refresh_Vendor_Prefix] @reportid 
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Vendor_Prefix] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH


	BEGIN TRY
		exec [sp_i_Refresh_Vendor_Prefix_hour] @reportid
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Vendor_Prefix_hour] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH


	BEGIN TRY
		exec [sp_i_Refresh_Vendor_Area] @reportid   
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Vendor_Area] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH

	BEGIN TRY
		exec [sp_i_Refresh_Vendor_Area_hour] @reportid
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Vendor_Area_hour] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH
	
	
	BEGIN TRY
		exec [sp_i_Refresh_Vendor_Area_Route] @reportid
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Vendor_Area_Route] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH
	
    
	update merarpt set FinishProcessedTime = getdate() where reportid = @reportid
END

	BEGIN TRY
		exec [sp_i_Refresh_Vendor_Prefix] @reportid 
	END TRY
	BEGIN CATCH
		insert capturelog 
		(content) values (‘[sp_i_Refresh_Vendor_Prefix] Warning Code:‘ + cast (@@error as nvarchar) + ‘ Warning Lines: ‘ + Cast (ERROR_LINE() as nvarchar) + ‘ Warning Msg: ‘+ERROR_MESSAGE())
	END CATCH