SQL Server 2012 does not support AWE. That means if you still have a 32-bit operating system and are currently using AWE in order to see beyond 4GB of RAM, if you upgrade to SQL 2012 you will be limited to only* that 4GB of physical RAM.
It’s time for you to move to a server and operating system that was released within the past ten years. If you are expecting to have more than 4GB of RAM, then you need to use the 64-bit version of SQL 2012.
Shannan on Transaction was deadlocked on… MOIZ on Subscriber Error: The row was…