Jump to content

SQL server memory Allocation


Taggs

Recommended Posts

I have a mixure of SQL servers in my estate.

SQL 2k5 on Win 2k3

SQL 2k5 on Win 2k8

SQL 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.

Thanks

Taggs

Link to comment
Share on other sites


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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...