Taggs Posted October 6, 2010 Share Posted October 6, 2010 I have a mixure of SQL servers in my estate.SQL 2k5 on Win 2k3SQL 2k5 on Win 2k8SQL 2k5 on Win 2k8(shared Cluster server)SQL 2k8 on Win 2k8(shared Cluster server)I have set the memory allocation (max and min) for SQL server on each installation.When I looked at the memory allocation in Task manager on my SQL 2k5 on Win 2k3 and SQL 2k5 on Win 2k8 it shows the SQL service as using the allocated memory. When I look at the other SQL installs it shows as not using the allocated memeory.I started to do a little investigation and reading posts on the web people seem to think this is buffer memory allocation and does not show in task manager.I am quite willing to believe this but why do some of my servers show SQL is using the memeory (in task manager) and some show it is not? I can't see a corolation in SQL versions or OS versions!I do have PLIM set on my cluster but after looking into this I don't believe this has anything to do with it.ThanksTaggs Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now