INTRO

1
INTRO
education solutions development inc.
64-bit Processing
ANUA 2008, Fort Lauderdale
2
64 BIT EXPLAINED
64-BIT PROCESSING IS HERE!
64-BIT PROCESSING EXPLAINED

• More processing power
• 32 bit 32 binary instructions per clock cycle.
• 64 bit 64 binary instructions per clock cycle.
  Twice the processing power (double the number of
  instructions per clock cycle).
• Immediate performance boost on this alone.
• Able to use more RAM
• 32bit max 4gb limit (really a 2gb b/c 2gb used by
  OS)
• 64bit (theoretical) max 16 exabytes!
  (16,000,000gb of RAM)
• Limited by HW and OS maximum RAM allowed.
• Most 64 bit system limited to somewhere between
  8GB and 256TB
• Native access to virtually unlimited RAM
  provides the most significant performance boost.

3
64 BIT EXPLAINED
64-BIT PROCESSING IS HERE!
64-BIT PROCESSING EXPLAINED 32-bit addressing

• 32-bit processors have address registers that
  are 32-bit wide (can address up to 4GB RAM)
• Each individual process gets it own virtual
  address space that can be up to 4GB
• This virtual address space is divided system
  and user space, by default 2 GB each
• The user space can be extended to 3GB with the 4
  GB Tuning feature
• /3GB flag 4GB Tuning Feature reduces system
  space to 1GB.
• Add to boot.ini file and reboot to take affect

4
64 BIT EXPLAINED
64-BIT PROCESSING IS HERE!
64-BIT PROCESSING EXPLAINED 32-bit Memory

• PAE and AWE methods to make x86 (32-bit)
  servers use more RAM
• These methods are useful to get more out of
  your 32-bt servers but
• These methods add a translation layer to memory
  access slower than direct memory access
• Memory split into two parts is not as efficient
  as memory in one segment
• 32-bit systems with 8GB RAM may not perform much
  better than systems with 4GB RAM
• Memory above 4GB can only be used for Buffer
  cache
• Buffer Cache does not support user connections
  all user connections must be supported from
  memory (lt3GB)

5
64 BIT EXPLAINED
64-BIT PROCESSING IS HERE!

• Much larger direct-addressable memory space (AWE
  not used)
• Better on-chip cache management
• Improved multiprocessor performance
• Enhanced on-processor parallelism
• Increased bus and I/O bandwidth for faster and
  wider throughput
• Faster clock speeds
• x64
• versatility (runs 32-bit and 64-bit) eases
  transition to 64-bit
• more affordable than IA64 (Itanium)

6
What makes up a 64 bit server?
64-BIT PROCESSING IS HERE!

• What makes up server 64 bit?
• Hardware (Server/CPU)
• Application Software
• Operating System
• SQL Server, Reporting Services, IIS, etc.
• Drivers, etc.
• Application Software

7
CPU CHOICES
64-BIT PROCESSING IS HERE!
64-BIT CPU CHOICES

• Server platforms are now 64-bit ready
• You have choices about the server(s)
  configuration
• You even have a choice about the type of 64-bit
  to run.
• IA64 architecture
• x64 architecture

8
CPU CHOICES
64-BIT PROCESSING IS HERE!
64-BIT CPU CHOICES IA64 (Intel Itanium)

• Runs 64-bit Windows Operating System, drivers
  and software specifically compiled for the
  Itanium instruction set
• Cannot act like an x86 (32-bit) processor or
  boot 32-bit Windows Operating System
• Does not run version of Windows or 64-bit
  drivers compiled for x64
• For some programs, has ability to run 32 bit
  emulation but this runs slower and does not run
  all apps in this mode
• Notably, SQL Server will not run in 32-bit
  emulation mode on IA64

9
CPU CHOICES
64-BIT PROCESSING IS HERE!
64-BIT CPU CHOICES IA64 (Intel Itanium)

• Aimed at very larger processing environments
• Can use up to 64 CPUs
• Massive scalability Many more than 5000
  concurrent users (has been tested up to 30,000
  concurrent users)
• Much more expensive (Costs of Server, OS and all
  required Software go up)

10
CPU CHOICES
64-BIT PROCESSING IS HERE!
64-BIT CPU CHOICES x64

• Vendors
• AMD OPTERON, AMD64
• Intel - XEON with EM64T and Pentium IV with
  EM64T
• Runs 64-bit Windows Operating System, drivers
  and software specifically compiled for the x64
  instruction set
• Runs 32-bit software without recompilation
• Does not run Itanium (IA64) versions of Windows
  Operating System nor drivers compiled for Itanium.

11
OS REQUIREMENTS
64-BIT PROCESSING IS HERE!
64-BIT SOFTWARE REQUIREMENTS

• OS WINDOWS SERVER 2003 64-bit VERSIONS
• Drivers
• .Net Frameworks
• SQL Server 64-bit Versions (including Reporting
  Services)

12
OS REQUIREMENTS
64-BIT PROCESSING IS HERE!
64-BIT SOFTWARE REQUIREMENTS

• OS WINDOWS SERVER 2003 64-bit VERSIONS
• Windows Server 2003 Family

13
OS REQUIREMENTS
64-BIT PROCESSING IS HERE!
64-BIT SOFTWARE REQUIREMENTS

• .Net Frameworks

14
OS REQUIREMENTS
64-BIT PROCESSING IS HERE!
64-BIT SOFTWARE REQUIREMENTS

• SQL Server 64-bit
• SQL Server Versions and Platforms

15
ASP.NET AND 64-BIT
64-BIT PROCESSING IS HERE!
ASP.NET and .NET FRAMEWORK

• .Net 1.1 runs 32 bit applications.
• .Net 2.0 runs 32 bit applications.
• .Net 2.0x64 runs 64 bit applications
• .Net 1.1 apps running on a 64 bit server can
  still get a performance boost.
• The ASP.Net process (w3wp.exe) will run in up to
  4GB of RAM per process on 64 bit server (limited
  to 2GB on 32bit server)
• The .NET Common Language Runtime (CLR) compiles
  the application by using the .NET Just-In-Time
  (JIT) compiler and executes them as native 64-bit
  - with no source-code changes.
• Beware IIS 6.0 cannot run in both 64 bit mode
  and 32 bit mode at the same time.
• The current APECS and DISCOVERY apps are being
  modified to use .Net 2.0 framework.
• This will provide a performance boost when run on
  64 bit server

16
SQL2005 AND 64-BIT
64-BIT PROCESSING IS HERE!
SQL Server 64-BIT

• SQL 2005 components that will benefit from
  64-bit
• DB Engine
• Table / Index partitioning
• Failover clustering
• db consolidation
• Integration Services
• Analysis Services
• Reporting Services
• Large and complex reports will greatly benefit
• SSRS uses a lot of memory, so expect a big boost
  here
• The DB Server and Report Server will use the
  most CPU and RAM this is where you will get the
  most gains in performance by going to 64-bit
• ADD MORE RAM TO DB SERVER

17
SQL2005 AND 64-BIT
64-BIT PROCESSING IS HERE!
64-BIT SQL SERVER

• Same codebase as 32-bit SQL Server
• All components able to take advantage of large
  virtual address space in SQL 2005
• Flat memory addressing (no need for AWE)
• 2 64-bit versions for SQL 2005 IA64 and x64
• Data file compatibility with 32-bit SQL
• Easy db migration and integration
• No changes in client apps when connecting to a
  64-bit backend and a 32-bit backend
• Massive scale-up support up to 64-way (with
  IA64) or 8-way with x64
• Compared to 32-bit SQL Server versions the
  64-bit SQL 2005 provides outstanding performance
• More workloads per u of rackspace, up to 50
  instances

18
SQL2005 AND 64-BIT
64-BIT PROCESSING IS HERE!
TAKE ADVANTAGE OF THE EXTRA HORSEPOWER

• DATABASE SERVER CONSOLIDATION
• Take advantage of (virtually) unlimited RAM with
  64-bit
• 32-bit limited to 2GB RAM (4GB total, but 2GB
  reserved for OS kernel)
• 64-bit on Windows 2003 OS may use up to 512GB
  RAM
• Lower Costs (fewer machines required)
• lower license fees
• lower hardware costs
• Greater ease of database administration
• fewer machines to manage

19
SQL2005 AND 64-BIT
64-BIT PROCESSING IS HERE!
TAKE ADVANTAGE OF THE EXTRA HORSEPOWER
Microsoft Clustering Service (MSCS) or other
vendor solutions (DoubleTake) 64-bits more
robust environment makes ACTIVE-ACTIVE a very
efficient option ACTIVE PASSIVE ACTIVE -
ACTIVE
20
SQL2005 AND 64-BIT
64-BIT PROCESSING IS HERE!
TAKE ADVANTAGE OF THE EXTRA HORSEPOWER

• Microsoft Clustering Service (MSCS) or other
  vendor solutions (DoubleTake)
• N1 Cluster architecture An even more efficient
  option, that gets more out of your investment in
  server hardware
• In case of a failure or one or more machines,
  64-bit will be able to withstand the load on the
  remaining servers.

21
OS REQUIREMENTS
64-BIT PROCESSING IS HERE!
64-BIT BUSINESS BENEFITS

• Meet increasing business demands
• Serve greater number of users
• Improve response times
• Make more efficient use of your data center
• Future proof you investment
• The tipping point for moving to 64-bit processing
  into the mainstream has been reached.

22
OS REQUIREMENTS
64-BIT PROCESSING IS HERE!
64-BIT IN-HOUSE PERFORMANCE TEST

• Test run of current production version of Apecs
  payroll calculation
• 3000 employees, 1777 getting paid
• 32-bit platform
• 32bit SQL Server 2000/ x86 Windows 2000 Server/
  x86 SSRS 2000
• 64-bit platform
• 64bit SQL 2005/ x86 Windows 2003 R2/ x86 SSRS
  2005
• 64bit 2005 version ran 37 faster than 32bit 2000
  version

23
OS REQUIREMENTS
64-BIT PROCESSING IS HERE!
64-BIT THINGS TO KNOW

• Check impact on 3rd party software
• Utilities
• Drivers
• Management tools
• SPs check versions (must be x64 or IA64
  versions)
• MSDN subscriptions (check versions installing)
• Get plenty of RAM