AWE option no longer available in SQL Server 2012
AWE (Addressing Windows Extension) is one of the know server configuration to everyone. This parameter allows SQL Server to access large amount of memory in 32 bit machines. However MS decided to depreciate this configuration in SQL Server 2012 (Denali) . I hope this is the first step towards depreciating all 32 bit SQL server editions. So if you are using this setting in your current environment then you need to be careful while upgrading it to SQL Server 2012.
Screenshot from SSMS where you can’t find the option for AWE
One more feature is discontinued in SQL Server 2012. It’s nothing but 32-bit Hot Add memory support is depreciated, so ensure you are not using this feature while upgrading to SQL Server 2012
Tags: 32 bit, awe, dba, memory, sql 2012, sql server 2012, x86
Trackback from your site.
VidhyaSagar
| #
Do you want a batch file to script out all the tables in the database using bcp?
Ramesh
| #
VidhyaSagar, Could you please provide the batch scripts to extract table data using bcp out into multiple files dynamically from a database
VidhyaSagar
| #
@Andres – Sybase date format is not matched with SQL Server date format. If you are using ODBC driver then update in ODBC entry for AFTER connecting.
set temporary option date_order=’MDY’
If this isnt working then check SQL Server default date format and then change accordingly
Andres Gutierrez
| #
Hello, I am trying to make this procedure but when I test the connection, right after I give the information on the Login window, appears the following error:
[Sybase][ODBC Driver][Adaptive Server Enterprise]SQL Anywhere Error -157: Cannot convert ’08/10/09′ to a timestamp
Do you have any idea or suggestion to fix this problem? I dont know where that date comes from. Regards. Andres.
Engin Ardıç
| #
Thank you for nice article! That’s so helpful for me.