locked
Building a new SQL server RRS feed

  • Question

  • 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
    Tuesday, June 4, 2013 8:39 PM

Answers

  • Hello,


    The only thing I would change on that server is the storage. RAID 10 will perform better.

    I don’t see a reason to change a server like that. If you are not decided to buy the new server, I would love to see the result of the following query:

    select top 50 *

    from sys.dm_os_wait_stats

    order by wait_time_ms desc

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Fanny Liu Wednesday, June 5, 2013 1:43 AM
    • Marked as answer by Fanny Liu Tuesday, June 11, 2013 1:33 AM
    Tuesday, June 4, 2013 9:14 PM