Memory high wait

Good morning,
Got a client who is saying SQL Server is VERY sluggish, and even through its got 16Gb RAM and running one database instance which isnt big, its taking several minutes to execute a basic query.

There are indexes, and looking into the query using tools 'Execution Plan' seems to say it will be good.

However looking at the 'Activity Monitor' the memory is very high:-
Activity Monitor
Its running SQL Server 2014 with SP2.

Any ideas what I can do to reduce it?
Who is Participating?
MarcjevConnect With a Mentor Commented:
And these two DMV's give a more detailed view of the problem of where is the system actually waiting on. The graphs are not detailed enough to say anything:
select * from sys.dm_os_waiting_tasks,
select * from sys.dm_os_wait_stats
when the problem is there
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
There's no direct answer only with the information you provided. At least the following should be answered:

What is the configuration of your server?
It's there any other application installed besides SQL Server engine?
And what edition is the SQL Server engine (Express, Standard, Enterprise, Developer, other)?
How much memory if configured for the SQL Server instance (min and max server memories)?
How tempdb is configured (location and number of data files)?
How much storage do you have?
And how the storage is organized (disks for OS, Data, Log, TempDB, Backups, ...)?
How big is the database?
Can you attach the query execution plan?
tonelm54Author Commented:
Not quite sure what the issue was, but the user stopped complaining and when I chased him about it, he said it was working fine now, so all good now (kinda)
Vitor MontalvãoMSSQL Senior EngineerCommented:
I bet it will happen again soon.
When that happens run the commands provided above by Marcjev to try to find the culprit process.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.