Do you need more info???

The RAM is 12 GB, left 9 GB for SQL Server.

I am facing similar issue.

It is SQL Server 2008 SP3 , 32 bit

But what I find strange is I am getting this error for only one table in...

This is actually from one of our client.

As mentioned he needs the data for that time period. Means copying the data from PROD to QA.

I just want to know...

No, the tables are not in sync.

Didn't find any columns that specify the time on the tables..

CDate column is no there in the tables. What shall I do?

Is "last_elapsed_time" = total execution time of the SP?

It gives the last execution time. But how to find out the start & end time?

Any Third party tool provides this information??

Bhuvnesh------ I am getting many syntax errors while executing, is there any changes I need to make before execting?

This is good for the current information.

It would be better if you have queries for past run queries? As I am in need of this information ASAP.

If any one has...

Can you please share the query?

The counter's graph is near to 100%

Results after executing DMV "sys.dm_os_process_memory"

physical_memory_in_use_kb = 93631444 KB

locked_page_allocations_kb = 92303888 KB

Does it mean 92303888 KB is locked for OS?

Please let me know what counters need to monitored to find the physical memory usage?