1 / 7

SQL Server 64bit

Colorado PASSCamp 2006. SQL Server 64bit. Joshua Jones Database Administrator Wall Street On Demand. Overview. SQL Server 64bit Support Architecture Overview x64, Itanium, Windows Implementation Case Study Summary Q&A. Colorado PASSCamp 2006. SQL Server 64bit Support. SQL 2005

rusk
Download Presentation

SQL Server 64bit

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Colorado PASSCamp 2006 SQL Server 64bit Joshua Jones Database Administrator Wall Street On Demand

  2. Overview • SQL Server 64bit Support • Architecture Overview • x64, Itanium, Windows • Implementation • Case Study • Summary • Q&A Colorado PASSCamp 2006

  3. SQL Server 64bit Support • SQL 2005 • Standard, Developer, and Enterprise • x64 and Itanium • Supports all Tools • SQL 2000 • Enterprise • Itanium and x64 (x64 support added by SP4) • Only Service Manager, Server Network Utility, and the CMD line tools • Windows Server 2003 only Colorado PASSCamp 2006

  4. Architecture Overview • 64bit Processors • Itanium • EM64T • AMD64 • 64bit Advantages • Floating Point Calculations • Memory Addressing Colorado PASSCamp 2006

  5. Implementation • Case Study • Migrating 32bit SQL Server 2000 servers to 64bit SQL Server 2005 • Environment • OLTP Processing • Multiple Instances per server • Log Shipping; 3rd party vendor • In House Data Access Layer • NT 4 Domain • Windows 2000 to Windows 2003 Colorado PASSCamp 2006

  6. Implementation – cont’d • Case Study – cont’d • Preparation • Upgrade Advisor • AMD64 HP DL 385 Dual Core • Challenges • Antiquated 3rd party backup software • SQL-DMO • Security issues • Linked Servers with 2000 SP4 • DTC • KERBEROS • Benefits • PERFORMANCE • SQL 2005 Features Colorado PASSCamp 2006

  7. Summary • 64bit Recommendations • x64 instead of Itanium • Lots of Memory • Lock Pages in memory • TEST • Q&A Colorado PASSCamp 2006

More Related