We had a SQL Server 2000 Server running on a Windows 2003 Server with 4GB of RAM, RAID 5. We were experiencing slow performance. So we purchased a new Windows 2003 Server with 4GB of RAM, RAID 5, and upgraded to SQL Server 2005.
The applications seem to read from the databases fine, but saving records is slow, sometimes, even causing the application to stop responding.
Any help here, I am new to SQL Server and don't even know where to begin.