1. 论坛系统升级为Xenforo，欢迎大家测试！
    Dismiss Notice

SQL服务器紧急求助

Discussion in '主机讨论' started by ehying, Dec 30, 2005.

  1. ehying

    ehying New Member

    Joined:
    Dec 2, 2005
    Messages:
    2
    Likes Received:
    0
    Intel Xeon 2.8G*2（4路cpu资源）
    1GB DDR ECC REG内存
    73GB SCSI 10000转高速硬盘
    2U机架式专用服务器机箱
    百兆共享带宽,不限流量,保证10M带宽

    这款服务器我放sql,一到白天CPU就占用100,打开速度狂慢,只有晚上和凌晨才能较快的打开,独立IP在三万-七万之间,各统计器的数据不一样，大家帮忙分析一下是什么原因,

    要不大家帮忙推荐一款能流畅访问的服务器
     
    #1 ehying, Dec 30, 2005
  2. 小叶

    小叶 New Member

    Joined:
    Sep 4, 2005
    Messages:
    17,941
    Likes Received:
    33
    流量比较大,如果程序比较垃圾的话,估计会占很高资源.
     
    #2 小叶, Dec 30, 2005
  3. Tameway

    Tameway New Member

    Joined:
    Sep 6, 2005
    Messages:
    1,286
    Likes Received:
    8
    内存太小了。。。。关系数据库对内存的要求很高，内存小会使得DMA通道过于繁忙，许多其他问题都要CPU来中断处理
     
    #3 Tameway, Dec 30, 2005
  4. langyufeng

    langyufeng New Member

    Joined:
    Sep 27, 2005
    Messages:
    33
    Likes Received:
    0
    建议首先分析到底是什么占了大部分资源，如果是sql server，那么对数据库和程序进行优化，看效果
     
    #4 langyufeng, Jan 1, 2006
  5. ehying

    ehying New Member

    Joined:
    Dec 2, 2005
    Messages:
    2
    Likes Received:
    0
    在高峰期SQL占用了70%-80%,用的程序是动易+bbsxp论坛
     
    #5 ehying, Jan 1, 2006
  6. langyufeng

    langyufeng New Member

    Joined:
    Sep 27, 2005
    Messages:
    33
    Likes Received:
    0
    那能不能对sql服务器进行调优呢？
     
    #6 langyufeng, Jan 2, 2006
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)