FIX: ÀÖ´Â ¾î¼³¼Ç ¿À·ù DMV SQL Server 2005¿¡¼­ ¶Ç´Â SQL Server 2008ÀÇ sys.dm_broker_activated_tasks Äõ¸®ÇÒ ¶§ ¹ß»ýÇÕ´Ï´Ù.

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

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

Çö»ó

Microsoft SQL Server 2005 ¶Ç´Â Microsoft SQL Server 2008 (DMV) sys.dm_broker_activated_tasks µ¿Àû °ü¸® ºä¸¦ Äõ¸®ÇÒ ¶§ SQL Server ¿À·ù ÄÚµå 3624 ¾î¼³¼Ç ¿À·ù°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ SQL Server ·Î±× Æú´õ ´ýÇÁ ÆÄÀÏÀ» »ý¼ºÇÏ°í SQL Server ·Î±× ÆÄÀÏ¿¡ ´ÙÀ½°ú °°Àº ¿À·ù ¸Þ½ÃÁö°¡ ±â·ÏµÉ ¼ö ÀÖ½À´Ï´Ù.
<Ç¥ÁØ ³¯Â¥ > <spid>dbghelp.dll' Using' ¹öÀü '4.0.5'
<Ç¥ÁØ ³¯Â¥ > <spid>** ½º·¹µå - spid ´ýÇÁ PSS 7629 = 0x00000003B76FCB60 EC = 0x00000003B76FCB70 =
<Ç¥ÁØ ³¯Â¥ > <spid>*** C:\SQL Server\MSSQL.1\MSSQL\LOG\SQLDump1109.txt Àü¼ÛµÇ´Â ½ºÅà ´ýÇÁ
<Ç¥ÁØ ³¯Â¥ > <spid>1
*******************************************************************************
<Ç¥ÁØ ³¯Â¥ > <spid>*
<Ç¥ÁØ ³¯Â¥ > <spid>* ½ºÅà ´ýÇÁ°¡ ½ÃÀÛ:
<Ç¥ÁØ ³¯Â¥ > <SPID>* spid <SPID>< ³¯Â¥ ½Ã°£ >
<Ç¥ÁØ ³¯Â¥ > <spid>*
<Ç¥ÁØ ³¯Â¥ > <spid>* À§Ä¡: "qstvf.cpp":382
<Ç¥ÁØ ³¯Â¥ > <spid>* ½Ä: cbActual < =
PqryscanGet()->PqryGet()->CbMaxLenForAnyObject(pti)
...
<Ç¥ÁØ ³¯Â¥ > <spid>¿À·ù: 3624, ½É°¢µµ: 20, »óÅÂ: 1.
<Ç¥ÁØ ³¯Â¥ > <spid>A ½Ã½ºÅÛ ¾î¼³¼ÇÀ» È®Àο¡ ½ÇÆÐÇß½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº SQL Server ¿À·ù ·Î±×¸¦ È®ÀÎÇϽʽÿÀ. ÀϹÝÀûÀ¸·Î, ¾î¼³¼Ç ¿À·ù ¼ÒÇÁÆ®¿þ¾î ¹ö±× ¶Ç´Â µ¥ÀÌÅÍ ¼Õ»óÀ¸·Î ÀÎÇØ ¹ß»ýÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º ¼Õ»óÀ» °Ë»çÇÏ·Á¸é DBCC CHECKDB¸¦ ½ÇÇàÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù. ¹Ì´Ï ´ýÇÁ ´ýÇÁ¸¦ ¼³Ä¡ °úÁ¤¿¡¼­ Microsoft¿¡ º¸³¾ °ÍÀÎÁö µ¿ÀÇÇÑ °æ¿ì Microsoft¿¡ Àü¼ÛµË´Ï´Ù. ¾÷µ¥ÀÌÆ®¸¦ MicrosoftÀÇ ±â¼ú Áö¿ø QFE ¶Ç´Â ÃֽŠ¼­ºñ½º ÆÑÀ» ±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

¿øÀÎ

SQL Server´Â DMV ±¸ÇöÇÒ ¶§ ¹ß»ýÇÏ´Â ¹®Á¦·Î ÀÎÇØ ÀÌ ¹®Á¦°¡ ¹ß»ýÇÕ´Ï´Ù. ƯÈ÷, Äõ¸® °á°ú ÁýÇÕ¿¡ Æ÷ÇÔÇÒ Çà ¼ö¸¦ miscalculated.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇØ°á ¹æ¹ý

SQL Server 2005

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

SQL Server 2008

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

SQL Server 2008 ¼­ºñ½º ÆÑ 1 (SP1)

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

ÇØ°á °úÁ¤

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é DMV sys.dm_broker_activated_tasks Äõ¸® ÀÛ¾÷À»Áö ¾Ê½À´Ï´Ù.
À§·Î °¡±â | Çǵå¹é º¸³»±â

ÇöÀç »óÅÂ

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

ÂüÁ¶

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

¼Ó¼º

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

Çǵå¹é º¸³»±â

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