Hello everyone,
Below Storedprocedure takes 15 secs to execute , please suggest how to optimize this SP?
USE [Helpdesk_Server]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[sp_InsertSchoolComplaint]
-- Add the parameters for the stored procedure here
@complaintnumber nvarchar(50) ,
@assettypeid int ,
@assetid int ,
@schoolid int ,
@stateid int ,
@complainantname nvarchar(50) ,
@complainantcontact nvarchar(50) ,
@complaintdescription nvarchar(max) ,
@remarks nvarchar(max) ,
@createdby int ,
@emailid nvarchar(100) ,
@employeecomplaintname nvarchar(max),
@employeecomplaintcity nvarchar(max)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
Declare @message nvarchar(20)
begin try
Insert Into [MH.Complaints]
(
ComplaintNumber ,
AssetTypeId ,
AssetId ,
SchoolId ,
StateId ,
ReportedDate ,
Reporteddatetime ,
ComplainantName ,
ComplainantContactNumber ,
ComplaintDescription ,
ComplaintStatusId ,
Remarks ,
CreatedBy ,
isDeleted ,
isAdminApproved ,
EmailId ,
EmployeeComplaint,
EmployeeComplaintCity,
isMailed
)
values
(
@complaintnumber ,
@assettypeid ,
@assetid ,
@schoolid ,
@stateid ,
GETDATE() ,
GETDATE() ,
@complainantname ,
@complainantcontact ,
@complaintdescription ,
'5' ,
@remarks ,
@createdby ,
'false' ,
'false' ,
@emailid ,@employeecomplaintname ,@employeecomplaintcity ,'false'
)
set @message ='Yes'
end try
begin catch
set @message ='No'
end catch
Select @message as 'Message'
END