Results 1 to 12 of 12

Thread:

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User bai_vlado's Avatar
    Join Date: Sep:2005
    Location:
    Posts: 2,290

    . :
    IBM x3650 M4
    CPU: Intel Xeon Processor E5-2697 v2 "2,70 GHz
    RAM: 128 GB
    + SAS .

    , , .
    Windows Server + MS SQL 100 .
    :
    1. CPU - : Intel Xeon Silver 4210 10C 2.20 GHz ?
    2. 128 GB RAM ? SQL , , ?
    3. HDD - SSD ? RAID1 RAID10?
    LZ1SQL

  2. #2
    Repair! lattante's Avatar
    Join Date: Apr:2005
    Location:
    Posts: 2,766
    ,

    /? RAM .
    Enterprise SSD- , , SAS HDD
    OS- hdd/ssd, 2 ssd- RAID1. - RAID5 3 x1TB 2TB i fault tollerance 1 drive, RAID6 4x1TB 2TB fault tollerance 2 drives. RAID10 s 5x1TB - 2TB fault tollerance 1 drive, 4 , 1 hdd/ssd.
    , , / .
    Right to repair!

  3. #3
    Registered User bai_vlado's Avatar
    Join Date: Sep:2005
    Location:
    Posts: 2,290
    Quote Originally Posted by lattante View Post
    ,

    /? RAM .
    Enterprise SSD- , , SAS HDD
    OS- hdd/ssd, 2 ssd- RAID1. - RAID5 3 x1TB 2TB i fault tollerance 1 drive, RAID6 4x1TB 2TB fault tollerance 2 drives. RAID10 s 5x1TB - 2TB fault tollerance 1 drive, 4 , 1 hdd/ssd.
    , , / .
    ,
    24/7 150 . . 15 , .
    :
    1. OS - 2500 GB RAID1
    2. DataBase - 1 TB , . RAID10. RAID6 ?
    3. 2x1TB RAID1

    . 10-12 000 .

    / , , , .
    LZ1SQL

  4. #4
    Registered User barabata's Avatar
    Join Date: May:2003
    Location:
    Posts: 1,568
    . - .
    Raid 6 . Raid 6 Raid 5 - .
    stripe size .
    - Asus ROG Strix SCAR G733QR - Ryzen 5800H/16GB DDR4/RTX 3070
    - Fujitsu Celsius H760 - i7-6820HQ/32GBDDR4/Quadro M1000M/m2PCIe - 1TB SSD/ SATA - 4 B SSD / 2 TB SATA in caddy/
    /Hidden:

  5. #5
    Master of Orion adept's Avatar
    Join Date: Mar:2005
    Location: Sofia
    Posts: 10,065
    Quote Originally Posted by bai_vlado View Post
    ,
    24/7 150 . . 15 , .
    :
    1. OS - 2500 GB RAID1
    2. DataBase - 1 TB , . RAID10. RAID6 ?
    3. 2x1TB RAID1

    . 10-12 000 .

    / , , , .
    RAID 10 , - / . spare . , "" .. .
    SSD- , 8
    - , .
    , SQL , . -.
    Quote Originally Posted by drx View Post
    , ? !

  6. #6
    Registered User
    Join Date: Oct:2002
    Location: Sofia
    Posts: 233
    , 4-5 . MS SQL Microsoft Dynamics 64 30 . , . , 10 - .

  7. #7
    Registered User
    Join Date: Aug:2008
    Location: Varna, BG
    Posts: 807
    Quote Originally Posted by bai_vlado View Post
    . :
    IBM x3650 M4
    CPU: Intel Xeon Processor E5-2697 v2 "2,70 GHz
    RAM: 128 GB
    + SAS .

    , , .
    Windows Server + MS SQL 100 .
    :
    1. CPU - : Intel Xeon Silver 4210 10C 2.20 GHz ?
    2. 128 GB RAM ? SQL , , ?
    3. HDD - SSD ? RAID1 RAID10?
    , , ( , ) .

    1. SQL Per Core - - . , 12 Intel Xeon Silver 4210 10C 2.20 GHz ... .
    2. , - , , Page Life Expectancy . 5 , 1000+ , 128 . 128 , SQL Server, PLE MAX Server Memory - RAM. Memory pressure
    3. - , , ... , 5 6( ) - ( - ) 10 , . , ... - , . .

    15 . ? 15
    , AzureSQL, SQL 10-12 - .

    ,

  8. #8
    MU FOREVER mitaka-bs's Avatar
    Join Date: Sep:2002
    Location: Burgas
    Posts: 3,088
    Quote Originally Posted by banshee79 View Post
    , , ( , ) .

    1. SQL Per Core - - . , 12 Intel Xeon Silver 4210 10C 2.20 GHz ... .
    2. , - , , Page Life Expectancy . 5 , 1000+ , 128 . 128 , SQL Server, PLE MAX Server Memory - RAM. Memory pressure
    3. - , , ... , 5 6( ) - ( - ) 10 , . , ... - , . .

    15 . ? 15
    , AzureSQL, SQL 10-12 - .

    ,
    !
    , SQL - 10 + ! .
    , Xeon Gold 5222 4-cores 3.8 GHz !
    VMware vSphere , / / SSD , 5/10 / ! , ..
    Last edited by mitaka-bs; 27th April 2021 at 07:29.

  9. #9
    Master of Orion adept's Avatar
    Join Date: Mar:2005
    Location: Sofia
    Posts: 10,065
    , . - , , bottleneck- . 150 , , , ( ) custom .
    VMWare - , , Hyper-V ( ), .
    Quote Originally Posted by drx View Post
    , ? !

  10. #10
    Registered User bai_vlado's Avatar
    Join Date: Sep:2005
    Location:
    Posts: 2,290
    . .
    - - . 10% . SQL-a.
    - banshee79 . - 128 .
    , 10 . RAID10 5 , .

    MS Navision 4, Microsoft Dynamics WMS . Dynamics-a, azure .

    , -. .
    Windows SQL? VPN-a , .
    LZ1SQL

  11. #11
    Registered User
    Join Date: Aug:2008
    Location: Varna, BG
    Posts: 807
    ? (MAXDOP=1) 100%, 10%, ... - , Dynamics 365 Business central . .. - . , OS SQL .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |