August 31, 2011 at 5:19 pm
Here is the query, but to tell the truth I completely lost ... and we are trying to get someone to came to the office and help us...:doze:
Thanks for pointing us in the right way...
Juan
August 31, 2011 at 5:20 pm
forgot the query...
1 0 448412 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104236 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E003100320037003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E00430041004A0041003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0037003500390032003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E00530041005000200042007500730069006E0065007300730020004F006E0065003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E00310038003000320033003900380036003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300039003A00330036003A00350036002E003400330033003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0031003000310039003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E00310036003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300031003600330039003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 449174 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104237 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003500310037003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E003100330035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0038003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E00430041004A0041003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0037003500390032003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E00530041005000200042007500730069006E0065007300730020004F006E0065003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E00310037003900380039003900340030003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300039003A00330037003A00330030002E003400380030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330037003A00320030002E003400320030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E003300360038003500300039003C002F00520065006100640073003E003C005700720069007400650073003E00310036003C002F005700720069007400650073003E003C004300500055003E0035003200360034003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300031003600340033003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 449175 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104238 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003000350030003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0035003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065003E00410064006D0069006E006900730074007200610064006F0072003C002F004E00540055007300650072004E0061006D0065003E003C004E00540044006F006D00610069006E004E0061006D0065003E004C0049004400450052003C002F004E00540044006F006D00610069006E004E0061006D0065003E003C0048006F00730074004E0061006D0065003E005300450052005600450052003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044003E0032003000320034003C002F0043006C00690065006E007400500072006F006300650073007300490044003E003C004100700070006C00690063006100740069006F006E004E0061006D0065003E005200650070006F007200740020005300650072007600650072003C002F004100700070006C00690063006100740069006F006E004E0061006D0065003E003C004C006F00670069006E004E0061006D0065003E004C0049004400450052005C00410064006D0069006E006900730074007200610064006F0072003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E003200320031003600320036003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330034003A00340039002E003400320030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003000340037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E00350036003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051005500410041004100410041004100410055005600410041004100410079004B004700740064005A00440064006200370065004C0042004200470042003900410045004100410041003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003400380030003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E004C0049004400450052005C00410064006D0069006E006900730074007200610064006F0072003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 449181 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104239 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330032002E003000300033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003900300037003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330031002E003900300037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003400390039003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 449182 7F827733-0BBD-E011-A284-0026551193F8 80827733-0BBD-E011-A284-0026551193F8 104240 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330035002E003000330033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00390035003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330034002E003900300037003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400310034003A00330038003A00330034002E003900300037003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0033003400300032003500320038003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 330803 7D827733-0BBD-E011-A284-0026551193F8 7E827733-0BBD-E011-A284-0026551193F8 85316 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003900340033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600360030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600360030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600370036003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 330804 7D827733-0BBD-E011-A284-0026551193F8 7E827733-0BBD-E011-A284-0026551193F8 85317 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003400310030003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E003100350036003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003200350033003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003400310030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600390035003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 330805 7D827733-0BBD-E011-A284-0026551193F8 7E827733-0BBD-E011-A284-0026551193F8 85318 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003600390033003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003600360030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310035003A00300032002E003600360030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003700300033003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 330797 7D827733-0BBD-E011-A284-0026551193F8 7E827733-0BBD-E011-A284-0026551193F8 85314 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003200340030003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E003100370033003000300030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003000350030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003200320033003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600350038003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
1 0 330802 7D827733-0BBD-E011-A284-0026551193F8 7E827733-0BBD-E011-A284-0026551193F8 85315 SQL/Notifications/ProcessWMIEventProviderNotification/v1.0 65569 http://schemas.microsoft.com/SQL/Notifications/PostEventNotification 2 http://schemas.microsoft.com/SQL/Notifications/EventNotification 4 X 0xFFFE3C004500560045004E0054005F0049004E005300540041004E00430045003E003C004500760065006E00740054007900700065003E00410055004400490054005F004C004F0047004F00550054003C002F004500760065006E00740054007900700065003E003C0050006F0073007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003700350037003C002F0050006F0073007400540069006D0065003E003C0053005000490044003E00360036003C002F0053005000490044003E003C0044006100740061006200610073006500490044003E0037003C002F0044006100740061006200610073006500490044003E003C004E00540055007300650072004E0061006D0065002F003E003C004E00540044006F006D00610069006E004E0061006D0065002F003E003C0048006F00730074004E0061006D0065003E007300650072007600650072003C002F0048006F00730074004E0061006D0065003E003C0043006C00690065006E007400500072006F006300650073007300490044002F003E003C004100700070006C00690063006100740069006F006E004E0061006D0065002F003E003C004C006F00670069006E004E0061006D0065003E00730061003C002F004C006F00670069006E004E0061006D0065003E003C004400750072006100740069006F006E003E0030003C002F004400750072006100740069006F006E003E003C0053007400610072007400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600330030003C002F0053007400610072007400540069006D0065003E003C0045006E006400540069006D0065003E0032003000310031002D00300038002D00300034005400300031003A00310034003A00350039002E003600330030003C002F0045006E006400540069006D0065003E003C00520065006100640073003E0034003C002F00520065006100640073003E003C005700720069007400650073003E0030003C002F005700720069007400650073003E003C004300500055003E0030003C002F004300500055003E003C0053007500630063006500730073003E0031003C002F0053007500630063006500730073003E003C005300650072007600650072004E0061006D0065003E005300450052005600450052003C002F005300650072007600650072004E0061006D0065003E003C00440061007400610062006100730065004E0061006D0065002F003E003C004C006F00670069006E005300690064003E00410051003D003D003C002F004C006F00670069006E005300690064003E003C005200650071007500650073007400490044003E0030003C002F005200650071007500650073007400490044003E003C004500760065006E007400530065007100750065006E00630065003E0032003600370033003600360035003C002F004500760065006E007400530065007100750065006E00630065003E003C0049007300530079007300740065006D002F003E003C00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E00730061003C002F00530065007300730069006F006E004C006F00670069006E004E0061006D0065003E003C002F004500560045004E0054005F0049004E005300540041004E00430045003E00
August 31, 2011 at 5:21 pm
And also...
17226605
September 1, 2011 at 1:24 am
It seems like there is no processing logi at all to Receive the messages and actually perform any actions based on it.
To get someone in to look at the system is the best you can do. Without knowing what the messaging system is supposed to do, it's could be dangerous to help reducing the number of rows in that queue. Even more since the root cause wouldn't be eliminated so the situation would continue...
Glad I could help to at least point you in the right direction.
September 1, 2011 at 6:55 am
Yes! We are very much grateful for that! Already talked to someone and he is checking this forum thread to see if he can help us out or get us some one who can.
Regards,
Juan
September 1, 2011 at 1:10 pm
One last question, what do you think of doing this:
http://sqlplanet.blogspot.com/2008/07/recreate-corrupt-msdb-database.html
Regards,
Juan
September 1, 2011 at 2:16 pm
juan08 (9/1/2011)
One last question, what do you think of doing this:http://sqlplanet.blogspot.com/2008/07/recreate-corrupt-msdb-database.html
Regards,
Juan
A clear and easy answer: NO!!!!!
As long as you don't know what process is responsible for the messages, rebuilding the msdb doesn't make any sense. If you restore it from a backup, you might end up with the very same scenario.
I tried to narrow down the issue by doing some research:
Before you do any major change, check if there is any alert defined:
EXEC msdb..sp_help_alert
Check for type = 3 and post wmi_namespace and wmi_query values.
As long as I don't know any better I would assume the notification is there for a reason and is just not processed properly.
Of course there are ways to reduce the number of rows in the queue: from receiving the messages without doing anything with the content to disable the queue down to requesting a new broker identifier or even disable Service Broker.
But neither of those methods should be used without knowing why the messages are there at all.
Let me do some more reading. I might find a solution to "reverse-engineer" the communication (using Klaus Aschenbrenners book "SQL Server Service Broker").
Or maybe one of ther ServiceBroker gurus stop by with another idea.
As a side note: You might want to remove the query results from the posts and attach it as txt files.... Definitely will improve readybility of the posts 😉
September 1, 2011 at 3:34 pm
Hi!
Still no expert here! And to make things worse the server collapsed! We have no system. I am installing a new SQL server to see if the SAP is cosign the issue.
The query you suggested shows nothing.
Thanks for keep trying.
Juan
September 1, 2011 at 4:41 pm
Finally I got some one here.
On the other hand I noticed this while looking at the msdbdata.mdf and its log on the windows explorer..the log files was growing at 3 MG rate per second and the server had no connections.
I will let you know how it goes.
Juan
September 2, 2011 at 12:23 am
here's my SSB troubleshooting script: Troubleshooting Service Broker (SSB)[/url]
Seems to me your server isn't coping with the messages load ....
- are there queues stopped ? (on other databases !)
- msdb in many case is just like "the man in the middle", handing over the message to the queue in the db.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 2, 2011 at 12:51 am
Thank you Johan for "joining the party"!!! Much appreciated.
Your script should help to narrow it down even further.
One thing I noticed:
In the last section of the script where END Conversation is forced, in the given scenario I would recommend to add a loop to not delete more than a few hundred conversations at a time since the cleanup of the message queues is a fully logged operation and there are about 17million rows in one queue. Given the load constraints a unrestricted end conversation process could make things even worse...
Therefore, I would rather start with
declare conv cursor for
select top 100 conversation_handle from sys.conversation_endpoints
Then I would check the related log file to make sure things don't get worse
September 2, 2011 at 4:01 am
LutzM (9/2/2011)
Thank you Johan for "joining the party"!!! Much appreciated.Your script should help to narrow it down even further.
One thing I noticed:
In the last section of the script where END Conversation is forced, in the given scenario I would recommend to add a loop to not delete more than a few hundred conversations at a time since the cleanup of the message queues is a fully logged operation and there are about 17million rows in one queue. Given the load constraints a unrestricted end conversation process could make things even worse...
Therefore, I would rather start with
declare conv cursor forselect top 100 conversation_handle from sys.conversation_endpoints
Then I would check the related log file to make sure things don't get worse
Thank you for noticing that ( and reporting it ) !
There is a "go" to much in that section :blush: which I put in comment using /* ... */
I've modified the script according to your advise to prevent further mishaps by blind execution.
( it may take a couple of days to get processed by SSC, but it will get there 😉 )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 2, 2011 at 8:30 am
Thank you for helping ALZDBA.
The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t know why or how to fix it and then he didn´t pay much attention of what we have found here with you guys. (seems common around here with sql experts...they think they know more than everybody else)
Any way...we are today giving service one at a time. SAP is up for two hours now and seems to be fine without issues on the server. In a while we will give some other services...
I will try to use the script johan give us and then I will post the result.
Juan
September 2, 2011 at 9:44 am
juan08 (9/2/2011)
Thank you for helping ALZDBA.The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t know why or how to fix it and then he didn´t pay much attention of what we have found here with you guys. (seems common around here with sql experts...they think they know more than everybody else)
Any way...we are today giving service one at a time. SAP is up for two hours now and seems to be fine without issues on the server. In a while we will give some other services...
I will try to use the script johan give us and then I will post the result.
Juan
SubmitAndPray is involved?? I didn't notice...
[sarcasm on]
Therer's very little you can do: the server will always be too small until you get a Cray and even then they'll ask for more.
And the performance will always be something to complain about (even with a Cray) until you get used to the always rotating hour glass and stop to actually expect any results (not even talking about correct results).
It's most probably not the SQL Server that's suffering to process the messages. It's the SQL Server trying to find any real "message" in the crap thrown at it... :sick:
[sarcasm off]
I'm sorry, I just couldn't resist...
September 2, 2011 at 10:16 am
juan08 (9/2/2011)
Thank you for helping ALZDBA.The guy that came yesterday freed some space and the server is up and running, but the msdb is still 42GB in size. He didn´t know why or how to fix it and then he didn´t pay much attention of what we have found here with you guys. (seems common around here with sql experts...they think they know more than everybody else)
Any way...we are today giving service one at a time. SAP is up for two hours now and seems to be fine without issues on the server. In a while we will give some other services...
I will try to use the script johan give us and then I will post the result.
Juan
Please make sure you run it step by step and please don't run the last code section of the original version (the END Conversation section).
I'd also recommend to run a count(*) before some of the queries just to make sure you're not going to return a few million rows (this might be the case for queries involving sys.transmission_queue, sys.conversation_endpoints, sys.conversation_groups, sys.dm_broker_forwarded_messages and EXEC sp_readerrorlog).
But that advice is nothing special to Johans script, it's more of a general advice...
Viewing 15 posts - 16 through 30 (of 30 total)
You must be logged in to reply to this topic. Login to reply