Even I tried,,

SELECT qs.sql_handle,qs.statement_start_offset,qs.statement_end_offset,

qs.creation_time,qs.last_execution_time,qp.dbid,qp.objectid,st.text

FROM sys.dm_exec_query_stats AS qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st

CROSS APPLY sys.dm_exec_text_query_plan(qs.plan_handle, DEFAULT, DEFAULT) AS qp

WHERE st.text like '%AllReqMailGet%'

I am getting ERROR:

Msg 208, Level 16, State 1, Line 1

Invalid...

Thanks for your suggestion.

Thank you for your reply,

This issue has been solved.

I am a DBA. the SP is already there in the database. I have the permission to modify .

Thanks,

Don't mind..

I am planning to hire somebody to solve the issue.

Thanks,

I will do the same , as you mention . And also try to hire somebody to solve the issue.

Thanks once again.

Don't mind , I have not written the code ,,

Somebody has written from client side. Now it is giving problem to client . so they ask me to tune it...

WHERE PE.PEDONE >= @StarDate AND PE.PEDONE < DATEADD(D, 1, @StarDate)

What is D here.

Go for it :

EXEC sp_configure 'max server memory (MB)', 26624 --26 GB

GO

RECONFIGURE

GO

Go for it :

EXEC sp_configure 'max server memory (MB)', 26624 --26 GB

GO

RECONFIGURE

GO

Also write the version of SQL as well as Windows server.

Look for open transaction if, any.

Run DBCC freeproccache -- to release proc.

Find, where the memory is leaking ?

Execute :

DBCC memorystatus

And look for

Cachestore_SQLCP(node 0)

find the memory usage in "...

Okay, Thanks

In this server The total databases sizes are around 50 GB. The problem is that ,SQL Server: Object Lock Average Wait and

SQL Server: Page Lock Average Wait is...