All about SQL Server X64 Edition (SSQA.net)

SQL Server - 64 bit drivers and issues

2008-12-01T07:22:00Z

SQL Server 64 bit edition, a primer to address the requirements surrounding applications and data are growing in complexity and size. Many applications running on 32-bit platforms today are approaching or have exceeded the limits of the platform, specifically regarding the number of processors and addressable memory. Not only for data explode there is a particular are where the scalability & performance for architecture has become prime responsibility to keep up the high availablity, not to mention...(read more)

Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process

2008-05-21T09:20:00Z

The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit based servers. This is a operating system based privilege that is required by SQL Server service account to allow locking of physical memory preventing OS paging of the locked memory. Within 32 bit architecture systems irrespective of edition i.e., standard, enterprise and developer editions, this privilege needs to be granted...(read more)

64 bit computing configuration with SQL Server 2005 - what you can take-on?

2008-04-23T23:31:00Z

It has been a while in posting X64 related information here, so that comes now about configuration gotchas you may need, for a starter though. X64 computing platforms have become common installations now a days due to the hardware reduced costing and availability, at the same time the DBA will have big job to tune the platform in terms of manageability & performance. In this regard running ERP application such SAP product is supportable on SQL Server Enterprise edition within 32-bit and 64-bit...(read more)

How to find which types [32bit or 64bit] and versions of SQL Server can be installed?

2007-12-20T14:09:00Z

As there are more tools defaulted to 32 bit it is bit confusing for the software applications that will support X64 based installations. IN the same manner it is a common question out in the newsgroups referring to which types and versions of SQL Server can be installed. Say for instance on X86 based system SQL Server 2000 or 2005 can be installed which is by default a 32-bit application. So for x64/EMT64, and IA64 servers it is bit confusing and also with evolution of SQL Server 2005 that has different...(read more)

What are advantages of 64-bit system in relation to SQL Server?

2007-12-19T14:40:00Z

We have most of our database systems on 64-bit environment, but one of the application user asked the question what is the advantage of a 64-bit environment in relation to SQL Server application. I would say with the evolution of SQL Server 2005 it has opened many more differentiation between 32- and 64-bit editions and bit hard for the application to deploy the 64-bit edition among those who would benefit most from it. Basically if your database system such as Data Mining or Data Warehousing application...(read more)

Installing SQL Server Integration Services on 64-bit Computers

2007-11-19T14:29:00Z

I had tough time working with Integration Services (SSIS) on one of the 64 bit machine that will be used for a 24/7 based application. So here goes my ranting and things you need to take care when having installation of SQL Server 2005 on 64 bit platform, specially within ETL processes completion. So at first, when you install SQL Server 2005 and select both Integration Services and Business Intelligence Development Studio, as this it to ensure to have both 32 & 64 bit type of components installed...(read more)

Installing SQL Server X64 on a 64-bit Operating System - problem with .NET framework package

2007-09-12T14:40:00Z

I have had problem when installing SQL Server 2005 on one of the 64-bit server, the error was: There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. So as per the message I have looked in to the specified directory for the logs which is " C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files" and only error I could see is: Error Code: 0x80070643 (1603) Windows Error Text: Fatal error during installation....(read more)

Number of databases limit for Database Mirroring within X64 environment?

2007-08-30T10:27:00Z

We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server application too. So now the question is will there be any limit on the number of databases to involve in this type of setup. Each database will not grow beyond 25GB in next 3 years and few of them are 24/7 type of applications within minimum database...(read more)

SQL Server Express installation on X64 platform?

2007-08-28T11:05:00Z

Can we get install SQL Server Express 2005 edition on X64 environment? Yes and No. Yes for SQL Server Express on X64 and EMT64 that too in Windows on Windows ( WOW ), but No it is not supported on IA64 systems. This enhancement is enabled since the service pack2 release of SQL Server Express 2005 edition. So on the above enabled X64 platforms if you are developing any applications then looking to submit the bugs then refer to Connect Feedback Center and above all don't forget to RegisterHere your...(read more)

32bit vs 64 bit what other factors you need to consider?

2007-08-14T13:16:00Z

Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of the reason that memory has been a constraint on scaling-up server capacity. Once you consider that on a Windows system or any application, half of this is reserved for the system address space (aka PAE with /3GB switch is used in boot.ini) the remaining...(read more)

Why 64-bit SQL Server been slow during query performance?

2007-08-11T09:34:00Z

As usual for every performance issue there are many considerations that need to be evaluated when determining how to investigate the root cause for slower performance of many SQL Server databases. I would suggest that an important consideration is whether to use a 64-bit platform or a 32-bit platform to get the best performance results, though 64-bit platform offers some advantages over the 32-bit platform in this regard. When it comes to hosting databases on 64-bit usage of heterogenous workload...(read more)

Whats with 64 bit computing on SQL Server

2007-08-04T14:41:00Z

What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage of these systems is with 64-bit editions of Microsoft Windows products. Same way SQL Server has evolved in using 64 bit computing from SQL Server 2000 version onwards, so what improvements you can take advantage with this technology. For me it is with...(read more)