Thanks ALL.

I read a tutorial and recommend this option should be enabled for all instances. Read and still a little confusing about when I should enable or disable it.

I will...

Thanks all. I will download the book to read.

Also Gail, when you say:

"No, it means that SQL is ramping up its memory usage.", I am not sure I understand well...

SQL Pizza (2/1/2013)

---

Hi sqlfriends,

as you've already learned, memory management in sql server is a very complicated topic. Could you please describe your problem more precise, to give us a chance...

Sorry, I mean Total server memory is much lower than target server memory.

Does it indicate a memory pressure?

Also how to compare total server memory and target server memory?

If target server memory is much less than total server memory, is it under memory pressure?

Thanks

Thanks,

What is the difference of the two query above mentioned:

1. SELECT physical_memory_in_use_kb/1024 AS totl_mem_usage FROM sys.dm_os_process_memory AS dm

2. SELECT cntr_value/1024 AS [amount of memory SQL is using in MB]

FROM...

Thanks much

Not yet, will try that

Thanks

Thanks much.

Does this job have to be scheduled to run daily? How about if I just want to collect the data once a week, or once a month?

If so, do...

Thanks,

The link is the link I referred to on my first post.

I did exactly the same thing, in fact, I just tried on another testing server the same process,...

A question about permissions.

When I schedule the job, because it will run using SQL agent service account, it won't work because it cannot login to other computers using that service...

Thanks, Chad, this is one of the best scripts on internet I can find about space monitoring.

I tried serveral before and compare them with this one, this is the cleanest...

Thanks, that helps a lot

Yes, I am the administrator of the box.

This is a windows 7 developer box

Thanks all.

Yes that's what I found too, I am using 2008, and it prompts if I want to open rollover files. And I see a Find button that is not...