0
votes
1answer
250 views

SQL Server 2005 SP3 Failover Cluster Node Replacement Service Pack

2-node SQL Server 2005 SP3 (9.0.4226) Failover Cluster running on Windows Server 2003 R2 x64 SP2. My passive node suffered a RAID failure on the OS partition. I evicted the failed node, rebuilt it, ...
4
votes
5answers
263 views

Justifying a memory upgrade

My employer has over a thousand servers (running SQL Server 2005 x64 and a couple of other apps) all across the country. And in my opinion they are all massively underpowered for what they need to ...
2
votes
0answers
452 views

SQL CLR not properly enabling

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit. We have run sp_configure and reconfigured the server which indicates that the clr is now enabled. ...
6
votes
7answers
19k views

How much RAM does a server actually need?

I have a quite a few servers deployed around the world. They are running Windows 2003 x64 with SQL Server 2005 x64 with 6 GB of RAM. The boxes do not have the best (or even an acceptable) ...
0
votes
3answers
112 views

Are there any potential problems moving from 32 bit Enterprise to 64 bit Standard SQL Server 2005

I've been looking at an upgrade to my SQL Server 2005 Enterprise edition. I'm specifically looking to upgrade as I'm hitting the limit of my 2 CPUs at the moment. It looks like I could move to 64 bit ...
2
votes
3answers
502 views

Performance of Locked Pages v Native memory on 64 bit SQL2005/2008

I understand that setting the lock pages in memory privilege to the service account housing SQL2005/2008 services on a 64 bit system uses the AWE API and effectively stops SQL's buffer pool from being ...
1
vote
1answer
2k views

SQL Server 2005 x64, configuring maximum server memory

I'm a bit of a newbie to configuring SQL server, and have just had to set up a new Server 2008 x64 machine with SQL 2005 x64. Everything seems to be running well, however I have a question regarding ...
6
votes
4answers
29k views

SQL Server Installation: Is it 32 or 64 bit?

Recently I was performing an OS upgrade on one of our DB servers, moving from Server 2003 to Server 2008. The DBMS is SQL Server 2005. While reinstalling SQL on the new Windows installation, I went to ...
3
votes
7answers
7k views

Unable to connect SQL Server instance from Visual Studio 2008 SP1 on Vista x64

I installed on a Vista x64 machine Visual Studio 2008 SP1 (with integrated SQL from the installation package) and when I try to add an MDF file to a project or to the App_Data when working with web, I ...
2
votes
10answers
597 views

SQL2005 vs SQL2008

We are investigating replacing an existing SQL2000 server on Windows2003 (32Bit) with new hardware and a newer version. We are looking at an application that requires at least SQL2005, but will run ...
2
votes
4answers
435 views

SQL Server 2005 on 64-bit, Memory > 3GB

Does AWE help on a 64-bit server? The option is still available. Does it do anything?