FIX: SQL Server ¿¡ÀÌÀüÆ® ÀÛ¾÷À» SQL Server 2008 ¶Ç´Â SQL Server 2008 R2 µ¿Àû SELECT ¹®ÀÇ ¿­ °æ¿ì ½ÇÇàÇÒ ¶§ ³ôÀº CPU »ç¿ë·®ÀÌ ¸¹Àº ¹®ÀÚ¸¦ °ªÀÌ ÀÖ½À´Ï´Ù.

±â¼ú ÀÚ·á: 2404865 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
±â°è ¹ø¿ªµÈ ¹®¼­±â°è ¹ø¿ª °íÁö »çÇ× º¸±â
Microsoft´Â Microsoft SQL Server 2008 ¹èÆ÷ÇÏ°í Microsoft SQL Server 2008 R2 ´Ù¿î·Îµå °¡´ÉÇÑ ÆÄÀÏ·Î ÇØ°áÇÕ´Ï´Ù. ¼öÁ¤ ÇÁ·Î±×·¥Àº °è¼Ó ´©ÀûµÇ´Â ÇüÅÂÀÔ´Ï´Ù ¶§¹®¿¡ ÇÖÇȽº°¡ ¸ðµÎ °¢ »õ ¸±¸®½º¿¡ Æ÷ÇÔµÈ ÀÌÀü SQL Server 2008 ¶Ç´Â SQL Server 2008 R2 Æ÷ÇÔµÈ ¸ðµç º¸¾È ¸±¸®½ºÀÇ ¼öÁ¤.
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

Çö»ó

´ÙÀ½°ú °°Àº °æ¿ì¸¦ »ý°¢ÇØ º¼ ¼ö ÀÖ½À´Ï´Ù.:
  • You create a stored procedure in Microsoft SQL Server 2008. This stored procedure runs a dynamicSELECTstatement in anEXECUTEstatement or in asp_executesqlstored procedure. In the list of theSELECTstatement, a column has a value that is many characters long.
  • You add aTSQL subsystemstep that runs this stored procedure to a SQL Server Agent job.
  • You select a folder for the output file of theTSQL subsystemstep.
  • You run the SQL Server Agent job.
In this scenario, SQL Server increases CPU usage to a high value. Additionally, the SQL Server Agent job requires a long time to run.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á ¹æ¹ý

´©Àû ¾÷µ¥ÀÌÆ® Á¤º¸

SQL Server 2008

The fix for this issue was first released in Cumulative Update 10 for SQL Server 2008 Service Pack 1. ÀÌ ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
2279604
(http://support.microsoft.com/kb/2279604/LN/ )
Cumulative update package 10 for SQL Server 2008 Service Pack 1
Âü°íºôµå ´©ÀûµÇ´Â ÇüÅÂÀ̹ǷΠ»õ·Î¿î °¢ ¼öÁ¤ ¸±¸®½º ÇÖÇȽº°¡ ¸ðµÎ Æ÷ÇÔÇϸç ÀÌÀü SQL Server 2008 Æ÷ÇÔµÈ ¸ðµç º¸¾È ¸±¸®½ºÀÇ ¼öÁ¤. ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔµÈ ÃֽŠ¼öÁ¤ ¸±¸®½º¸¦ Àû¿ëÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. À§ ÇÖÇȽº °ü·Ã Ãß°¡ Á¤º¸´Â ´ÙÀ½ Microsoft ±â¼ú ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.:
970365
(http://support.microsoft.com/kb/970365/LN/ )
SQL Server 2008 ¼­ºñ½º ÆÑ 1 ¸±¸®½º ÀÌÈÄ¿¡ ¸±¸®½ºµÈ SQL Server 2008 ºôµå
Microsoft SQL Server 2008 ÇÖÇȽº´Â ƯÁ¤ SQL Server ¼­ºñ½º ÆÑÀº ¸¸µé ¼ö ÀÖ½À´Ï´Ù. SQL Server 2008 ¼­ºñ½º ÆÑ 1À» ¼³Ä¡ÇÏ´Â µ¥ SQL Server 2008 ¼­ºñ½º ÆÑ 1 ÇÖÇȽº¸¦ Àû¿ëÇØ¾ß ÇÕ´Ï´Ù. ±âº»ÀûÀ¸·Î SQL Server ¼­ºñ½º ÆÑ¿¡¼­ Á¦°øµÇ´Â ¸ðµç ÇÖÇȽº´Â ´ÙÀ½ SQL Server ¼­ºñ½º ÆÑ¿¡ Æ÷ÇԵ˴ϴÙ.

SQL Server 2008 R2

ÀÌ ¹®Á¦¿¡ ´ëÇÑ ¼öÁ¤ ÇÁ·Î±×·¥Àº ¸ÕÀú ´©Àû ¾÷µ¥ÀÌÆ® 5 ¸±¸®½ºµÇ¾ú½À´Ï´Ù. SQL Server 2008 R2 ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¸¦ ±¸ÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
2438347
(http://support.microsoft.com/kb/2438347/ )
SQL Server 2008 R2 ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö 5
Âü°íºôµå ´©ÀûµÇ´Â ÇüÅÂÀ̹ǷΠ»õ·Î¿î °¢ ¼öÁ¤ ¸±¸®½º ÇÖÇȽº°¡ ¸ðµÎ Æ÷ÇÔÇϸç ÀÌÀü SQL Server 2008 R2 Æ÷ÇÔµÈ ¸ðµç º¸¾È ¸±¸®½ºÀÇ ¼öÁ¤. ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔµÈ ÃֽŠ¼öÁ¤ ¸±¸®½º¸¦ Àû¿ëÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. À§ ÇÖÇȽº °ü·Ã Ãß°¡ Á¤º¸´Â ´ÙÀ½ Microsoft ±â¼ú ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.:
981356
(http://support.microsoft.com/kb/981356/ )
SQL Server 2008 R2 SQL Server 2008 R2 Ãâ½ÃµÈ ÀÌÈÄ¿¡ ¸±¸®½ºµÈ ºôµå

SQL Server 2008 ¼­ºñ½º ÆÑ 2

ÀÌ ¹®Á¦¿¡ ´ëÇÑ ¼öÁ¤ ÇÁ·Î±×·¥Àº SQL Server 2008 ¼­ºñ½º ÆÑ 2 ´©Àû ¾÷µ¥ÀÌÆ® 2´Â ¸ÕÀú ¸±¸®½ºµÇ¾ú½À´Ï´Ù. ÀÌ ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
2467239
(http://support.microsoft.com/kb/2467239/LN/ )
SQL Server 2008 ¼­ºñ½º ÆÑ 2¿ë ´©Àû ¾÷µ¥ÀÌÆ® ÆÐÅ°Áö 2
Âü°íºôµå ´©ÀûµÇ´Â ÇüÅÂÀ̹ǷΠ»õ·Î¿î °¢ ¼öÁ¤ ¸±¸®½º ÇÖÇȽº°¡ ¸ðµÎ Æ÷ÇÔÇϸç ÀÌÀü SQL Server 2008 Æ÷ÇÔµÈ ¸ðµç º¸¾È ¸±¸®½ºÀÇ ¼öÁ¤. ÀÌ ÇÖÇȽº°¡ Æ÷ÇÔµÈ ÃֽŠ¼öÁ¤ ¸±¸®½º¸¦ Àû¿ëÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. À§ ÇÖÇȽº °ü·Ã Ãß°¡ Á¤º¸´Â ´ÙÀ½ Microsoft ±â¼ú ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.:
2402659
(http://support.microsoft.com/kb/2402659/LN/ )
SQL Server 2008 ¼­ºñ½º ÆÑ 2 ¸±¸®½º ÀÌÈÄ¿¡ ¸±¸®½ºµÈ SQL Server 2008 ºôµå
Microsoft SQL Server 2008 ÇÖÇȽº´Â ƯÁ¤ SQL Server ¼­ºñ½º ÆÑÀº ¸¸µé ¼ö ÀÖ½À´Ï´Ù. SQL Server 2008 ¼­ºñ½º ÆÑ 2 ¼³Ä¡¸¦ À§ÇØ SQL Server 2008 ¼­ºñ½º ÆÑ 2ÀÇ ÇÖÇȽº¸¦ Àû¿ëÇØ¾ß ÇÕ´Ï´Ù. ±âº»ÀûÀ¸·Î SQL Server ¼­ºñ½º ÆÑ¿¡¼­ Á¦°øµÇ´Â ¸ðµç ÇÖÇȽº´Â ´ÙÀ½ SQL Server ¼­ºñ½º ÆÑ¿¡ Æ÷ÇԵ˴ϴÙ.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇöÀç »óÅÂ

Microsoft´Â "º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù." Àý¿¡ ³ª¿­µÈ Microsoft Á¦Ç°¿¡¼­ ÀÌ ¹®Á¦°¡ ¹ß»ýÇÏ´Â °ÍÀ» È®ÀÎÇß½À´Ï´Ù..
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÂüÁ¶

SQL ServerÀÇ ÁõºÐ ¼­ºñ½º ¸ðµ¨¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
935897
(http://support.microsoft.com/kb/935897/ )
º¸°íµÈ ¹®Á¦¿¡ ´ëÇÑ ÇÖÇȽº¸¦ Á¦°øÇÏ´Â SQL Server ÆÀÀ¸·ÎºÎÅÍ ÁõºÐ ¼­ºñ½º ¸ðµ¨À» »ç¿ëÇÕ´Ï´Ù
SQL Server ¾÷µ¥ÀÌÆ®ÀÇ ¸í¸í ½ºÅ°¸¶¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
822499
(http://support.microsoft.com/kb/822499/ )
Microsoft SQL Server ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ÆÐÅ°ÁöÀÇ »õ ¸í¸í ½ºÅ°¸¶
¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ® ¿ë¾î¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ¹®¼­¸¦ º¸·Á¸é Microsoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.:
824684
(http://support.microsoft.com/kb/824684/ )
Microsoft ¼ÒÇÁÆ®¿þ¾î ¾÷µ¥ÀÌÆ®¸¦ ¼³¸íÇÏ´Â µ¥ »ç¿ëµÇ´Â Ç¥ÁØ ¿ë¾î¿¡ ´ëÇÑ ¼³¸í
À§·Î °¡±â | Çǵå¹é º¸³»±â

¼Ó¼º

±â¼ú ÀÚ·á: 2404865 - ¸¶Áö¸· °ËÅä: 2011³â 1¿ù 17ÀÏ ¿ù¿äÀÏ - ¼öÁ¤: 2.0
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Workgroup
Å°¿öµå:?
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2404865 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®ÇÏ°í ÀÖ½À´Ï´Ù.
ÀÌ ¹®¼­ÀÇ ¿µ¹® ¹öÀü º¸±â:2404865
(http://support.microsoft.com/kb/2404865/en-us/ )
À§·Î °¡±â | Çǵå¹é º¸³»±â

Çǵå¹é º¸³»±â

 
À§·Î °¡±âÀ§·Î °¡±â