Freigeben über

Q & A: I am running on 64 bit and all of my tasks are waiting on SOS_RESERVEDMEMBLOCKLIST, What is going on?

  • Artikel

This wait type represents waiting on multi page allocations inside of SQLOS's memory manager. As you remember from my description of memory manager's working internals, it has two major allocators single page allocator, SPA and multi page allocator, MPA. Majority of the time SQL Server internal code uses SPA, however in some cases it will use MPA, i.e. for example when request exceeds size of single page, 8KB.

On 64 bit systems SQL Server internal code can potentially generate larger memory requests which might exceed single page size - this is due to the fact that size of internal data structures on 64 bit is larger than on 32 bit platforms. A larger amount of concurrent MPA allocations could translate into more allocations served by MPA rather than by SPA. More concurrent allocations might possibly introduce more pressure on MPA and that could translate into SOS_RESERVEDMEMBLOCKLIST waits.

In SQL Server 2005 SP2 we have addressed this problem by making MPA significantly more concurrent.

If you see such issue and can't wait until SP2 is out, please contact MS Product support to get a fix.

Let me know if you have any questions.

Comments

  • Anonymous
    December 20, 2006
    Hi I am running on the itanimum server IA64 W2k3 sp1 with SQl server 2000 SP4 IA64 Bit. Clsuter environment Veritas. We have problem in Databases backup srestore from Xeon(32bit) to Itanium server. Once copied the even for Normal index on itanium process is taking 28 hours wher in xeon about 20 Mins. Itanium having 8 GB ram and 4 Processor any setting i have to do. I went as per microsoft recommendation no change in sp_configure. Please help me tamilvel

  • Anonymous
    December 20, 2006
    Hi I am running on the itanimum server IA64 W2k3 sp1 with SQl server 2000 SP4 IA64 Bit. Clsuter environment Veritas. We have problem in Databases backup srestore from Xeon(32bit) to Itanium server. Once copied the even for Normal index on itanium process is taking 28 hours wher in xeon about 20 Mins. Itanium having 8 GB ram and 4 Processor any setting i have to do. I went as per microsoft recommendation no change in sp_configure. Please help me tamilvel

  • Anonymous
    January 02, 2007
    Could you email me offline so that we can figure what is going on here?