鎽� 瑕侊細鍦ㄥ熀浜庡皪鐭虫补骞宠嚭娴锋按铏曠悊鐨勫伐钘濆京(f霉)闆滄€у拰娴蜂笂鐭虫补鐢熺敘(ch菐n)鐠�(hu谩n)澧冩儭鍔ｆ€х爺绌剁殑鍩虹(ch菙)涓�锛岀祼(ji茅)鍚� DCS绯荤当(t菕ng)鐨勫劒(y艒u)瓒婃€э紝閬嬬敤Rockwell RSView32绲勬厠(t脿i)杌熶欢鐮旂┒骞跺鐝�(xi脿n)浜嗙煶娌瑰钩鑷烘按铏曠悊DCS绯荤当(t菕ng)锛屽鐝�(xi脿n)浜嗗皪骞宠嚭姘磋檿鐞嗗伐钘濆悇瀛愰亷绋嬬殑鍒嗘暎鎺у埗鍜岃閲囬泦淇℃伅鐨勯泦涓鐞�銆傝┎绯荤当(t菕ng)鏄疍CS鎶€琛�(sh霉)鍦ㄦ捣涓婄煶娌圭敓鐢�(ch菐n)涓殑閲嶈鎳�(y墨ng)鐢�锛屽叾闀锋湡閬嬭锛岃瓑鏄庝簡绯荤当(t菕ng)鐨勭┅(w臎n)瀹氭€ц垏鍙潬鎬�锛屾彁楂樹簡娴蜂笂鐭虫补鐢熺敘(ch菐n)鏁堢巼锛岀⒑淇濅簡娴蜂笂宸ヤ綔浜哄摗鐨勫畨鍏�銆�

闂�(gu膩n)閸佃锛�DCS;鐭虫补骞宠嚭;RSView32;娴锋按铏曠悊;閬庣▼鐩�(ji膩n)鎺�;鏁�(sh霉)鎿�(j霉)绠＄悊

Abstract: On the base of research on the complexities of platform seawater treatment process and the difficulties of petroleum production on the sea, this paper integrates Distributed Control System 锛圖CS锛� technology to construct the DCS of Platform Seawater Treatment 锛圥STDCS锛� with the help of the configuration software-Rockwell RSView32. The system, as one important application of DCS technology in petroleum production on the sea, realizes to control platform seawater treatment process and manage all collected information data. Its application enhances the productivity of petroleum production and insures worker’s personal safety on the sea.

Key words: DCS; Platform; RSView32; Seawater Treatment; Process Monitoring and Control; Data Management

涓€銆佸紩瑷€

闆嗘暎鎺у埗绯荤当(t菕ng)锛圖CS锛夋槸涓冨崄骞翠唬涓湡鍑虹従(xi脿n)鐨勶紝瀹冩槸瑷堢畻姗燂紙Computer锛夋妧琛�(sh霉)銆佹帶鍒讹紙Control锛夋妧琛�(sh霉)銆侀€氳▕锛圕ommunication锛夋妧琛�(sh霉)鍜孋RT椤ず鎶€琛�(sh霉)锛堢啊绋卞洓C鎶€琛�(sh霉)锛夌浉绲�(ji茅)鍚堢殑鐢�(ch菐n)鐗┿€傚畠浠ュ井铏曠悊姗熺偤鏍稿績锛屾妸寰绠楁銆佸伐妤�(y猫)鎺у埗姗�銆佹暩(sh霉)鎿�(j霉)閫氳▕绯荤当(t菕ng)銆侀’绀烘搷浣滆缃�銆侀亷绋嬮€氶亾銆佹ā鎿剙琛ㄧ瓑鏈夋鐨勭祼(ji茅)鍚堣捣渚�锛岄噰鐢ㄧ祫鍚堣寮忕祫鎴愮郴绲�(t菕ng)锛岀偤瀵︾従(xi脿n)宸ョ▼澶х郴绲�(t菕ng)鐨勭稖鍚堣嚜鍕曞寲鍓�(chu脿ng)閫犱簡姊濅欢锛屾墍浠�锛屼互PLC鐐哄熀绀�(ch菙)鐨勯泦鏁ｆ帶鍒剁郴绲�(t菕ng)宸叉垚鐐哄伐妤�(y猫)鑷嫊鍖栫郴绲�(t菕ng)鐨勪富娴�銆傚湪娴锋磱骞宠嚭鐭虫补鐢熺敘(ch菐n)涓�锛岀敱浜庢捣涓婁綔妤�(y猫)姊濅欢鑹辫嫤銆佸伐浣滅挵(hu谩n)澧冩儭鍔�锛屼笖闅ㄨ憲娴蜂笂鐭虫补闁嬮噰瑕�(gu墨)妯＄殑涓嶆柗鎿村ぇ鍖�锛屾捣涓婂钩鑷虹煶娌圭敓鐢�(ch菐n)鐨勭敓鐢�(ch菐n)鑸囩鐞嗚秺渚嗚秺杩垏鐨勮姹傝兘杩呴€�銆佹簴(zh菙n)纰�銆佸叏闈㈢殑鎺屾彙鐢熺敘(ch菐n)瑷�(sh猫)鍌欑殑宸ヤ綔閬嬭鐙€娉�锛屽洜姝ら泦鏁ｆ帶鍒跺湪娴蜂笂鐭虫补闁嬮噰涓緱鍒颁簡鏃ヨ定寤ｆ硾鐨勬噳(y墨ng)鐢ㄣ€�

浜�銆佸钩鑷烘按铏曠悊DCS绯荤当(t菕ng)鏋舵(g貌u)

2.1骞宠嚭姘磋檿鐞嗗伐钘�

娴锋按缍�(j墨ng)鎻愬崌娉垫彁鍗囪嚦绮楁烤鍣�锛屾烤鍘�98%浠ヤ笂绮掑緫澶т簬100μm鎳告诞鍥洪珨锛屽啀鎸夋瘮渚嬪姞鍏ユ贩鍑濆姂鍜岀诞鍑濆姂锛岄€�(j矛n)鍏ュ鍔涙枩绠℃矇闄嶇綈娓︽祦涓拰鍙嶆噳(y墨ng)鍗€(q奴)锛岄潬娓︽祦浣滅敤鍏呭垎娣峰悎鍙嶆噳(y墨ng)锛屼娇寰皬椤嗙矑绲嚌鑱氱祼(ji茅)鎴愮偤杓冨ぇ椤嗙矑锛岃€岄潪婧舵€у寲鍚堢墿缍�(j墨ng)閬庡寲瀛�(xu茅)鍙嶆噳(y墨ng)鐢熸垚娌夋穩锛屽啀閫�(j矛n)鍏ユ枩绠℃矇闄嶅崁(q奴)閫�(j矛n)琛岄噸鍔涘垎闆�锛岄仈(d谩)鍒版按璩�(zh矛)鍑堝寲鐨勭洰鐨勩€傜稉(j墨ng)娌夐檷鍚庣殑娴锋按閫�(j矛n)鍏ョ窗(x矛)婵惧櫒锛屾捣姘翠腑鐨勬嚫娴墿琚窗(x矛)婵惧櫒鐨勯洐浠嬭唱(zh矛)婵惧堡鏀旀埅锛屾烤鍚庢捣姘存帓鑷宠秴閲嶅姏鑴哀瑁濈疆瀵︾従(xi脿n)閮ㄥ垎鑴哀锛屽緸鑰岄檷浣庢捣姘翠腑姘х殑鍚噺銆傝劔姘ц檿鐞嗗悗鐨勬捣姘寸稉(j墨ng)U 鍨嬬閫�(j矛n)鍏ヤ竴绱氭埃姘村垎闆㈠櫒锛屽垎闆㈠嚭娴锋按涓敎甯剁殑娓搁洟澶╃劧姘ｅ苟鎺掓斁鍒版斁绌虹伀鐐�锛屽啀閫�(j矛n)鍏ヤ簩绱氭埃姘村垎闆㈠櫒鍒嗛洟鍑烘憾瑙ｅ湪娴锋按涓殑澶╃劧姘�锛屼互淇濊(h霉)娉ㄦ按缃愬厤鍙楀ぉ鐒舵埃鐨勬矕鎿�銆傜稉(j墨ng)姘ｆ按鍒嗛洟鍚庣殑娴锋按閫�(j矛n)娉ㄨ嚦娉ㄦ按缃愶紝鍐嶇稉(j墨ng)娉ㄦ按娉靛姞澹撳悗閫氶亷娴峰簳娉ㄦ按绠＄窔鍒嗗垾杓搁€佸埌鍚勪簳绲勫钩鑷�锛屾渶绲傚鐝�(xi脿n)灏嶆敞姘翠簳鐨勬敞姘�銆傚钩鑷烘按铏曠悊鐨勫伐钘濇祦绋嬪鍦�1鎵€绀�銆�

鍦�1 娴蜂笂骞宠嚭娴锋按铏曠悊宸ヨ棟娴佺▼鍦�

2.2骞宠嚭姘磋檿鐞咲CS绯荤当(t菕ng)鏋舵(g貌u)

閲濆皪姘磋檿鐞嗗伐钘濈殑寰�(f霉)闆滄€�锛岄噰鐢ㄥ熀浜庝笁绱氬京(f霉)鍚堝瀷鎷�?f霉)娴(ji茅)妲�(g貌u)锛堢附绶�/绺界窔閭忚集鐠�(hu谩n)/绺界窔锛夌殑DCS绯荤当(t菕ng)鏋舵(g貌u)锛屽叾楂樺堡鐐轰俊鎭鐞嗗堡锛屽鐝�(xi脿n)骞宠嚭姘磋檿鐞嗙洠(ji膩n)鎺ф暩(sh霉)鎿�(j霉)鐨勭鐞嗗姛鑳�;鍏舵渶浣庝竴灞ょ偤閬�(yu菐n)绋婭/O閺堣矾锛屽鐝�(xi脿n)鐝�(xi脿n)鍫存帶鍒跺姛鑳�;涓枔涓€灞ょ偤DH+缍�(w菐ng)锛屽鐝�(xi脿n)姘磋檿鐞嗗悇宸ヨ棟閬庣▼鐨勫鏅傜洠(ji膩n)鎺у姛鑳�銆傚叾缍�(w菐ng)绲�(lu貌)鎷�?f霉)娴艰粶?g貌u)濡傚湒2鎵€绀恒€�

鍦�2 DCS绯荤当(t菕ng)鎷�?f霉)娴(ji茅)妲�(g貌u)鍦�

鐩�(ji膩n)鎺ц▓绠楁閫氶亷DH+缍�(w菐ng)鑸囧叿鏈夊井铏曠悊鍣ㄧ殑PLC銆佹暩(sh霉)鎿�(j霉)閲囬泦鍣ㄧ瓑閮ㄤ欢閫�(j矛n)琛屽鏅傞€氫俊锛屽皪宸ユ帶鐝�(xi脿n)鍫村垎鏁ｇ殑鏁�(sh霉)鎿�(j霉)閫�(j矛n)琛屽瓨鍙栧拰鏀硅畩鎿嶄綔銆傜洠(ji膩n)鎺ц▓绠楁鏃㈣兘鍙婃檪鎺屾彙鏁村€嬫按铏曠悊閬庣▼鐨勫叏閮ㄧ媭鎱�(t脿i)锛屽張鍙互鐩存帴绲﹀嚭鍚勬帶鍒跺洖璺殑瑷�(sh猫)瀹氬€�锛屽苟閫氶亷PLC鐩存帴鍚戞帶鍒跺洖璺櫦(f膩)閫佹帶鍒朵俊铏�锛屽苟鍒╃敤CRT椤ず鎶€琛�(sh霉)鍕曟厠(t脿i)椤ず鏁村€嬫按铏曠悊閬庣▼鐨勫悇绋暙闈�锛岀洠(ji膩n)瑕栨暣鍊嬪钩鑷烘捣姘磋檿鐞嗛亷绋嬨€傜鐞嗚▓绠楁閲囩敤MS SQL Server2000闂�(gu膩n)绯诲瀷鏁�(sh霉)鎿�(j霉)搴締绠＄悊姘磋檿鐞嗗伐钘濈殑鏁�(sh霉)鎿�(j霉)淇℃伅銆傚畠閫氶亷Ethernet淇℃伅绠＄悊缍�(w菐ng)寰炵洠(ji膩n)鎺ц▓绠楁鐛插彇姘磋檿鐞嗛亷绋嬬殑鎵€鏈夊湪绶氫俊鎭紝鍥犳锛岄櫎浜嗙洿鎺ュ湪绶氭帶鍒跺锛岄倓鍏锋湁鑸囩洠(ji膩n)鎺ц▓绠楁鐩稿悓鐨勭洠(ji膩n)鎺у姛鑳�銆�

绯荤当(t菕ng)涓嬩綅閲囩敤浜咥-B鍏徃鐨凷LC500鍙法绋嬫帶鍒跺櫒绲勬垚鐨勫叐濂桺LC鎿村睍姗熸灦PLC1鍜孭LC2锛屾瘡濂楁摯灞曟鏋跺潎鍏锋湁9濉奡LC500銆傚叾涓璓LC2鐢ㄤ簬绱�(x矛)婵惧櫒鍙嶆矕娲楀伐钘濈殑閬庣▼鎺у埗锛屽叾琚帶鍒堕噺绺芥暩(sh霉)147鍊�锛孭LC1鍓囦富瑕佺敤浜庡皪娉ㄦ按宸ヨ棟娴佺▼涓捣姘存彁鍗�銆佽秴閲嶅姏鑴哀銆佸姞钘�銆乁鍨嬬姘ｆ按鍒嗛洟浠ュ強娉ㄦ按娉垫绲勭瓑瀛愬伐钘濇祦绋嬬殑閬庣▼鐩�(ji膩n)鎺�锛岃妾㈡脯鍙冩暩(sh霉)鐐烘韩搴�銆佸鍔�銆佹恫浣嶃€佹祦閲�銆佹捣姘存縼搴�銆佹捣姘村惈姘ч噺浠ュ強瑾�(di脿o)绡€(ji茅)闁ョ殑闁嬪害锛屽叡143鍊嬨€�

涓�銆佸钩鑷烘按铏曠悊DCS绯荤当(t菕ng)鍔熻兘瀵︾従(xi脿n)

3.1绯荤当(t菕ng)涓嬩綅鎺у埗鍔熻兘瀵︾従(xi脿n)

绯荤当(t菕ng)涓嬩綅PLC灏嶆按铏曠悊鐝�(xi脿n)鍫寸殑鎺у埗瀵︾従(xi脿n)锛岄噰鐢ㄤ簡RSLinx500姊舰鍦栭倧杓法绋嬭粺浠�锛岃ō(sh猫)瑷堝鐝�(xi脿n)灏嶅悇瑷�(sh猫)鍌欎互鍙婇亷绋嬭缃紙濡傞檺浣嶉枊闂�(gu膩n)銆佹寜閳�銆侀伕鎿囬枊闂�(gu膩n)銆佸鍔涢枊闂�(gu膩n)绛夛級鐨勭媭鎱�(t脿i)瀵︽檪鐩�(ji膩n)瑕�锛屾牴鎿�(j霉)鐩�(ji膩n)瑕栧埌鐨勭媭鎱�(t脿i)閫�(j矛n)琛岄倧杓垽鏂凤紝骞舵簴(zh菙n)纰哄湴鎺у埗鍦ㄨō(sh猫)鍌欎笂鎴栨祦绋嬩腑鐨勮几鍑鸿缃紙濡傞浕纾佺窔鍦�銆侀枼銆佷俊铏熷櫒绛夛級锛屽悓鏅傞倓瀵︾従(xi脿n)浜嗗畾鏅傚拰瑷堢畻鍔熻兘銆傛澶�锛屽湪绻奸浕鍣ㄦ寚浠�銆佺畻琛�(sh霉)閬嬬畻鍜岄倧杓亱绠楁寚浠ょ殑鍩虹(ch菙)涓�锛屾摯鍏呬簡鍌抽€佸拰杞�(zhu菐n)鎻涙寚浠�銆侀€氳▕鎸囦护浠ュ強妯℃摤閲忚几鍏ユ寚浠ゅ拰PID瑾�(di脿o)绡€(ji茅)鎸囦护绛�锛屽鐝�(xi脿n)閭忚集鎺у埗鍜岄爢搴忔帶鍒讹紝骞惰矤(f霉)璨�(z茅)瀹屾垚灏嶅伐钘濋亷绋嬩腑閫ｇ簩(x霉)閲忕殑閲囬泦锛屽鐝�(xi脿n)寰�(f霉)闆滄帶鍒剁畻娉曢亱绠�锛屽苟杓稿嚭绲﹀煼(zh铆)琛屾妲�(g貌u)锛屽鐝�(xi脿n)绮剧窗(x矛)瑾�(di脿o)绡€(ji茅)銆傚叾瀵︾従(xi脿n)鐨勬帶鍒跺姛鑳藉叿楂斿涓嬶細

1锛夋捣姘存彁鍗囷細浠ュ鍔涙枩绠℃矇闄嶇綈鐨勫嚭鍙ｆ縼搴︾偤鍩烘簴(zh菙n)锛屾帶鍒跺鍔涙枩绠℃矇闄嶇綈鐨勬帓娉ユ鏁�(sh霉)浠ュ強绶╄潟鍔�銆佹贩鍑濆姂鍜岀诞鍑濆姂鐨勮棩鍔戞姇鍔犻噺;浠ユ敞姘寸綈娑蹭綅鐨勮ō(sh猫)瀹氬€肩偤妯�(bi膩o)婧�(zh菙n)锛屽皪娴锋按鎻愬崌娉靛鐝�(xi脿n)璁婇牷瑾�(di脿o)閫熸帶鍒�锛屽鐝�(xi脿n)灏嶆捣姘存彁鍗囨车渚涙按閲忕殑鎺у埗锛氱暥(d膩ng)娉ㄦ按缃愭恫浣嶄綆浜庤ō(sh猫)瀹氬€兼檪锛屾帶鍒跺櫒鍚戣畩闋诲櫒杓稿嚭鎻愰珮杞�(zhu菐n)閫熺殑淇¤櫉锛�璁婇牷鍣�鎻愰珮闆绘杞�(zhu菐n)閫�锛屽鍔犳捣姘存彁鍗囨车鐨勬帓閲�;鍙嶄箣锛屽墖闄嶄綆娴锋按鎻愬崌娉电殑鎺掗噺銆傚叾琚洠(ji膩n)娓弮鏁�(sh霉)鏈夋捣姘存彁鍗囨车鐨勫嚭鍙ｅ鍔涖€佸嚭鍙ｆ祦閲�銆佸嚭鍙ｆ縼搴�;绮楁烤鍣ㄧ殑婵惧悗澹撳姏銆佹烤鍚庢祦閲�銆佹烤鍚庢縼搴�;1#鍜�2#澹撳姏鏂滅娌夐檷缃愮殑鍑哄彛婵佸害銆�

2锛夐亷婵惧弽娌栨礂锛氫互绱�(x矛)婵惧櫒鍑哄彛婵佸害鐐轰緷鎿�(j霉)锛屾帶鍒剁窗(x矛)婵惧櫒鐨勫弽娌栨礂娆℃暩(sh霉)浠ュ強鍙嶆礂閬庣▼涓弽娲楅枔闅�銆佸姞姘淬€侀亷婵�銆佹帓姘�銆佹埃娌栨礂銆佹帓姘ｃ€佹按娌栨礂銆侀潨缃互鍙婃帓绌哄伐钘濋亷绋嬬殑鏅傞枔闁撻殧锛屽苟鎺у埗娈鸿弻鍔戠殑钘ュ姂閲�銆傚叾琚洠(ji膩n)娓弮鏁�(sh霉)鏈夛細鍙嶆矕娲楃綈娑蹭綅銆佺窗(x矛)婵惧櫒閫�(j矛n)鍙ｅ尟绠″鍔�銆佺窗(x矛)婵惧櫒鍑哄彛鎺掓恫澹撳姏銆佸剙琛ㄩⅷ(f膿ng)澹�銆佸弽娲楁按澹�銆佺窗(x矛)婵惧櫒婵惧悗婵佸害銆�

3锛夊姞钘ワ細浠ュ悇鍔犺棩缃愮殑娑蹭綅楂樹綆闄愪綅鐐哄熀婧�(zh菙n)锛屾帶鍒跺悇鍔犺棩鎾鐨勫姞钘ュ暉鍋滅媭鎱�(t脿i)銆傝嫢鏌愬姞钘ョ綈鐨勬恫浣嶄綆浜庝綆闄愯ō(sh猫)瀹氬€�锛岀郴绲�(t菕ng)鑷嫊鍟熷嫊鍔犺棩鎾灏嶈┎鍔犺棩缃愭姇鍔犺棩鍔戞憾娑�;鐣�(d膩ng)瑭插姞钘ョ綈鐨勬恫浣嶅埌閬�(d谩)娑蹭綅鏈€楂橀檺鏅�锛岀郴绲�(t菕ng)鑷嫊鍋滄鍔犺棩鎾鐨勫姞钘ュ嫊浣�銆傚叾琚洠(ji膩n)娓弮鏁�(sh霉)鏄細绶╄潟1#銆佹贩鍑�2#銆佺诞鍑�3#銆佹鑿�4#銆佸倷鐢�5#浠ュ強鍌欑敤6#鍔犺棩缃愮殑娑蹭綅鍜屽悇鍔犺棩娉电殑钘ュ姂鎺掗噺銆�

4锛夎秴閲嶅姏鑴哀锛氫互浜岀礆姘ｆ按鍒嗛洟鍣ㄥ嚭鍙ｆ捣姘村惈姘ч噺鐐哄熀婧�(zh菙n)锛屾帶鍒惰秴閲嶅姏鑴哀姗熺殑閫�(j矛n)姘ｉ噺鍜岄€�(j矛n)姘撮噺鐨勬瘮鍊硷紙鍗虫埃娑叉瘮锛�銆傝嫢娴锋按鍚哀閲忛亷楂橈紝绯荤当(t菕ng)鑷嫊澧炲姞瓒呴噸鑴哀姗熺殑姘ｆ恫姣�銆傚叾琚洠(ji膩n)娓弮鏁�(sh霉)鏄秴閲嶅姏鑴哀姗熺殑閫�(j矛n)姘ｅ鍔�銆侀€�(j矛n)姘ｆ祦閲�銆佸嚭姘ｅ鍔�銆侀€�(j矛n)姘村鍔�銆侀€�(j矛n)姘存祦閲�銆�

5锛塙鍨嬬姘ｆ按鍒嗛洟锛氬皪姘ｆ按鍒嗛洟閬庣▼鐨勪腑鐨刄鍨嬬娑蹭綅銆佷竴绱氭埃姘村垎闆㈠櫒娑蹭綅銆佷竴绱氭埃姘村垎闆㈠櫒鎺掓埃娴侀噺銆佷竴绱氭埃姘村垎闆㈠櫒鎺掓埃澹撳姏銆佷簩绱氭埃姘村垎闆㈠櫒鍑哄彛鍚哀閲忎互鍙婃敞姘寸綈娑蹭綅閫�(j矛n)琛屽鏅傜洠(ji膩n)銆佹娓�銆�

6锛夋敞姘存车姗熺祫锛氬皪娉ㄦ按娉垫绲勯噰鐢ㄨ畩闋昏(di脿o)閫熸帶鍒躲€傜敤浜ゆ祦璁婇牷瑾�(di脿o)閫熷櫒浣滅偤鍟熷嫊鍜岃(di脿o)閫熻缃�锛屼互PLC鐐烘帶鍒舵牳蹇�锛屼互婊胯冻娉ㄦ按浜曠殑娉ㄦ按澹撳姏鍜屾敞姘撮噺鐐哄墠鎻愶紝灏嶆敞姘存车姗熺祫鐨勮綁(zhu菐n)閫熷拰閬嬭綁(zhu菐n)鑷烘暩(sh霉)浣滆嚜鍕曡(di脿o)鏁�锛屽鐝�(xi脿n)娉ㄦ按娉垫绲勭殑鑷嫊閬嬭銆傚叾琚洠(ji膩n)娓弮鏁�(sh霉)锛氭敞姘存车閫�(j矛n)鍙ｆ祦閲�銆侀€�(j矛n)鍙ｅ鍔�銆佸嚭鍙ｅ鍔�;娉ㄦ按娉靛墠杌哥摝婧害銆佹敞姘存车鍚庤桓鐡︽韩搴�;闆绘鍓嶈桓鐡︽韩搴�銆侀浕姗熷悗杌哥摝婧害銆侀浕姗熷畾瀛�1#閴戠啽闆婚樆銆侀浕姗熷畾瀛�2#閴戠啽闆婚樆銆侀浕姗熷畾瀛�3#閴戠啽闆婚樆銆�

3.2绯荤当(t菕ng)涓婁綅鐩�(ji膩n)鎺х郴绲�(t菕ng)鍔熻兘瀵︾従(xi脿n)

鍦�3 鐭虫补骞宠嚭姘磋檿鐞嗙洠(ji膩n)鎺х郴绲�(t菕ng)绺界晫闈�

涓婁綅鐩�(ji膩n)鎺х郴绲�(t菕ng)閲囩敤RSView32绲勬厠(t脿i)杌熶欢鎸夌収姘磋檿鐞嗗伐钘濇祦绋嬮枊鐧�(f膩)鑰屾垚锛屽叡鍒嗙偤鍏€嬬洠(ji膩n)鎺у瓙绯荤当(t菕ng)锛岀郴绲�(t菕ng)涓荤晫闈㈠鍦�3鎵€绀�銆傛捣姘存彁鍗囧瓙绯荤当(t菕ng)璨�(f霉)璨�(z茅)鐩�(ji膩n)鎺�3鑷烘捣姘存彁鍗囨车銆�3鍊嬫捣姘寸矖婵惧櫒鍜�2鍊嬪鍔涙枩绠℃矇闄嶇綈鐨勭浉闂�(gu膩n)鍙冩暩(sh霉)鍜岀従(xi脿n)鍫撮亱浣滄儏娉�;閬庢烤鍙嶆矕娲楀瓙绯荤当(t菕ng)鍖呮嫭5鍊嬬窗(x矛)婵惧櫒銆佷竴鑷洪紦棰�(f膿ng)姗�銆佷竴鍊嬪弽娌栨礂姘寸綈鍜屼竴鑷哄弽娌栨礂姘存车锛岃矤(f霉)璨�(z茅)鏁村€嬪弽娌栨礂閬庣▼鐨勮嚜鍕曟帶鍒朵互鍙婄媭鎱�(t脿i)鍙冩暩(sh霉)鐨勭洠(ji膩n)娓�;瓒呴噸鍔涜劔姘у瓙绯荤当(t菕ng)灏�2鑷鸿秴閲嶅姏鑴哀姗熺殑浣跨敤鑸囧倷鐢ㄧ媭鎱�(t脿i)閫�(j矛n)琛屽嫊鎱�(t脿i)妯℃摤椤ず锛屽苟鍚屾檪鐩�(ji膩n)娓浉闂�(gu膩n)鍙冩暩(sh霉);鍔犺棩瀛愮郴绲�(t菕ng)鐩�(ji膩n)鎺у悇鍔犺棩缃愮殑娑蹭綅鑸囨祦閲�锛屽苟璨�(f霉)璨�(z茅)灏嶆瘡澶╀娇鐢ㄧ殑钘ュ姂閲忛€�(j矛n)琛岀疮鍔犲尟绺�;U鍨嬬姘ｆ按鍒嗛洟鐩�(ji膩n)鎺у瓙绯荤当(t菕ng)璨�(f霉)璨�(z茅)鐩�(ji膩n)鎺鍨嬬娑蹭綅浠ュ強姘ｆ按鍒嗛洟鍣ㄧ殑姘ｆ按鍒嗛洟鎯呮硜;娉ㄦ按娉垫绲勫瓙绯荤当(t菕ng)鐩�(ji膩n)鎺у悇娉ㄦ按娉电殑浣跨敤鑸囧倷鐢ㄧ媭鎱�(t脿i)锛屽苟璨�(f霉)璨�(z茅)灏嶆敞姘存车鍚勯噸瑕佸弮鏁�(sh霉)鐨勫鏅傜洠(ji膩n)娓�銆傚叾鍔熻兘瀵︾従(xi脿n)鍏烽珨濡備笅锛�

1锛夊皪姘磋檿鐞嗗伐钘濈殑瀵︽檪鐩�(ji膩n)鎺ц垏鍕曟厠(t脿i)妯℃摤;閫氶亷瀵︽檪閲囬泦鍜岃閷勭殑绯荤当(t菕ng)鏁�(sh霉)鎿�(j霉)淇℃伅锛屽皪姘磋檿鐞嗗伐钘濅腑鎵€鏈夋帶鍒跺洖璺拰妾㈡脯榛炵殑鍚勫弮鏁�(sh霉)銆佺媭鎱�(t脿i)銆佽定鍕㈢瓑浣跨敤鍕曟厠(t脿i)鏂瑰紡椤ず鍜屾ā鎿�锛屽鐝�(xi脿n)灏嶆暣鍊嬪伐鎺х従(xi脿n)鍫寸殑瀵︽檪鍕曟厠(t脿i)妯℃摤鑸囧叏灞€鐩�(ji膩n)鎺�銆�

2锛夎鐩�(ji膩n)娓暩(sh霉)鎿�(j霉)鐨勫鏅傞噰闆嗚垏瀛樺劜锛氱洠(ji膩n)鎺ц▓绠楁鑸嘝LC涔嬮枔鐨勬暩(sh霉)鎿�(j霉)閫氫俊閲囩敤DH+宸ユキ(y猫)灞€鍩熺恫(w菐ng)瀵︾従(xi脿n);琚娓暩(sh霉)鎿�(j霉)鐨勫鏅傞噰闆�锛岄噰鐢≧SVIEW32鐨勫収(n猫i)閮ㄨō(sh猫)缃鐝�(xi脿n)锛屼笖鍦≧SView32鐨勫収(n猫i)閮ㄥ皣鍓嶈嚭鏁�(sh霉)鎿�(j霉)鎺冩弿瑷�(sh猫)缃偤1s锛屽悗鑷烘暩(sh霉)鎿�(j霉)鎺冩弿瑷�(sh猫)缃偤5s锛屽苟鍒╃敤 ADO鎶€琛�(sh霉)鍜孲QL SERVER2000鏁�(sh霉)鎿�(j霉)搴鐞嗘妧琛�(sh霉)灏峈SView32绲勬厠(t脿i)杌熶欢鐨勫姛鑳芥摯灞曚締瀵︾従(xi脿n)灏嶆墍閲囬泦鏁�(sh霉)鎿�(j霉)鐨勫瓨鍎�銆傚嵆锛氶鍏堝湪鐩�(ji膩n)鎺х郴绲�(t菕ng)鍏�(n猫i)閮ㄨō(sh猫)缃畾鏅傚櫒1锛屽叾鏅傞悩鍛ㄦ湡鐐�1绉�锛屾瘡绉掑悜鐩�(ji膩n)娓€煎瓨鍎叉暩(sh霉)鎿�(j霉)搴玀onitValueDB瀛樺劜涓€娆℃墍閲囬泦鍒扮殑琚娓弮鏁�(sh霉)鐨勭灛鏅傚€�銆侻onitValueDB鏁�(sh霉)鎿�(j霉)搴彧瀛樺劜30澶╃殑鐩�(ji膩n)娓€�锛屼富瑕佺敤浜庡皪姘磋檿鐞嗛亷绋嬬殑姝峰彶瓒ㄥ嫝鎻忕躬鑻ヨ秴閬�30澶╋紝鍓囪嚜鍕曟妸鏈€鍓嶄竴澶╃殑鏁�(sh霉)鎿�(j霉)鍒櫎鑰屽皣鐣�(d膩ng)鍓嶉噰闆嗘暩(sh霉)鎿�(j霉)鍐嶅瓨鍏�銆傚彟锛屽湪鐩�(ji膩n)鎺х郴绲�(t菕ng)鍏�(n猫i)閮ㄥ壍(chu脿ng)寤篍VENT浜嬩欢锛屽苟瑷�(sh猫)缃畾鏅傚櫒2锛屽皣鍏禘NVENT鍟熷嫊鏅傞枔瀹氬埗鐐�00:00锛�00:20锛�00:40锛�01:00锛�01:20锛�01:40锛�…锛� 23:00锛�23:20锛�23:40锛�銆傝嫢瀹氭檪鍣ㄦ檪闁撳埌锛岃┎EVENT浜嬩欢绔嬪嵆鍟熷嫊锛屽緸MonitValueDB涓嵅鍙栧皣瑭睧VENT浜嬩欢鐧�(f膩)鐢熷墠20鍒嗛悩鍏�(n猫i)绯荤当(t菕ng)鎵€閲囬泦宸ユ帶鍙冩暩(sh霉)鐨勭灛鏅傚€煎苟姹傚钩鍧囷紝浣滅偤瑭茶妾㈡脯鍙冩暩(sh霉)鐨勬湁鏁堝€�锛屽啀灏囧叾鍏ㄩ儴瀛樺叆骞冲潎鍊兼暩(sh霉)鎿�(j霉)搴獳veValueDB锛岀敤浜庡牨琛ㄦ墦鍗颁互鍙婃鍙茶硣鏂欐煡瑭�锛屼互浣滅偤鐢熺敘(ch菐n)姹虹瓥鐨勪緷鎿�(j霉)銆傚叾琚洠(ji膩n)娓弮鏁�(sh霉)鐨勫鏅傞噰闆嗚垏瀛樺劜鍔熻兘瀵︾従(xi脿n)濡傚湒4鎵€绀�銆�

鍦�4 琚洠(ji膩n)娓弮鏁�(sh霉)瀵︽檪閲囬泦鑸囧瓨鍎茬ず鎰忓湒

3锛夋鍙茶定鍕㈡弿绻細鏍规摎(j霉)鐩�(ji膩n)娓€煎瓨鍎叉暩(sh霉)鎿�(j霉)搴玀onitValueDB涓殑瀛樺劜鏁�(sh霉)鎿�(j霉)锛屽皪鍚勮妾㈡脯鍙冩暩(sh霉)鐨勬鍙叉暩(sh霉)鎿�(j霉)閫�(j矛n)琛屽嫊鎱�(t脿i)灞曠ず锛屼互姝峰彶鏇茬窔鐨勫舰寮忓嫊鎱�(t脿i)鎻忕躬姘磋檿鐞嗗伐钘濈殑姝峰彶閬嬩綔閬庣▼銆�

4锛夎ō(sh猫)鍌欑殑鍟熷仠鎿嶄綔鑸囪垏鍌欑敤鐙€鎱�(t脿i)鍒ゅ垾锛氭牴鎿�(j霉)姘磋檿鐞嗙郴绲�(t菕ng)鐨勫闅涢亱浣滄儏娉�锛屽皪3鑷烘捣姘存彁鍗囨车銆�2鑷鸿秴閲嶅姏鑴哀姗熷拰7鑷烘敞姘存车鐨勫暉鐢ㄨ垏鍌欑敤鐙€鎱�(t脿i)閫�(j矛n)琛屾纰哄垽鍒ワ紝骞舵垚鍔熷鐝�(xi脿n)鍌欑敤鐙€鎱�(t脿i)涓嬬殑瑷�(sh猫)鍌欎笉鐧�(f膩)鐢熷牨璀�銆�

5锛夊牨璀︿俊鎭’绀鸿垏铏曠悊锛氬湪鐩�(ji膩n)鎺х郴绲�(t菕ng)鐨勪富鐣岄潰鍜屽悇瀛愮郴绲�(t菕ng)鐨勫瓙鐣潰涓婂潎瑷�(sh猫)鏈夊牨璀︿俊鎭锛岀敤浜庨’绀烘渶杩戠櫦(f膩)鐢熺殑鍫辫淇℃伅锛屽寘鎷櫦(f膩)鍑哄牨璀︿俊鎭殑妯�(bi膩o)璀橈紙Tag锛夋墍浠ｈ〃鐨勫剙鍣ㄥ剙琛ㄥ伐浣嶈櫉銆佺櫦(f膩)鐢熷牨璀︾殑鏃ユ湡鑸囨檪闁�銆佸牨璀︽檪鐨勭灛鏅傚€间互鍙婇珮浣庨檺浣嶅牨璀︾媭鎱�(t脿i);鍒╃敤鍫辫鍖附琛�锛屾搷浣滀汉鍝″彲闅ㄦ檪鏌ョ湅銆佸倷浠藉苟鎵撳嵃杓稿嚭銆傜暥(d膩ng)鏈夊牨璀︾櫦(f膩)鐢熸檪锛岀洠(ji膩n)鎺х郴绲�(t菕ng)鏈冩牴鎿�(j霉)鍫辫鐨勫毚(y谩n)閲嶇▼搴︾櫦(f膩)鍑轰笉鍚岀殑鎻愮ず鑱查煶锛岀敤浠ユ彁閱掑伐浣滀汉鍝￠€�(j矛n)琛屽畾浣嶆煡鐪嬭垏妾慨锛屽鐝�(xi脿n)瀹氫綅鏁呴殰鎺掗櫎銆�

灏嶇郴绲�(t菕ng)椤ず鐨勫牨璀︿俊鎭互鍙婄偤姘磋檿鐞嗗伐钘濈殑鏀归€�(j矛n)鑰岃€冩叜鐨勫牨璀﹂檺鍊肩殑绠＄悊锛屼篃鍊熷姪浜嶳SView32鐨勫祵鍏ュ紡瑾炶█VBA锛屼互鍙夾DO閬�(yu菐n)绋嬫暩(sh霉)鎿�(j霉)瑷晱鍜屾暩(sh霉)鎿�(j霉)搴鐞嗘妧琛�(sh霉)渚嗘摯灞曞鐝�(xi脿n)锛屽叾绋嬪簭椤炰技琚娓暩(sh霉)鎿�(j霉)鐨勫鏅傞噰闆嗚垏鍛ㄦ湡鎬у瓨鍎层€傚牨璀︿俊鎭互鍙婂牨璀﹂檺鍊煎瓨鍏ョ敤鏁�(sh霉)鎿�(j霉)搴偤AlertingDB銆�

6锛夋暩(sh霉)鎿�(j霉)绠＄悊鑸囩董璀�(h霉)锛氫互ADO鎶€琛�(sh霉)銆佹暩(sh霉)鎿�(j霉)搴鐞嗘妧琛�(sh霉)鍜岀恫(w菐ng)绲�(lu貌)鎶€琛�(sh霉)鐐烘妧琛�(sh霉)鏀寔锛岄噰鐢╒B 6.0杌熶欢绶ㄥ埗浜嗗伐鎺т俊鎭鐞嗙郴绲�(t菕ng)锛屽鐝�(xi脿n)浜嗗皪宸ユ帶鏁�(sh霉)鎿�(j霉)鐨勬坊鍔犮€佸埅闄�銆佷慨鏀�銆佹煡瑭㈢瓑鏁�(sh霉)鎿�(j霉)绠＄悊鑸囩董璀�(h霉)鎿嶄綔锛屽鐝�(xi脿n)浜嗘湁姊濅欢鎿嶄綔涓嬬殑鏃ュ牨琛�銆佹湀鍫辫〃浠ュ強骞村牨琛ㄧ殑鑷嫊鐢熸垚鑸囨墦鍗般€�

鍥�銆佺祼(ji茅)璜�

灏嶆捣娲嬪钩鑷烘按铏曠悊宸ヨ棟瀵﹁DCS鑷嫊鍖栭泦鏁ｆ帶鍒�锛屾垚鍔熷鐝�(xi脿n)浜嗚鐩�(ji膩n)娓弮鏁�(sh霉)鐨勬暩(sh霉)鎿�(j霉)閲囬泦銆侀仩(yu菐n)绋嬪偝杓镐互鍙婇亷绋嬫帶鍒�锛岀湡姝ｅ鐝�(xi脿n)浜嗙劇浜哄€肩彮浣滄キ(y猫)锛屽湪寰堝ぇ绋嬪害涓婇檷浣庝簡宸ヤ綔浜哄摗鐨勫嫗鍕曞挤搴�锛屾敼鍠勪簡宸ユ帶鐝�(xi脿n)鍫寸殑绠＄悊鐙€娉侊紝鏈夋晥閬垮厤浜嗚棩鍔戞氮璨昏垏瑷�(sh猫)鍌欐悕鑰�锛屾彁楂樹簡姘磋檿鐞嗘晥鐜�锛岄檷浣庝簡鐢熺敘(ch菐n)鎴愭湰銆傛牴鎿�(j霉)娌圭敯鐢熺敘(ch菐n)骞撮憭鐨勬暩(sh霉)鎿�(j霉)绲�(t菕ng)瑷堝皪姣旈’绀�锛岃┎DCS绯荤当(t菕ng)鐨勪娇鐢ㄥ彲绡€(ji茅)绱勫勾鐢熺敘(ch菐n)鎴愭湰190澶氳惉鍏�锛岄爡鐩稉(j墨ng)婵�(j矛)鏁堢泭閬�(d谩)470澶氳惉鍏冦€�

鍙冭€冩枃鐛�(xi脿n)

[1] 缇呰秴,钖涚鐝�. DCS瀵︽檪閫氳▕缍�(w菐ng)绲�(lu貌)鐨勮ō(sh猫)瑷堝拰瀵︾従(xi脿n).瑷堢畻姗熸噳(y墨ng)鐢�. 2001, 21-9: 49-50.

[2] 寮靛厗鏋�,闅嬫櫙鏄�. 鍩轰簬DCS鐨勯ⅷ(f膿ng)姗熸帶鍒剁郴绲�(t菕ng)瑷�(sh猫)瑷堝強鎳�(y墨ng)鐢�.鑷嫊鍖栧剙琛�,2001,22-7:49-51.

[3] 浣曟枌.DCS—闆嗘暎鎺у埗绯荤当(t菕ng)鐨勭櫦(f膩)灞曟娉佸拰瓒ㄥ嫝.娴欐睙閫犵礄, 2000, 1: 44-46.

[4] 閮濇垚,甯哥辜鐢�.鍩轰簬PC鐨凞CS鐮旂┒鑸囨噳(y墨ng)鐢�,寰▓绠楁淇℃伅.2005,21,5 : 55-56.

[5] 寰愭窇钀�,铇囧皬鏈�,鏉庡嘲,鑼冩渻鏁�.姘存偿寤燚CS鐩�(ji膩n)鎺х郴绲�(t菕ng)鐨勮ō(sh猫)瑷堣垏瀵︾従(xi脿n). 寰▓绠楁淇℃伅,2005,21-7: 78-80