Recommend PC Specs for SQL Server
I currently have a desktop application which records transactions on a SQL Server 2008 R2 Express database. There are about 100+ branches which uses this app.
Now I need to create a central server which will be used for centralized reporting. The central database will be uploaded once a day with an approximate size of 1GB per day.
I have never worked with database with that size so I need some recommendations:
1. The application for the branches is currently using SQL Server 2008 R2 Express. Should I use SQL Server 2012 for the central server or just keep using 2008 R2? And what edition?
2. The branches are currently using Windows 7. Is it ok to just use Windows 7 for the central server or is it better to use windows server?
3. Would a standard desktop PC be ok or is there a "server" PC? The computer would be in use 24/7.
4. Recommended processor and memory. Around 1GB of data per day.
Thanks
Now I need to create a central server which will be used for centralized reporting. The central database will be uploaded once a day with an approximate size of 1GB per day.
I have never worked with database with that size so I need some recommendations:
1. The application for the branches is currently using SQL Server 2008 R2 Express. Should I use SQL Server 2012 for the central server or just keep using 2008 R2? And what edition?
2. The branches are currently using Windows 7. Is it ok to just use Windows 7 for the central server or is it better to use windows server?
3. Would a standard desktop PC be ok or is there a "server" PC? The computer would be in use 24/7.
4. Recommended processor and memory. Around 1GB of data per day.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all the suggestions!
I missed this comment. Forget using a desktop for hosting this. Buy a real server, host it in a secure location and stick to 2008 R2 if you don't need high availability. Get some help into determining the performance profile of the application to size it up properly.