matrix0511
asked on
How to Check How much memory is allocated to SQL in SQL 2008 Server?
We use SQL 2008 server running on OS: Windows 2008 R2.
I'm not very familiar with SQL 2008. I've only used older versions.
I need to check the memory utilization that SQL is using.
how can I Check to see how much memory is allocated to SQL in SQL 2008 Server?
Please provide steps.
Thanks!
I'm not very familiar with SQL 2008. I've only used older versions.
I need to check the memory utilization that SQL is using.
how can I Check to see how much memory is allocated to SQL in SQL 2008 Server?
Please provide steps.
Thanks!
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
I have provided you with some reading so that you will understand the implications if you change setting on a system.
as on my profile says,"before you try anyone's possible solution to your questions please always backup your data: it is YOUR responsibility not ours"
ok simple instructions
Start > All Programs > Microsoft SQL Server 2005: SQL Server Management Studio.
Connect using whatever account has admin rights.
Right click on the database > Properties.
Select "Memory" from the left pane and then change the "Server memory options" to whatever you feel should be allocated to SQL Server.
as on my profile says,"before you try anyone's possible solution to your questions please always backup your data: it is YOUR responsibility not ours"
ok simple instructions
Start > All Programs > Microsoft SQL Server 2005: SQL Server Management Studio.
Connect using whatever account has admin rights.
Right click on the database > Properties.
Select "Memory" from the left pane and then change the "Server memory options" to whatever you feel should be allocated to SQL Server.
memory utilization that SQL is using.
several ways:
windows taskmanager
see sql server processes
=============
perfmon
Monitoring Memory Usage
http://msdn.microsoft.com/en-us/library/aa905152(v=sql.80).aspx
To monitor for a low-memory condition, start with the following object counters:
•Memory: Available Bytes
•Memory: Pages/sec
To monitor the amount of memory being used by SQL Server, examine the following performance counters:
•Process: Working Set
•SQL Server: Buffer Manager: Buffer Cache Hit Ratio
•SQL Server: Buffer Manager: Total Pages
•SQL Server: Memory Manager: Total Server Memory (KB)
----------------------
sql server 2008 DMV
---\\
\
---
How to adjust memory usage by using configuration options in SQL Server
http://support.microsoft.com/kb/321363
several ways:
windows taskmanager
see sql server processes
=============
perfmon
Monitoring Memory Usage
http://msdn.microsoft.com/en-us/library/aa905152(v=sql.80).aspx
To monitor for a low-memory condition, start with the following object counters:
•Memory: Available Bytes
•Memory: Pages/sec
To monitor the amount of memory being used by SQL Server, examine the following performance counters:
•Process: Working Set
•SQL Server: Buffer Manager: Buffer Cache Hit Ratio
•SQL Server: Buffer Manager: Total Pages
•SQL Server: Memory Manager: Total Server Memory (KB)
----------------------
sql server 2008 DMV
---\\
\
---
How to adjust memory usage by using configuration options in SQL Server
http://support.microsoft.com/kb/321363
ASKER
Thanks guys. What would you say is a good "rule" or ratio to follow regarding SQL Server 2008 Memory utilization? I know that not having enough allocated can cause performance issues. but if you ONLY have SQL server installed on the OS how much would you say should be allocated vs. to the OS?
Like for example, I just checked and my "minimum" memory setting in SQL is set to 0 and my max is set to: 12288MB.
And my minimum per query is set to:
0 for index creation memory and 1024kb for min
That doesn't look right. Shouldn't I have a number for my minimum settings?
Like for example, I just checked and my "minimum" memory setting in SQL is set to 0 and my max is set to: 12288MB.
And my minimum per query is set to:
0 for index creation memory and 1024kb for min
That doesn't look right. Shouldn't I have a number for my minimum settings?
ASKER
Also, for the intire server I have 18GB installed for memory. So about 12 of that is going to SQL. Does that sound correct??
ASKER
YOu have only been providing links to websites. Do you have actual experience using SQL 2008 server?
If so, please provide the steps to check my memory settings.
Thanks