Lock request time out period exceeded

My Admin
My Admin used Ask the Experts™
on
Hi Experts,

We got an issue of high physical memory (98% Used) because of MSSQLSERVER.

Error from event viewer: Lock request time out period exceeded

1. What is the error means ?
2.what can I do to minimize the high usage of memory?

Regards,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
That meas in my opinion the server does not have MAX memory set so SQL will use as much as possible and even starving the OS and any other apps that need memory. Please have a loog here how to check it and set it to reasonable value and by doing this I believe you get the answer to both questions.

https://www.brentozar.com/blitz/max-memory/
https://www.sqlskills.com/blogs/jonathan/wow-an-online-calculator-to-misconfigure-your-sql-server-memory/

Now...even after that value was set you may get the
Lock request time out period exceeded
error if lets say you add a new index on a large SQL table in SSMS query and from same SSMS session you navigate to DB.table where the index is added and you want to see if it was added ro not - while the CREATE INDEX... is still running - you will get that error for sure.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> Lock request time out period exceeded
1. What is the error means ?

Error indicates that the table you are trying to access is blocked by some other transaction(s) for a long time..
We need to find the long running transaction or blocking query to have that particular table or object accessed properly.

>> 2.what can I do to minimize the high usage of memory?

I believe the above error has nothing to do with the error message you have received out..
Anyhow, its recommended to configure the Max Memory of SQL Server to some value leaving 4-6 GB RAM for OS and other operations depending whether this server is dedicated for SQL Server alone or not to reduce the High Memory usage by SQL Server service.
FYI, by design SQL Server will try to reserve all available memory in the Server unless Max Server Memory value is configured properly..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial