September 12, 2011 at 1:04 pm
Hello, I have 24 GB RAM and physical memory= I ran info from select * from sys.dm_os_sys_info
25759105024 in bytes and virtual memory 12883918848 in bytes, also I checked under server memory option 24566 (MB). Is this correct we are running out of memory?
also, I have
Total avail mem, KB Max free size, KB
8564015732 8558307584
Thank you
September 12, 2011 at 1:08 pm
Hi
Don't configure SQL Servers max memory allocation for maximum (or higher) memory of your box. If you have 24GB physical memory you should configure SQL Server for a maximum of say 20GB. Otherwise SQL Server will take all the memory and leave nothing to your OS.
Greets
Flo
September 12, 2011 at 1:18 pm
I want to know if
my SQL Server is not running out of available process memory. Probably we hit that memory which is allocated to the SQL Server.
How can I check and what I should do?
Thank you
September 12, 2011 at 5:35 pm
Check this counter ..
Total Server Memory (KB) to see if SQL Server is hitting that Max Mark.
Thank You,
Best Regards,
SQLBuddy
September 12, 2011 at 5:50 pm
Where should I check?
September 12, 2011 at 5:56 pm
Use this for that task..
SELECT * FROM sys.dm_os_performance_counters
WHERE counter_name IN ('Total Server Memory (KB)')
Thank You,
Best Regards,
SQLBuddy
September 14, 2011 at 11:53 am
I ran it
SELECT * FROM sys.dm_os_performance_counters
WHERE counter_name IN ('Total Server Memory (KB)')
but get no results back, but on my other server I got results.
What is the reason?
September 14, 2011 at 11:58 am
Does that table have a LOB? What is LOB?
Thank you
September 14, 2011 at 6:05 pm
How different are the servers ?
Do you have SQL Server 2000 instance ?
Thank You,
Best Regards,
SQLBuddy
September 15, 2011 at 7:21 am
This SQL server 2005
September 15, 2011 at 5:17 pm
How many instances do you have on the server ?
Do you have any Named Instances installed ?
Thank You,
Best Regards,
SQLBuddy
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply