|
 |
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 ÀÌ»ó |
|