Skip to main content
Database Administrators

Return to Question

tags and bit of formatting
Source Link
user507
user507

I have a bit of a conundrum. I recently upgraded a ~20gb database from WS2008r2xSQL2008r2 to WS2012xSQL2012Window Server 2008 R2 || SQL Server 2008 R2 to Window Server 2012 || SQL Server 2012. TheThe previous server had 32gb of memory, upon booting the Max Server memory of 28gb would be consumed within one day. The new server has 48gb of memory however upon booting the database

a) does not take the minimum memory of 4gb
b) after a week of running has only consumed 7gb of data

  1. does not take the minimum memory of 4gb
  2. after a week of running has only consumed 7gb of data

The database is mainly ad-hoc workload that does not utilize stored procs. So the hope in adding memory that was more of query plans would stay cached.

Any idea what could be causing this ?

Edit

dm_os_bufferpool_descriptors:dm_os_bufferpool_descriptors:

 

enter image description here

I have a bit of a conundrum. I recently upgraded a ~20gb database from WS2008r2xSQL2008r2 to WS2012xSQL2012. The previous server had 32gb of memory, upon booting the Max Server memory of 28gb would be consumed within one day. The new server has 48gb of memory however upon booting the database

a) does not take the minimum memory of 4gb
b) after a week of running has only consumed 7gb of data

The database is mainly ad-hoc workload that does not utilize stored procs. So the hope in adding memory that was more of query plans would stay cached.

Any idea what could be causing this ?

Edit

dm_os_bufferpool_descriptors:

 

enter image description here

I have a bit of a conundrum. I recently upgraded a ~20gb database from Window Server 2008 R2 || SQL Server 2008 R2 to Window Server 2012 || SQL Server 2012. The previous server had 32gb of memory, upon booting the Max Server memory of 28gb would be consumed within one day. The new server has 48gb of memory however upon booting the database

  1. does not take the minimum memory of 4gb
  2. after a week of running has only consumed 7gb of data

The database is mainly ad-hoc workload that does not utilize stored procs. So the hope in adding memory that was more of query plans would stay cached.

Any idea what could be causing this ?

Edit

dm_os_bufferpool_descriptors:

enter image description here

added 159 characters in body
Source Link
bumble_bee_tuna
bumble_bee_tuna
  • 967
  • 2
  • 11
  • 20

I have a bit of a conundrum. I recently upgraded a ~20gb database from WS2008r2xSQL2008r2 to WS2012xSQL2012. The previous server had 32gb of memory, upon booting the Max Server memory of 28gb would be consumed within one day. The new server has 48gb of memory however upon booting the database

a) does not take the minimum memory of 4gb
b) after a week of running has only consumed 7gb of data

The database is mainly ad-hoc workload that does not utilize stored procs. So the hope in adding memory that was more of query plans would stay cached.

Any idea what could be causing this ?

Edit

Thanksdm_os_bufferpool_descriptors:

enter image description here

I have a bit of a conundrum. I recently upgraded a ~20gb database from WS2008r2xSQL2008r2 to WS2012xSQL2012. The previous server had 32gb of memory, upon booting the Max Server memory of 28gb would be consumed within one day. The new server has 48gb of memory however upon booting the database

a) does not take the minimum memory of 4gb
b) after a week of running has only consumed 7gb of data

The database is mainly ad-hoc workload that does not utilize stored procs. So the hope in adding memory that was more of query plans would stay cached.

Any idea what could be causing this ?

Thanks

I have a bit of a conundrum. I recently upgraded a ~20gb database from WS2008r2xSQL2008r2 to WS2012xSQL2012. The previous server had 32gb of memory, upon booting the Max Server memory of 28gb would be consumed within one day. The new server has 48gb of memory however upon booting the database

a) does not take the minimum memory of 4gb
b) after a week of running has only consumed 7gb of data

The database is mainly ad-hoc workload that does not utilize stored procs. So the hope in adding memory that was more of query plans would stay cached.

Any idea what could be causing this ?

Edit

dm_os_bufferpool_descriptors:

enter image description here

Source Link
bumble_bee_tuna
bumble_bee_tuna
  • 967
  • 2
  • 11
  • 20

SQL Server 2012 Very Slow to Consume Memory

I have a bit of a conundrum. I recently upgraded a ~20gb database from WS2008r2xSQL2008r2 to WS2012xSQL2012. The previous server had 32gb of memory, upon booting the Max Server memory of 28gb would be consumed within one day. The new server has 48gb of memory however upon booting the database

a) does not take the minimum memory of 4gb
b) after a week of running has only consumed 7gb of data

The database is mainly ad-hoc workload that does not utilize stored procs. So the hope in adding memory that was more of query plans would stay cached.

Any idea what could be causing this ?

Thanks