Viewing 5 posts - 1 through 6 (of 6 total)
Many thanks for your insights and comments.
It is good to know that SQL Server does not take more memory because it doesn't need it. I was afraid that there was...
May 11, 2011 at 8:18 am
Good to know that the amount of memory is sufficient.
The queries that are running on the databases are heavily joined. In peak hours those queries are executed all the time....
May 11, 2011 at 5:43 am
Thanks for the responses so far. Here are some answers.
Select * from sys.dm_os_performance_counters
where counter_name = 'Page life expectancy'
Returns:
object_name ...
May 11, 2011 at 4:29 am
It is possible that SQL Server does not need more memory, but I find i curious that the memory usages stays exactly the same each time, while the databases are...
May 11, 2011 at 3:00 am
Viewing 5 posts - 1 through 6 (of 6 total)