Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
SQl Server performance on Dell R715 with AMD processor and Raid 5 Configured Hard disk setup

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

  • Dienstag, 17. April 2012 06:09
     
     
    Anmelden
    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.



     

Alle Antworten

  • Dienstag, 17. April 2012 06:55
    Moderator
     
     Beantwortet
    Anmelden
    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

     
  • Samstag, 28. April 2012 09:19
     
     
    Anmelden
    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

     
  • Mittwoch, 5. September 2012 11:33
     
     
    Anmelden
    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 !!