June 4, 2013 at 1:48 pm
OK, I am in charge of specifying our new SQL server, our server now is 5 years old and we are seeing some performance issues. We are a small company and I am as close to a DBA as we have so bear with me.
A few questions keep coming up…
1. Physical or virtual? All of our servers now are virtual expect our SQL server.
2. Should the report server be on a separate server than the database?
3. We are running Backup Exec on our database server, is this ok?
Our current server is as follows, do you see any issues with this setup?
Dell Power Edge
• Windows server 2008 r2 sp1
• SQL 2008 r2 Standard
• 24 gb RAM
• 2x 4 core, Intel Xeon X5365 300GHz
• A single Raid 5 (4 SCSI 15000 rpm drives)
Thank you.
Also we are wanting to upgrade to SQL 2012
June 4, 2013 at 4:38 pm
Gosh... that's not a bad server (If it's 64 bit... don't know just by looking at processor numbers) especially for a small company. I believe I'd find some way to add some memory and change from RAID 5 to RAID 10 and use it for another 5 years. Maybe update the OS, as well.
Backup Exec is fine... just don't run it during peak hours. It's a bit agressive on the harddisk and the pipe.
Some folks will disagree but I think that VM would be an unnecessary complication, in this case.
Moving reporting to a different server won't hurt and usually helps.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 10, 2013 at 5:59 am
Thanks Jeff
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply