none
SQL2000 Query slow RRS feed

  • 问题

  • sql2000 SP4, Enterprise Edition
    WIN2003 R2, Enterprise Edition
    server: hp xone quad-core
      memory 6g RAID5 array
    Force sql using 4G memory, the boot memory occupied 4.5G of memory
    Queries a statement about five minutes, very slow.
    The windows task manager to view, query memory did not change, no significant changes in the CPU occupancy, about 8%

    Small database, a total of only 880M
    100 000 data estimated also check out month data also 5000

    DELPHE compiled software, connection with BDE

    use sql query7 seconds,thencheckwiththe client softwareorthree minutes,Profiler statement with check directly in the sql query analyzer, only 7 seconds,,Rebuild the index the same effect as

    Using a PC without raid, the same effect

    sql2000 SP4 企业版  
    WIN2003 R2 企业版
    服务器hp 志强 四核 6g内存 RAID5阵列
    已经强制让sql 使用4G内存, 开机内存就占用 4.5G内存
    现在查询一条语句大概5分钟,很慢,
    查询时用windows的任务管理查看,内存没变化,CPU占用无明显变化,大概8%使用

    数据库不大,一共才880M
    估计也就10W条数据,查询出来一个月数据,也就5千条吧

    用事件探查器把语句跟下来,直接在sql查询分析器查,只用7秒,重建索引效果一样,DELPHE编的软件,用BDE连接的,

    使用PC无raid,效果一样

    2012年4月7日 7:30

答案

全部回复