


There is a problem with missing end tag for the node. Jonathan also mentioned in the article that there is a bug in the output of deadlock graph from the Extended Events, in which it is not a valid XML. In the article, Jonathan showed us the way to retrieved the deadlock graph from Extended Events. Someone forwarded an article written by Jonathan Kehayias ( blog | twitter), an expert in Extended Events, regarding this. Fortunately there is a way to retroactively retrieved deadlock information starting with SQL Server 2008 using Extended Events. However, unfortunately we did not have trace flag 1204 and/or trace flag 1222 turned on. We were dealing with some deadlock problems in our database. Noticed that it is WOW64 (Windows 32-bit on Windows 64-bit). 60 (Intel X86)Įnterprise Evaluation Edition on Windows NT 6.1 (Build 7601: Service Pack 1) (WOW64) Once it has been installed, when you check the SQL Server version using: SELECT SQL Server 2012 installation, you should get something like the following: You can kick off the 32-bit installation process, by running the following command:Īs a matter of fact, you can use the X86=true in the command line or answer file if you want to have unattended installation of SQL Server 2008, 2008 R2 or 2012.

You should then be able to select to install the 32-bit (x86) of the SQL Server.

When you insert the installation media, or mount the ISO image, in some cases you might need to double click on the setup.exe, you will be presented with the SQL Server Installation Center. If you have installation media or ISO image that contains both 32-bit and 64-bit version of SQL Server 2008, 2008 R2 or 2012, here’s how you can install the 32-bit SQL Server on 64-bit Windows (圆4). Looking at the hardware and software requirements for SQL Server 2008, 2008 R from Microsoft site, we should be able to install 32-bit version of SQL Server onto 64-bit (圆4) Windows operating system.
