SQL Server Performance

x32 to x64 and Extended Stored Procedures

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by jn4u, Jul 13, 2005.

  1. jn4u Member

    In some days we are getting a new sql server and we are upgrading from x32 to x64, We are going to use a Itanium 2 1.6GHz 6MB cpu and 4GB ram with a raid (0+1) system. Whit the use of the site I have been able to solve a lot of the problems. But I#%92m still a bit concern about systems “extended store procedures”.

    I understand that we have to recompile the code with the new x64, can somebody point me I the right direction? Are the any concerns? Problem?
  2. satya Moderator

    I don't think you need any special treatment on extended SPs, BTW do you have any user-defined ext.SPs on your database.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. jn4u Member

    hmm i don't understand what you mean? We have user-defined funtions that calls extended store procedures yes.
  4. jn4u Member

    thx<img src='/community/emoticons/emotion-7.gif' alt=':s' /> Kalle for the email. Provid parts of the mail.<br />&lt;From microsoft:<br />&lt;For databases that are migrating from SQL Server 2000 32-bit to SQL Server 2000 64-bit, the 32-bit extended stored procedures will &lt;not work with SQL Server 2000 (64-bit). The Microsoft Windows on Windows 64 (WOW) environment in 64-bit Microsoft Windows will not &lt;run 32-bit SQL Server extended stored procedures (.dlls). The 32-bit extended stored procedures must be recompiled with a 64-bit &lt;compiler to obtain the 64-bit .dlls. <br /><br />&lt;1: Srv.h. You must use the 32-bit version that is available in SQL Server 2000.<br />&lt;2: Opends60.dll. This file is available with SQL Server 2000 (64-bit). Opends60.dll is located in the MssqlBinn folder.<br />&lt;3: Opends60.lib. This file is available with SQL Server 2000 (64-bit). Opends60.lib is located at the root of the media.<br /><br /><br />

Share This Page