Ok , set Server maximum memory=6 Gb. after that?

40 Users used every time. Maximum Memory ? I am sending proc who is working very slow . /* exec Visa_new_pending_followup_sel_final_new 'PCOMP/000002','','','','','','' */ CREATE PROC Visa_new_pending_followup_sel_final_new (@Comp_code VARCHAR(20), @username VARCHAR(50), @country VARCHAR(50) = NULL, @username_S VARCHAR(100), @adv_search VARCHAR(5) = NULL, @yrs VARCHAR(5) = NULL, @month VARCHAR(3) = NULL) AS BEGIN SET nocount ON; DECLARE @user_type VARCHAR(2) SELECT @user_type = super_user FROM crm_login_reg_tbl (nolock) WHERE username = @username AND company_code = @Comp_code IF Isnull(Len(Ltrim(Rtrim(@username_S))), 0) = 0 BEGIN SELECT @username_S = NULL END DECLARE @temp TABLE ( username VARCHAR(200), lead_code VARCHAR(200), acc_code VARCHAR(200), acc_name VARCHAR(200), case_code VARCHAR(200), subject VARCHAR(500), follow_up_code VARCHAR(200), follow_up_date_ DATETIME, follow_up_time VARCHAR(10), followup_status_desc VARCHAR(100), creation_date VARCHAR(20), created_by VARCHAR(100), ref_type VARCHAR(100), cont_code VARCHAR(100), deadline_status VARCHAR(1), deadline_date_ DATETIME, deadline_reason VARCHAR(1000) ) IF ( @user_type IN ( 'G' ) ) BEGIN INSERT INTO @temp SELECT a.username

Sql server Maximum Memory=2147483647 Mb Manimum Memory=0 Mb Minimum Memory Per query=1024 kb and procedure is not creating any locks.

When multiple user working at a time.Maximum task is suspended for this reason sql fetch data very slow.

Yes it's 64 bit OS and Microsoft SQL Server Express Edition with Advanced Services (64-bit)

Hello sir, I have dedicated server with 8 Gb RAM.I have developed the CRM when multiple user working at a time Sql server working very slow task is going on suspended. Sql server 2008 R2 Express Edition Database Size=6Gb Maximum Memory=2147483647 Mb Minimum Memory Per query=1024 kb Pls.... suggest