July 30, 2010 at 7:07 am
Below is the procedure I peformed while configuring SQL Server.
Total Memory available on Windows Server : 10GB
Configured SQL Server to use 80% of 10GB ie....8GB by setting 'min server Memory' and 'Max Server Memory' to 8GB.
After Restarting the SQL Server services, SQL Server is allocated with 8GB on Memory as Intended.
Now, My question here is,...Out of this 8GB Memory allocated to SQL Server how can I find how much actual memory is being used by SQL Server memory at any given point of time.
This is for SQL Server 2005.
Please Advise.
Thanks
SQLHarry
July 30, 2010 at 9:11 am
The "SQL***MemoryManager" counter in Perfmon will give you the details.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 10:45 am
Pradeep,
Thanks for the Reply.....but still did not resolve the issue (Total memory used by SQL Server).
In the SQL Server Memory Manager counters
Target Server Memory (KB) : Total amount of dynamic memory the server can consume
Total Server Memory (KB) : The committed memory from the buffer pool (in kilobytes).
Note : This is not the total memory used by SQL Server.
Please Refer.
http://technet.microsoft.com/en-us/library/ms190924.aspx
Thanks
SQLHarry
July 30, 2010 at 4:59 pm
You should not set the min memory = max memory. That could cause issues within SQL Server.
Since this is a dedicated box - there is no reason to set the min memory. SQL Server does not pre-allocate memory on startup. It will start allocating memory as needed up to the max setting.
Once SQL Server reaches the max memory target - it is using all of that memory.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 30, 2010 at 6:16 pm
Hi Harry,
Use DBCC Memory Status and Task manager.
http://support.microsoft.com/kb/271624
Thank You,
Best Regards,
SQLBuddy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy