登录
 
主页技术资源库学习下载支持社区论坛
IT 专业人士的资源 >
> 
> 
SQl Server performance on Dell R715 with AMD processor and Raid 5 Configured Hard disk setup

已答复 SQl Server performance on Dell R715 with AMD processor and Raid 5 Configured Hard disk setup

  • 2012年4月17日 6:09
     
     
    登录进行投票
    0

    Hi Support

    My server configuration   Dell R715,  duel AMD Processor opteron 6238 2.60Ghz , RAID 5 (PERC H700) raid controller, configured hard disk size 600*3 usable size is 1200Gb,  64Gb Ram size. having 4 gigabit Ethernet port.

    Installed application: OS windows 2008R2 enterprise edition with sp1 and SQL Server 2008R2 enterprise with sp1.

    for execute small SQL queries its takes more then 30 to 45 seconds.

    But same application installed HP  DL120 G6 server having Intel Xeon X3430 2.4Ghz processor 8Gb Ram 1*500GB hard disk  having 2Gigabit NIC card.

    Installed application: OS windows 2008R2 enterprise edition with sp1 and SQL Server 2008R2 enterprise with sp1.

    for execute small SQL queries its takes more then 3 to 5 seconds.


    Hp server works supper fast then high end dell server. Please let me know which configureation wil suit for running SQl Server.



     

全部回复

  • 2012年4月17日 6:55
    版主
     
     已答复
    登录进行投票
    0
    Hi,
     
    According to the description, the issue seems to be related to SQL Server. As we mainly focus on the Hyper-V question about Windows Server system and here is not the best support resource for SQL Server, it is recommend you to get further support in the corresponding community so that you can get the most qualified pool of respondents. Thanks for your understanding.
     
    For your convenience, I have list the related link as followed.
     
     

    Vincent Hu

    TechNet Community Support

     
  • 2012年4月28日 9:19
     
     
    登录进行投票
    0

    Hi Suresh

    I have a similar problem on the same hardware Dell R715; in my case I have a cluster of 2 R715, equal processors, with HyperV and SQL Server 2005 on some VMs. The same VMs on a cluster of 2 Proliant DL585 G5 have performances 3 to 1. We don't understand because these R715 are so slow, we think the problem is relating network cards. Have you olved your problem?

    Best regards

    Gianni Lauritano

     
  • 2012年9月5日 11:33
     
     
    登录进行投票
    0
    Katell and Lauritano,  I have very similar config, and similar problem, have you solved the problem ? We tested EVERY BIOS parameter of our R715, nothing improved. The only thing that improves on single queries is to limit number of cores per CPU to 4 !!