It seems the Server itself shows 155GB used, even though one Instance has 91 GB limit and the other 31 GB limit?
The server only has 128 GB of RAM with a 30+ GB Virtual Swap File.
What do I check to see if there is a problem? What perfmon do I use?
We are testing on this server and the CPUs are only at 5-10% max. Some testing brought the CPUs to 80-90%.
There are no errors.
Thanks,
Thomas
If you have two instances on one server, they will use all the memory up to the Max memory limit that you set for SQL Server in each instance.
You also need to make sure that you have given the "Lock Pages in Memory" right to the SQL Server service account. My blog post has more details:
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!115.entry
If you are concerned about memory pressure, buffer cache hit ratio and page life expectancy, and memory grants pending are three places to start looking.
|||Where are you getting the 155GB value from? Can you try DBCC memorystatus on both instances and paste the results?
Thanks, Ron D.
No comments:
Post a Comment