SQL Server Configuration
Posted on 2011-10-22
SQL Server environment is 4 years old, looking to update/upgrade for performance, space, etc.
Hosts internal ERP solution. DB is about 50G in size and growing at about 15G/year. Between 150-200 users access site concurrently.
Current install is SQL Server Standard 2005, we do have license for SQL 2008 Enterprise.
Use Sage ACCPAC and DBs are also hosted there on same instance. (3 separate DBs) About 15 users making use of these DBs.
SQL Server Reporting Services is used and also on the same server instance.
Operation is 24/7 as it supports manufacturing environment. Some downtime is allowed for PM in slow season or some off weekends.
Looking for recommendations for configuration for ultimate performance. Budget is not determined at this point as the goal is performance. Let me know your thoughts/recommendations.