We're running SQL Server Express for our project. I'm trying to prove that we have to move to Standard or Web version of it. Just because I suspect that because of Express edition limitation it can't use as much of RAM as it needs. When I look at SQL Server process in the process explorer I always see that it utilizes around 1.5 gigs of RAM and never goes higher.
Is there a tool which will allow me to tell that the maximum memory amount it can use is really the issue?
Update. We're using SQL Server 2008 R2 SP1 Express Edition with Advanced Services (64-bit). Results of DBCC are here. Maximum allowed amount of memory is 4 gigabytes.
-
1What is the version of SQL server? How much is the RAM allocated on box? What are you're max and min server memory? Also can you share the output of DBCC MEMORYSTATUSKASQLDBA– KASQLDBA2015年06月09日 14:32:12 +00:00Commented Jun 9, 2015 at 14:32
-
There are lots of similar questions that may help you.LowlyDBA - John M– LowlyDBA - John M2015年06月09日 14:37:41 +00:00Commented Jun 9, 2015 at 14:37
-
32-bit or 64-bit?wBob– wBob2015年06月09日 14:54:06 +00:00Commented Jun 9, 2015 at 14:54
-
1First clear what version of SQL Server you are using. With express edition you have limitation of memory from 2012 onwards SQL Server database engine can only use around 1.5 G not more than that. This is well documented support.microsoft.com/en-us/kb/2663912 see the last paragraphShanky– Shanky2015年06月09日 15:26:28 +00:00Commented Jun 9, 2015 at 15:26
-
Here is a good start: learn.microsoft.com/en-us/sql/relational-databases/…Meyssam Toluie– Meyssam Toluie2023年10月21日 13:10:56 +00:00Commented Oct 21, 2023 at 13:10
1 Answer 1
You can check if SQL Server is memory constrained by monitoring the Page Life Expectancy perfmon counter. Monitor it over time and if this counter is consistently low you probably have memory pressure.
you could also query the ring buffer as described in https://www.sqlskills.com/blogs/jonathan/identifying-external-memory-pressure-with-dm_os_ring_buffers-and-ring_buffer_resource_monitor/.
-
That is what I meant, fixed it.Bob Klimes– Bob Klimes2015年06月10日 16:47:19 +00:00Commented Jun 10, 2015 at 16:47
-
Page Life Expectancy isn’t what you think...Kin Shah– Kin Shah2015年06月10日 16:59:59 +00:00Commented Jun 10, 2015 at 16:59