April 12, 2011 at 12:33 pm
SQL Server 2008 Ent R2 64bit on Windows 2008 Ent R2 64bit will not use all available memory. The the server has 70 Gigs or RAM and SQL memory max is set at 66 Gigs. The server is consistently not using more than 25 Gigs of memory. We have scripts running which would normally cause the memory to spike, but SQL seems to refuse to take advantage of the additional memory.
Has anyone experienced this before?
April 12, 2011 at 12:41 pm
What is your min memory setting?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 12, 2011 at 1:46 pm
Min memory is set to 16GB
April 12, 2011 at 3:00 pm
Are you experiencing any signs of slowness in queries?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 12, 2011 at 3:11 pm
How are you monitoring the memory used?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2011 at 12:29 pm
I have the same issue. I moved a DB from SQL Server 2005 with 4GB RAM to SQL Server 2008 R2 64-Bit & Windows 2008 64-bit with 32GB RAM.
The new server is only using 400BM of RAM while on the old it was using 1.5GB of RAM. Of course the new DB is only about 25% the size of the old.
I normally wouldn't be too concerned but the newer (much more beefy) server is running slower than the old.
Thoughts?
Tony
May 4, 2011 at 12:52 pm
GilaMonster (4/12/2011)
How are you monitoring the memory used?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2011 at 1:12 pm
I'm using the Resource Monitor within the Windows 2008 task manager and applying a filter to SQLServer.exe
Maybe I'm worrying about nothing but it seems that it should be using more RAM.
The DB is fairly small (haven't fully loaded it yet) at 1.5GB.
Thanks
Tony
May 4, 2011 at 7:39 pm
Use the following counters to check the Memory consumption. You can use Perfmon or the TSQL st as shown below
SQLServer:Memory Manager -- Target Server Memory (KB) -- The amount of memory SQL Server wants to use
SQLServer:Memory Manager -- Total Server Memory (KB) -- The amount of memory SQL Server s currently using
TSQL --
SELECT object_name,counter_name,instance_name, (cntr_value/1024) as Memory_in_MB, cntr_type FROM sys.dm_os_performance_counters
WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')
Assign Lock Pages in Memory privilege to the SQL Server Service account if the server is dedicated for SQL Server.
Thank You,
Best Regards,
SQLBuddy
May 4, 2011 at 11:34 pm
tony-844756 (5/4/2011)
I'm using the Resource Monitor within the Windows 2008 task manager and applying a filter to SQLServer.exe
Never use task manager to monitor SQL's memory. It lies, especially if you have locked pages or AWE enabled.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 25, 2014 at 4:29 am
We are using Windows Server 2008 R2 enterprise edition and Sql Server 2008 Enterprise edition.And the server RAM size is 192GB.But when we run a sql query of inserting 2 Million records it is taking huge time and the CPU usage and Memory is very very low.Can you please guide us on this.
June 25, 2014 at 4:33 am
Please post new questions in a new thread. Thank you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply