What are your Memory Settings right now ? How much memory is SQL Server consuming in the Task Manager ?

What is the SQL Server Build number ?

Check the o/p of this query ..

select [Memory Used KB] = (pages_allocated_count * page_size_in_bytes)/1024 from sys.dm_os_memory_objects where type = 'MEMOBJ_RESOURCE'

Check the Values of these counters

Total Server Memory

Target Server Memory

Available Mbytes

Performance object: Process

Counter: Private Bytes

Instance: sqlservr

Performance object: Process

Counter: Working Set

Instance: sqlservr

--

SQLBuddy