Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
badboyhouse
Starting Member
1 Post |
 Posted - 2012-08-07 : 11:31:07
|
| I'm considering changing our Windows Server 2008 member server from 32-bit to 64-bit to be able to take advantage of higher memory limits.We have standard SQL Server 2008 for which we have the 32-bit and 64-bit discs (we go these with SBS 2008 Premium).If I was to put Server 2008 64-bit and SQL 2008 64-bit on the member server, and install more RAM, would this be all that's required for SQL to "see" and make use of the extra ram?Nothing else runs on the server apart from SQL Server 2008.Currently it has the 4GB max memory installed. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-08-07 : 11:47:06
|
| Yes, it will see all RAM that's available when it starts. I believe Enterprise Edition will recognize hot-add RAM as well. |
 |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2012-08-10 : 16:16:28
|
| One huge 'gotcha' is the lack of a 64 Bit JET driver... So if you are handling Excel files, realize that there is a replacement ACE driver for the JET driver. You will probably have to make code adjustments and some. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-10 : 16:19:34
|
quote:
Originally posted by dmaxj
One huge 'gotcha' is the lack of a 64 Bit JET driver... So if you are handling Excel files, realize that there is a replacement ACE driver for the JET driver. You will probably have to make code adjustments and some.
or you need to use 32 bit runtime when you run SSIS packages with excel connection managershttp://visakhm.blogspot.com/2011/12/dtexec-issues-running-ssis-packages-in.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2012-08-10 : 17:28:28
|
| Good point, but I was referring to the use of OPENROWSET or OPENQUERY in stored procedures, etc... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-10 : 17:30:15
|
quote:
Originally posted by dmaxj
Good point, but I was referring to the use of OPENROWSET or OPENQUERY in stored procedures, etc...
yep...i got iti was referring to work around on SSIS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
SQL Server 2008 - Any gotchas on 64-bit??