Product > Chakra > Information

ºñ ÀÎÁõ DB Á¢±Ù ¹× ÀÛ¾÷ Á¤º¸¸¦ ½Ç½Ã°£À¸·Î °¨½ÃÇÏ°í ¼ö¸³µÈ º¸¾È Á¤Ã¥¿¡ µû¶ó °æº¸ ¹× Â÷´ÜÇÕ´Ï´Ù.
1. Alert Policy (Alerting, Denial of Service)
±â¾÷ÀÇ º¸¾ÈÀü·« ¹× ¾÷¹«¼öÇà ÀýÂ÷¿¡ µû¶ó DB¿¡ ¾Ç¿µÇâÀ» ÁÙ ¼ö ÀÖ´Â Á¢±Ù¿¡ ´ëÇØ °æº¸¹ß»ý, °­Á¦ Â÷´Ü µîÀÇ º¸¾ÈÁ¤Ã¥À» ¼³Á¤
Client Connection, DB/OS Account, Instance, Session, SQL, SQL Result, Action µî ´Ù¾çÇÑ Á¶°ÇÀÇ °æ°í¹ß»ý ¹× Â÷´Ü±â´É ¼³Á¤
2. Alert Monitor
º¸¾È ´ã´çÀÚ°¡ ¼³Á¤ÇÑ °æº¸Á¶°Ç¿¡ ÀÇÇØ ¹ß»ýµÈ À̺¥Æ® ¸ñ·Ï ¹× »ó¼¼ ³»¿ª È®ÀÎ
¼³Á¤µÈ º¸¾ÈÁ¤Ã¥¿¡ ÀÇÇØ °æº¸ ¹ß»ý½Ã ÀÚµ¿À¸·Î ¼¼¼Ç Â÷´Ü ¹× °ü¸®ÀÚ ¸ÞÀÏÀ̳ª SMS·Î ÀÚµ¿ Å뺸
DB¿¡ ºÎÇÏ ¾øÀÌ ´©°¡, ¾ðÁ¦, ¾îµð¼­, ¾î¶² Á¤º¸¸¦ Á¶È¸ÇÏ°í º¯°æÇÏ´ÂÁö¿¡ ´ëÇÑ ÀÛ¾÷ ÀÌ·ÂÀ» 100% ±â·ÏÇÕ´Ï´Ù.
1. µ¥ÀÌÅͺ£À̽º(SQL) ·Î±ë ¹× °¨½Ã Á¤Ã¥ °ü¸®
´Ù¾çÇÑ º¸¾ÈÁ¤Ã¥ ¼ö¸³À» À§ÇÑ Æí¸®ÇÑ Á¤Ã¥¼³Á¤
Client IP, DB/OS Account, App, SQL Type, °¢ ½Ã°£ Á¶°Ç°ú ÇÔ²² ¼¼ºÎ ÀÛ¾÷³»¿ª ±¸ºÐ Á¶°Ç ¼³Á¤ °¡´É
2. ¼­¹ö(Telnet/FTP/RCmd) ·Î±ë ¹× °¨½ÃÁ¤Ã¥ °ü¸®
°¨½Ã´ë»ó ¼­¹ö¿¡ ´ëÇÑ Telnet, FTP, RCmd Á¢±Ù ¹× ÀÛ¾÷³»¿ªÀÇ °¨½Ã¸¦ À§ÇÑ ·Î±ë ¹× °¨½ÃÁ¤Ã¥ ¼³Á¤
Server Name, IP, Port, Output Logging, ·Î±×ÀÚ·á ¹é¾÷/¾ÐÃà µîÀÇ È¯°æ ¼³Á¤
360µµ Àü¹æÀ§ °¨½Ã ¹× ·Î±ë(SSH, Telnet, ¾Ïȣȭ Åë½Å ÀÛ¾÷ ³»¿ª ±â·Ï)
1. Session Monitoring
°¨½Ã ´ë»ó µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áµÇ¾î ÀÖ´Â ¼¼¼Çµé¿¡ ´ëÇÑ ´Ù¾çÇÑ »óÅ Á¤º¸¸¦ ÀϰýÀûÀ¸·Î ¸ð´ÏÅ͸µ
°¢ ¼¼¼Ç¿¡ ´ëÇÑ Client IP, Connect Time, DB User, App, SQL Count µîÀÇ Á¤º¸ Á¦°ø
¼öÇàµÈ SQLÀÇ Type, Text, ÀÀ´ä½Ã°£, Return Row, Transaction Usage µîÀÇ Á¤º¸ Á¦°ø
2. SQL Monitoring
ÇöÀç ½ÇÇà ÁßÀÎ SQL¿¡ ´ëÇÑ ½Ç½Ã°£ ¸ñ·Ï ¹× »ó¼¼³»¿ª Á¦°ø(SQL ³»¿ë, ¼º´ÉÁ¤º¸, ¼¼¼ÇÁ¤º¸, Client Á¤º¸ µî)
³»ÀåµÈ Plan Tool ȤÀº Orange¿Í ¿¬°è ÇÏ¿© SQL¿¡ ´ëÇÑ »ó¼¼ÇÑ Tracing °¡´É
3. Report Builder
Report Builder¸¦ ÅëÇØ DBº°, Hostº° º¸¾È °üÁ¡ º°·Î ´Ù¾çÇÑ °Ë»ö Á¶°Ç¿¡ ÀÇÇÑ º¸°í¼­ »ý¼º
°Ë»ö Á¶°Ç¿¡ ÀÇÇØ »ý¼ºµÈ Report´Â HTML, PDF µî ´Ù¾çÇÑ Æ÷¸ËÀ¸·Î º¯È¯ Á¦°ø
·Î±× ÀڷḦ Log Mart DB¿¡ Load ÇÏ¿© ´ÙÂ÷¿ø ºÐ¼®À» ÇÒ ¼ö ÀÖ´Â Data Mart ±¸¼º Á¦°ø
4. Telnet/FTP/Rcmd Log Monitoring
°¨½Ã´ë»ó ¼­¹ö·Î Á¢¼ÓÇÑ ¸ðµç ÀÛ¾÷ÀÚÀÇ Telnet, FTP, RCmd ·Î±×¸¦ ´Ù¾çÇÑ °Ë»ö Á¶°ÇÀ¸·Î °¨½Ã ÇÔ
Client IP, »ç¿ë ¸í·É¾î, »ç¿ë½Ã°£, °á°úÁ¤º¸ µîÀÇ »ó¼¼Á¤º¸ Á¦°ø
1. Trend Analyzer (Ãß¼¼ºÐ¼® ¹× ¿¹Ãø)
°¨½Ã ´ë»ó DBMSÀÇ Server Time, Session Count, Tranasction Usage, Return Row µîÀÇ ÃßÀ̺м® ±×·¡ÇÁ Á¦°ø
ÆÐÅÏ¿¡ ´ëÇÑ ÀÓ°èÄ¡ ¼³Á¤À» ÅëÇØ °æ°í ¹ß»ý ¹× ÃßÀ̺м®À» ÅëÇÑ »çÀü ¿¹º¸ ¼­ºñ½º Á¦°ø
2. Log Analyzer (Alert, SQL, Server Log ºÐ¼®)
°¨½Ã ´ë»ó µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ·Î±× ºÐ¼®±â·Î ¹®Á¦¹ß»ý ½ÃÁ¡ÀÇ ÃßÀ̺м® ¹× ÃßÀû ±â´É Á¦°ø
´Ù¾çÇÑ Á¶°ÇÀÇ °Ë»ö ±â´ÉÀ» Á¦°øÇϸç, ÇØ´ç SQL¿¡ ´ëÇÑ Æ©´×À» À§ÇØ Plan Tool ¿¬°è(Rich Client½Ã) ±â´ÉÁö¿ø
1. »ç¿ëÀÚ Á¤º¸ °ü¸®
»ç¿ëÀÚ ±âº»Á¤º¸ (ID, Password, IP, À¯È¿±â°£ µî) ¹× Á¢¼Ó °¡´É DBMS Á¤º¸µé µî·Ï °ü¸® ClientÀÇ DAR°ú ¿¬µ¿ÇÏ¿© »ç¿ëÀÚ ÀÎÁõ(¾ÏÈ£, IP, À¯È¿±â°£) ÈÄ ±ÇÇÑ ÀÖ´Â DBMS¿¡ ´ëÇØ Á¢¼Ó Çã¿ë
2. DAR Á¤Ã¥ °ü¸®
Á¤Çü, ºñÁ¤Çü Á¢¼Ó ToolÀ» µî·Ï °ü¸®ÇÏ¿© Applicationº° Á¢¼Ó Çã¿ë, Â÷´Ü Á¤Ã¥ °ü¸®
°¨½Ã ´ë»ó DBMSº° Routing Á¤Ã¥ °ü¸® ¹× Chakra ¼­¹ö Àå¾Ö¿¡ µû¸¥ Fail-Over Á¤Ã¥ °ü¸®
- ´ë»ó DBMS :
  Oracle, IBM DB2, MS-SQL, Sybase, Mysql, PostgeSQL, Altibase, Tibero, Symfoware, Cubrid, Teradata, Informix
- OS : Windows, Unix, Linux
- H/W: 3.0Ghz Xeon CPU * 2 EA ÀÌ»ó , 4GB Main Memory ÀÌ»ó