Clarifications On Queue Service And Queue Readers

How To Prevent Table-locking With Multiple Queue Readers
 

In a situation where messages are coming in faster than they can be processed, at what point will service broker start up another queue_reader? Also, how do you prevent table locking if part of the processing of that message involves inserting or updating data in a table? We are experiencing this problem because of the high number of messages coming through, and I'm not sure what the best solution is - does service broker have some built-in support for preventing contention on a table when multiple readers are running? Or maybe a pattern that can be used to get around it?

View Replies !   View Related

---

Service Queue Disabled
 

Hi all -
 
I have an event in my sql server 2005 box that is fired every 5 seconds.  Source MSSQLSERVER event ID 9274.
 

The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following:  'The service queue "ExternalMailQueue" is currently disabled.'
 
I don't know anything about this queue that is mentioned above.  How do I disable this message or get rid of that queue?
 
TIA

View Replies !   View Related

---

Service Queue Is Currently Disabled - I See This Error A Lot Of Times
I use ALTER QUEUE statement to disable a Service Broker QUEUE then i see message -Service Queue is currently disabled  every 5 sec in SQL server error Log. How can i stop this messages it is enought to see it only one time?

View Replies !   View Related

---

Can See Service Broker Queue With SQL Server Login
I have an application that is reading a message from a Service Broker Queue.  When I use integrated security with an NT account it works fine.  When I use a SQL Server User through Management Studio I can select from the Queue however, when I use this same account through the web app with the SQL Server User, I cannot see the Queue.  Is there a grant that I must do to this account to get it to see the Service Broker Objects?

Gary

 

View Replies !   View Related

---

Service Broker Queue Reader Question
I'm creating an app that could potentially send thousands of messages to a Service Broker queue in a matter of seconds. The stored proc that reads records off the queue will call a remote stored procedure for each message to save data in a remote database.

My question is this. How does Service Broker determine how quickly to read those messages off the queue it was sent to? Ideally I'd like Service Broker to do most of its work when SQL Server isn't busy doing other things instead of contending with SQL Server while it's doing perhaps more important work. Is there any way to control this? How does this work?

Thanks very much - Amos

View Replies !   View Related

---

Calling An SSIS Package From A Service Broker Queue
Posted the same message to the Service Broker forum. But the board is neither responsive nor active. So I am trying this forum. Hope someone can help.

I would like to call an SSIS package from a Service Broker Queue.

There is one way that I am aware of -

Using xp_cmdshell from within an activation stored procedure and using DTEXEC.

Is there a more elegant way of executing an SSIS package from within SSB?

Also,
I am not interested in writing a .NET external activator to process my
messages in the queue. I would like this operation to be strictly
database oriented. Having said this, I am also trying to avoid triggers
processing the messages in the queue.

Thank you!

View Replies !   View Related

---

Calling SSIS Packages From A Service Broker Queue
I would like to call an SSIS package from a Service Broker Queue.

There is one way that I am aware of -

Using xp_cmdshell from within an activation stored procedure and using DTEXEC.

Is there a more elegant way of executing an SSIS package from within SSB?

Also, I am not interested in writing a .NET external activator to process my messages in the queue. I would like this operation to be strictly database oriented. Having said this, I am also trying to avoid triggers processing the messages in the queue.

Thank you!

View Replies !   View Related

---

Performance Counters On Service Broker Transmission Queue
Hello,

is there built-in support for monitoring the number of elements in the transmission queue via performance counters?

Thanks,

View Replies !   View Related

---

I Made A Mistake About Service Name And The Transmission Queue Got Filled Of Them
I want to use SSB as a mean to thread multiple SP invocation of the same procedure. 

When I launched the initator processes it created in the transmission queue error messages saying for each of them that it is an invalid target service name.

The view (sys.transmission_queue) records them in this way in the status column:

"The target service name could not be found. Ensure that the service name is specified correctly and/or the routing information has been supplied."

Services and queues and activation procedure are all defined into the same database.

I drop services and queues, and i tried to create a service with the initial wrong name.  Nothing happened.

Thanks vour your help

View Replies !   View Related

---

SQL Service Broker - How To Resend Messages In Sender Transmission Queue?
 

I have a question about SQL Service Broker.
 
Here are the steps I use to produce the issue.
 
1) I drop the Service Broker on the Receiver by running the following sql script:
 

if exists (select * from sys.services where name = N'//TyMetrix360Audit/DataWriter') drop service [//TyMetrix360Audit/DataWriter]
 
2) I send some messages using the SQL Service broker on the sender side
 
3) The messages I send stay in sender transmission queue.  Here is an example of what my transmission queue looks like after running select * from sys.transmission_queue on the sender.

 
02C54400-309C-DC11-8EED-0002B3D9F7B5 //TyMetrix360Audit/DataWriter 386DDD04-7E55-466A-BE83-37EFC20910B9 tcp://SFT3DEVSQL01:4022/TyMetrix360Audit/DataSender //TyMetrix360Audit/Contract 2007-11-26 14:58:10.207 0 //TyMetrix360Audit/Message 0 0 0x3C003F0078006D006C002000760065007200730069006F006E003D00220031002E0030002200200065006E0063006F00640069006E0067003D0022007500740066002D003100360022003F003E000D000A003C0045006E0074006500720070007200690073006500410075006400690074004400610074006100200078006D006C006E0073003A007800730069003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D0061002D0069006E007300740061006E00630065002200200078006D006C006E0073003A007800730064003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D00610022003E000D000A00200020003C005400610062006C0065004E0061006D0065003E004E004500540057004F0052004B003C002F005400610062006C0065004E0061006D0065003E000D000A00200020003C005000720069006D0061007200790043006F006C0075006D006E004E0061006D0065003E006E006500740077006F0072006B005F00690064003C002F005000720069006D0061007200790043006F006C0075006D006E004E0061006D0065003E000D000A00200020003C004F007000650072006100740069006F006E003E0055003C002F004F007000650072006100740069006F006E003E000D000A00200020003C004400620055007300650072003E00640062006F003C002F004400620055007300650072003E000D000A00200020003C004400610074006100620061007300650020002F003E000D000A00200020003C0044006100740061003E000D000A0020002000200020003C00780073003A0073006300680065006D0061002000690064003D0022004E006500770044006100740061005300650074002200200078006D006C006E0073003D0022002200200078006D006C006E0073003A00780073003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D0061002200200078006D006C006E0073003A006D00730064006100740061003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D006D007300640061007400610022003E000D000A002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022004E00650077004400610074006100530065007400220020006D00730064006100740061003A004900730044006100740061005300650074003D0022007400720075006500220020006D00730064006100740061003A004D00610069006E0044006100740061005400610062006C0065003D0022004400610074006100220020006D00730064006100740061003A00550073006500430075007200720065006E0074004C006F00630061006C0065003D002200740072007500650022003E000D000A00200020002000200020002000200020003C00780073003A0063006F006D0070006C006500780054007900700065003E000D000A0020002000200020002000200020002000200020003C00780073003A00630068006F0069006300650020006D0069006E004F00630063007500720073003D0022003000220020006D00610078004F00630063007500720073003D00220075006E0062006F0075006E0064006500640022003E000D000A002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D002200440061007400610022003E000D000A00200020002000200020002000200020002000200020002000200020003C00780073003A0063006F006D0070006C006500780054007900700065003E000D000A0020002000200020002000200020002000200020002000200020002000200020003C00780073003A00730065007100750065006E00630065003E000D000A002000200020002000200020002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022006E006500740077006F0072006B005F00690064002200200074007900700065003D002200780073003A0069006E007400220020006D0069006E004F00630063007500720073003D0022003000220020002F003E000D000A002000200020002000200020002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022006E006500740077006F0072006B005F006E0061006D0065002200200074007900700065003D002200780073003A0073007400720069006E006700220020006D0069006E004F00630063007500720073003D0022003000220020002F003E000D000A0020002000200020002000200020002000200020002000200020002000200020003C002F00780073003A00730065007100750065006E00630065003E000D000A00200020002000200020002000200020002000200020002000200020003C002F00780073003A0063006F006D0070006C006500780054007900700065003E000D000A002000200020002000200020002000200020002000200020003C002F00780073003A0065006C0065006D0065006E0074003E000D000A0020002000200020002000200020002000200020003C002F00780073003A00630068006F006900630065003E000D000A00200020002000200020002000200020003C002F00780073003A0063006F006D0070006C006500780054007900700065003E000D000A002000200020002000200020003C002F00780073003A0065006C0065006D0065006E0074003E000D000A0020002000200020003C002F00780073003A0073006300680065006D0061003E000D000A0020002000200020003C006400690066006600670072003A0064006900660066006700720061006D00200078006D006C006E0073003A006D00730064006100740061003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D006D00730064006100740061002200200078006D006C006E0073003A006400690066006600670072003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D0064006900660066006700720061006D002D007600310022003E000D000A002000200020002000200020003C0044006F00630075006D0065006E00740045006C0065006D0065006E0074003E000D000A00200020002000200020002000200020003C00440061007400610020006400690066006600670072003A00690064003D00220044006100740061003100220020006D00730064006100740061003A0072006F0077004F0072006400650072003D002200300022003E000D000A0020002000200020002000200020002000200020003C006E006500740077006F0072006B005F00690064003E0031003C002F006E006500740077006F0072006B005F00690064003E000D000A0020002000200020002000200020002000200020003C006E006500740077006F0072006B005F006E0061006D0065003E00780066006400660064006600640066003C002F006E006500740077006F0072006B005F006E0061006D0065003E000D000A00200020002000200020002000200020003C002F0044006100740061003E000D000A002000200020002000200020003C002F0044006F00630075006D0065006E00740045006C0065006D0065006E0074003E000D000A0020002000200020003C002F006400690066006600670072003A0064006900660066006700720061006D003E000D000A00200020003C002F0044006100740061003E000D000A00200020003C004F007000650072006100740069006F006E00540069006D0065003E0032003000300037002D00310031002D00320036005400310034003A00350038003A00310030002E0030003900380036003100350035005A003C002F004F007000650072006100740069006F006E00540069006D0065003E000D000A00200020003C0042006C006F00620043006F006C0075006D006E004E0061006D006500730020002F003E000D000A00200020003C0042006C006F00620047005500490044003E00630061006200610037006500660039002D0066003500650065002D0034006200370035002D0061006400360030002D003000390063003500330038003500640031003100310031003C002F0042006C006F00620047005500490044003E000D000A003C002F0045006E00740065007200700072006900730065004100750064006900740044006100740061003E00 Service Broker received an error message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation.
F620FA2D-309C-DC11-8EED-0002B3D9F7B5 //TyMetrix360Audit/DataWriter 386DDD04-7E55-466A-BE83-37EFC20910B9 tcp://SFT3DEVSQL01:4022/TyMetrix360Audit/DataSender //TyMetrix360Audit/Contract 2007-11-26 14:59:26.813 0 //TyMetrix360Audit/Message 0 0 0x3C003F0078006D006C002000760065007200730069006F006E003D00220031002E0030002200200065006E0063006F00640069006E0067003D0022007500740066002D003100360022003F003E000D000A003C0045006E0074006500720070007200690073006500410075006400690074004400610074006100200078006D006C006E0073003A007800730069003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D0061002D0069006E007300740061006E00630065002200200078006D006C006E0073003A007800730064003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D00610022003E000D000A00200020003C005400610062006C0065004E0061006D0065003E004E004500540057004F0052004B003C002F005400610062006C0065004E0061006D0065003E000D000A00200020003C005000720069006D0061007200790043006F006C0075006D006E004E0061006D0065003E006E006500740077006F0072006B005F00690064003C002F005000720069006D0061007200790043006F006C0075006D006E004E0061006D0065003E000D000A00200020003C004F007000650072006100740069006F006E003E0055003C002F004F007000650072006100740069006F006E003E000D000A00200020003C004400620055007300650072003E00640062006F003C002F004400620055007300650072003E000D000A00200020003C004400610074006100620061007300650020002F003E000D000A00200020003C0044006100740061003E000D000A0020002000200020003C00780073003A0073006300680065006D0061002000690064003D0022004E006500770044006100740061005300650074002200200078006D006C006E0073003D0022002200200078006D006C006E0073003A00780073003D00220068007400740070003A002F002F007700770077002E00770033002E006F00720067002F0032003000300031002F0058004D004C0053006300680065006D0061002200200078006D006C006E0073003A006D00730064006100740061003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D006D007300640061007400610022003E000D000A002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022004E00650077004400610074006100530065007400220020006D00730064006100740061003A004900730044006100740061005300650074003D0022007400720075006500220020006D00730064006100740061003A004D00610069006E0044006100740061005400610062006C0065003D0022004400610074006100220020006D00730064006100740061003A00550073006500430075007200720065006E0074004C006F00630061006C0065003D002200740072007500650022003E000D000A00200020002000200020002000200020003C00780073003A0063006F006D0070006C006500780054007900700065003E000D000A0020002000200020002000200020002000200020003C00780073003A00630068006F0069006300650020006D0069006E004F00630063007500720073003D0022003000220020006D00610078004F00630063007500720073003D00220075006E0062006F0075006E0064006500640022003E000D000A002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D002200440061007400610022003E000D000A00200020002000200020002000200020002000200020002000200020003C00780073003A0063006F006D0070006C006500780054007900700065003E000D000A0020002000200020002000200020002000200020002000200020002000200020003C00780073003A00730065007100750065006E00630065003E000D000A002000200020002000200020002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022006E006500740077006F0072006B005F00690064002200200074007900700065003D002200780073003A0069006E007400220020006D0069006E004F00630063007500720073003D0022003000220020002F003E000D000A002000200020002000200020002000200020002000200020002000200020002000200020003C00780073003A0065006C0065006D0065006E00740020006E0061006D0065003D0022006E006500740077006F0072006B005F006E0061006D0065002200200074007900700065003D002200780073003A0073007400720069006E006700220020006D0069006E004F00630063007500720073003D0022003000220020002F003E000D000A0020002000200020002000200020002000200020002000200020002000200020003C002F00780073003A00730065007100750065006E00630065003E000D000A00200020002000200020002000200020002000200020002000200020003C002F00780073003A0063006F006D0070006C006500780054007900700065003E000D000A002000200020002000200020002000200020002000200020003C002F00780073003A0065006C0065006D0065006E0074003E000D000A0020002000200020002000200020002000200020003C002F00780073003A00630068006F006900630065003E000D000A00200020002000200020002000200020003C002F00780073003A0063006F006D0070006C006500780054007900700065003E000D000A002000200020002000200020003C002F00780073003A0065006C0065006D0065006E0074003E000D000A0020002000200020003C002F00780073003A0073006300680065006D0061003E000D000A0020002000200020003C006400690066006600670072003A0064006900660066006700720061006D00200078006D006C006E0073003A006D00730064006100740061003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D006D00730064006100740061002200200078006D006C006E0073003A006400690066006600670072003D002200750072006E003A0073006300680065006D00610073002D006D006900630072006F0073006F00660074002D0063006F006D003A0078006D006C002D0064006900660066006700720061006D002D007600310022003E000D000A002000200020002000200020003C0044006F00630075006D0065006E00740045006C0065006D0065006E0074003E000D000A00200020002000200020002000200020003C00440061007400610020006400690066006600670072003A00690064003D00220044006100740061003100220020006D00730064006100740061003A0072006F0077004F0072006400650072003D002200300022003E000D000A0020002000200020002000200020002000200020003C006E006500740077006F0072006B005F00690064003E0031003C002F006E006500740077006F0072006B005F00690064003E000D000A0020002000200020002000200020002000200020003C006E006500740077006F0072006B005F006E0061006D0065003E00780066006400660064006600640066003C002F006E006500740077006F0072006B005F006E0061006D0065003E000D000A00200020002000200020002000200020003C002F0044006100740061003E000D000A002000200020002000200020003C002F0044006F00630075006D0065006E00740045006C0065006D0065006E0074003E000D000A0020002000200020003C002F006400690066006600670072003A0064006900660066006700720061006D003E000D000A00200020003C002F0044006100740061003E000D000A00200020003C004F007000650072006100740069006F006E00540069006D0065003E0032003000300037002D00310031002D00320036005400310034003A00350039003A00320036002E0037003800340036003400330031005A003C002F004F007000650072006100740069006F006E00540069006D0065003E000D000A00200020003C0042006C006F00620043006F006C0075006D006E004E0061006D006500730020002F003E000D000A00200020003C0042006C006F00620047005500490044003E00350034006300380036006200330036002D0061006300330066002D0034006600300034002D0062006600660066002D003400310062003800310065003500360035006500360066003C002F0042006C006F00620047005500490044003E000D000A003C002F0045006E00740065007200700072006900730065004100750064006900740044006100740061003E00 Service Broker received an error message on this conversation. Service Broker will not transmit the message; it will be held until the application ends the conversation.
 

The main point is that the sys.transmission queue retains the messages with the error 'Service Broker will not transmit the message; it will be held until the application ends the conversation.'
 
4. I execute the following sql statment on the sender:

select * from sys.conversation_endpoints
 
and see that the conversation that sent the messages are in state 'ER'
 
5. I then recreate the receiver with the following script:
 

create service [//TyMetrix360Audit/DataWriter] authorization dbo on queue dbo.TyMetrix360AuditQueue([//TyMetrix360Audit/Contract])
 
6. I send some more messages and see that the new messages are being received and processed correctly.
 
7. But what of the messages stuck in the sender transmission queue.  How are these messages to be resent?  Since the conversations are in state 'ER' it seems they are not being resent.  Do I need to write a custom SQL script to resend them?     I do not want to end the conversation because the message will be lost and not resent.
 
 
So, in conclusion, the main question is:
 
When the receiver goes down, or the receiver service broker simply does not exist and messages pile up the sender transmission queue like in my example how do these messages get resent when the receiver is restored? 
 
By the way when I run

select service_broker_guid from sys.databases where database_id = db_id()

I get the same GUID after the server is restored.
 
Thanks
 
 

View Replies !   View Related

---

SQL Service Broker - How To Resend Messages Stuck In Sender Transmission Queue
Here is a description:
 
1. drop receiver side service broker with sql command : drop service [//TyMetrix360Audit/DataWriter]
 
2. send a message from the sender.
 
3. now the sys.transmission_queue on the sender keeps the message.
 
The relevant tables on the sender and receiver no look like this:
 
the following summarizes the transmission queue on the SENDER:
 
conversation handle                                          message_body                                    transmission status 
5A0F1D1F-449C-DC11-8EED-0002B3D9F7B5    my message in binary, ie 0x.F4E1....     <blank>
 
the following summarizes the sys.conversation_endpoints on the SENDER:
 
conversation handle                                          conversation_id                                                 state
5A0F1D1F-449C-DC11-8EED-0002B3D9F7B5    461891C8-5D53-4D89-A7C6-097FE2EDB22A      CO
 
the following summarizes the transmission queue on the RECEIVER:
 
conversation handle                                          message_body                                  transmission status            
5A0F1D1F-449C-DC11-8EED-0002B3D9F7B5    message body of error message......    One or more messages could not be delivered to the local service targeted by this dialog.
 
the following summarizes the sys.conversation_endpoints on the RECEIVER:
 
conversation handle                                          conversation_id                                                 state
5A0F1D1F-449C-DC11-8EED-0002B3D9F7B5    461891C8-5D53-4D89-A7C6-097FE2EDB22A      DO
 
 
What do I do now?
 
There is a message stuck in the sender transmission queue.  You responded in my last post that I need to do a RECIEVE on the sender and end the conversation myself?    This is not helping me.  I am still confused about the answer to this.  Can you provide some sort of code outline or steps to resolve this issue.  As of now I do not know how to resend my messages stuck in the sender transmission queue and they can not be lost when the conversation is ended.
 
Also, I thought SQL Service broker was supposed to hadle things like this.   It is common for the receiver to not be there.  In this case the messages should resend automatically once the receiver is back up.  Please help as there is no documentation online about how to resolve this issue and your last response was not adequate.
 
Thanks
 

View Replies !   View Related

---

First Service Broker Attempt, Prajdic's Example, Error: &&"queue Has Been Disabled&&"
 

I am using the Centralized Asynchronous Auditing with Service Broker article example to set up my first Service Broker attempt.  We want to start logging search criteria and search results for our product search page.  We wanted it to be asynchronous and be stored in another dbase, this seemed like the perfect example.
 
I modified the example above to save into an Audit table we created and to read a custom message that I generated the XML for.  I'm pretty certain that should all work.  However, I didn't change much else but I can't get the message to send.
 
This is the error I'm getting in profiler:
This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742.
 
I am sending from one database to another within the same SQL server instance.  Here are the profiler details
SQL:BatchStarting 
EXEC dbo.usp_SendAuditData @X Microsoft SQL Server Management Studio - Query Larry APP1Larry     
Broker:Conversation Group  Microsoft SQL Server Management Studio - Query Larry      
Broker:Conversation STARTED_OUTBOUND Microsoft SQL Server Management Studio - Query Larry      
Broker:Conversation CONVERSING Microsoft SQL Server Management Studio - Query Larry      
Broker:Message Classify   Microsoft SQL Server Management Studio - Query Larry      
Broker:Message Undeliverable This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742. Microsoft SQL Server Management Studio - Query Larry APP1Larry     
SQL:BatchCompleted 
EXEC dbo.usp_SendAuditData @X Microsoft SQL Server Management Studio - Query Larry APP1Larry 
Broker:Message Classify           
Broker:Remote Message Acknowledgement          
Broker:Remote Message Acknowledgement          
Broker:Remote Message Acknowledgement          
Broker:Message Classify           
Broker:Message Undeliverable This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742.   sa      
Broker:Message Undeliverable This message was dropped because it could not be dispatched on time. State: 2   sa      
Broker:Message Undeliverable This message was dropped because it could not be dispatched on time. State: 2   sa 
 

When I run SELECT * FROM sys.transmission_queue I get this in the transmission_status:
"One or more messages could not be delivered to the local service targeted by this dialog."

 
I'm hoping someone can point me in the right direciton, thanks.

View Replies !   View Related

---

Error: The Service Queue &&"ClientQueue&&" Is Currently Disabled.
Well I downloaded an example (HelloWorld) from www.SQLServiceBroker.com yesterday and it WAS working this morning, however; now I'm getting this error:

View Replies !   View Related

---

An Error Occurred In The Service Broker Internal Activator While Trying To Scan The User Queue '(null)' For Its Status. Error: 2
Hello - can't find any info on this error - can anyone shed some light?

 

There was a deadlock - which preceeded this message by 2 seconds.

 

 

 

04/25/2007 08:20:12,spid108,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid108,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:12,spid108,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:12,spid108,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:12,spid108,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:12,spid108,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:12,spid108,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:12,spid108,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:12,spid108,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:12,spid108,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:12,spid108,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:12,spid108,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:12,spid108,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:12,spid108,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:12,spid108,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:12,spid108,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:12,spid108,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:12,spid108,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:12,spid108,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:12,spid108,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:12,spid108,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:12,spid108,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:12,spid108,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:12,spid108,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:12,spid108,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:12,spid108,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:12,spid108,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,* Short Stack Dump
04/25/2007 08:20:12,spid108,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,*      SegSs: 00000023:
04/25/2007 08:20:12,spid108,Unknown,*        Esp: 1302E584:  13025387  80C87378  80C872F0  00000000  78140001  0009D9C2
04/25/2007 08:20:12,spid108,Unknown,*     EFlags: 00010202:  00610067  00650074  0049003B  0076006E  006C0061  00640069
04/25/2007 08:20:12,spid108,Unknown,*      SegCs: 0000001B:
04/25/2007 08:20:12,spid108,Unknown,*        Ebp: 1302F67C:  1302F788  01793310  13025373  80C872F0  7093AB12  801E8B38
04/25/2007 08:20:12,spid108,Unknown,*        Eip: 0179438B:  828B118B  000000E0  C085D0FF  00B9850F  9D890000  FFFFEF8C
04/25/2007 08:20:12,spid108,Unknown,*        Edx: 00000E38:
04/25/2007 08:20:12,spid108,Unknown,*        Ecx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Ebx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Eax: A99EE598:  00000000  00000000  A99EE5B0  00000000  00000000  00000000
04/25/2007 08:20:12,spid108,Unknown,*        Esi: 00000000:
04/25/2007 08:20:12,spid108,Unknown,*        Edi: 80C872F0:  7093AB12  80C87FF0  00000007  B8A20008  7093AB15  00000000
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* dbghelp                        14200000  14312FFF  00113000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       76780000  76913FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       764A0000  76633FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       76300000  76493FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       341D0000  343AFFFF  001e0000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       33590000  33764FFF  001d5000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       333F0000  33583FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       14490000  1467AFFF  001eb000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       13D10000  13EFBFFF  001ec000
04/25/2007 08:20:12,spid108,Unknown,* OLEDB32R                       13770000  13780FFF  00011000
04/25/2007 08:20:12,spid108,Unknown,* MSDART                         133D0000  133E9FFF  0001a000
04/25/2007 08:20:12,spid108,Unknown,* oledb32                        13350000  133C8FFF  00079000
04/25/2007 08:20:12,spid108,Unknown,* msxml3                         11BD0000  11CE1FFF  00112000
04/25/2007 08:20:12,spid108,Unknown,* msxmlsql                       11AF0000  11BC5FFF  000d6000
04/25/2007 08:20:12,spid108,Unknown,* System.Xml                     10FA0000  11193FFF  001f4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security                10F20000  10F61FFF  00042000
04/25/2007 08:20:12,spid108,Unknown,* System                         10C10000  10EF3FFF  002e4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security.ni             10A90000  10B45FFF  000b6000
04/25/2007 08:20:12,spid108,Unknown,* System.Transactions            0FAD0000  0FB12FFF  00043000
04/25/2007 08:20:12,spid108,Unknown,* System.ni                      7A440000  7ABFDFFF  007be000
04/25/2007 08:20:12,spid108,Unknown,* System.Data                    102D0000  10596FFF  002c7000
04/25/2007 08:20:12,spid108,Unknown,* mscorjit                       0F910000  0F962FFF  00053000
04/25/2007 08:20:12,spid108,Unknown,* SqlAccess                      0F8A0000  0F8F5FFF  00056000
04/25/2007 08:20:12,spid108,Unknown,* SensApi                        0F880000  0F884FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* cryptnet                       0F680000  0F691FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* SOFTPUB                        0F670000  0F674FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* mscorsec                       0F640000  0F652FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* mscorlib.ni                    0EAC0000  0F5A7FFF  00ae8000
04/25/2007 08:20:12,spid108,Unknown,* mscorwks                       080E0000  08640FFF  00561000
04/25/2007 08:20:12,spid108,Unknown,* xplog70                        07CA0000  07CA2FFF  00003000
04/25/2007 08:20:12,spid108,Unknown,* xplog70                        07C80000  07C8BFFF  0000c000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90                       07C50000  07C75FFF  00026000
04/25/2007 08:20:12,spid108,Unknown,* odbcint                        07C30000  07C46FFF  00017000
04/25/2007 08:20:12,spid108,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
04/25/2007 08:20:12,spid108,Unknown,* BatchParser90                  07A40000  07A5EFFF  0001f000
04/25/2007 08:20:12,spid108,Unknown,* ODBC32                         07A00000  07A3CFFF  0003d000
04/25/2007 08:20:12,spid108,Unknown,* SQLSCM90                       079E0000  079E8FFF  00009000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90                       07980000  079C7FFF  00048000
04/25/2007 08:20:12,spid108,Unknown,* xpsqlbot                       07960000  07965FFF  00006000
04/25/2007 08:20:12,spid108,Unknown,* msftepxy                       07490000  074A4FFF  00015000
04/25/2007 08:20:12,spid108,Unknown,* SQLNCLIR                       007A0000  007D2FFF  00033000
04/25/2007 08:20:12,spid108,Unknown,* comdlg32                       762B0000  762F9FFF  0004a000
04/25/2007 08:20:12,spid108,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
04/25/2007 08:20:12,spid108,Unknown,* sqlncli                        337A0000  339C1FFF  00222000
04/25/2007 08:20:12,spid108,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
04/25/2007 08:20:12,spid108,Unknown,* xpsp2res                       10000000  102C4FFF  002c5000
04/25/2007 08:20:12,spid108,Unknown,* ntdsapi                        766F0000  76704FFF  00015000
04/25/2007 08:20:12,spid108,Unknown,* wshtcpip                       070B0000  070B7FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* hnetcfg                        071F0000  07248FFF  00059000
04/25/2007 08:20:12,spid108,Unknown,* dssenh                         070C0000  070E3FFF  00024000
04/25/2007 08:20:12,spid108,Unknown,* imagehlp                       76C10000  76C38FFF  00029000
04/25/2007 08:20:12,spid108,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
04/25/2007 08:20:12,spid108,Unknown,* dbghelp                        06C10000  06D22FFF  00113000
04/25/2007 08:20:12,spid108,Unknown,* msfte                          069B0000  06C08FFF  00259000
04/25/2007 08:20:12,spid108,Unknown,* security                       06190000  06193FFF  00004000
04/25/2007 08:20:12,spid108,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* winrnr                         76F70000  76F76FFF  00007000
04/25/2007 08:20:12,spid108,Unknown,* DNSAPI                         76ED0000  76EF8FFF  00029000
04/25/2007 08:20:12,spid108,Unknown,* RESUTILS                       05D50000  05D62FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* CLUSAPI                        05D30000  05D41FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* OLEAUT32                       77D00000  77D8BFFF  0008c000
04/25/2007 08:20:12,spid108,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
04/25/2007 08:20:12,spid108,Unknown,* VERSION                        77B90000  77B97FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* MTXCLU                         05D10000  05D28FFF  00019000
04/25/2007 08:20:12,spid108,Unknown,* msvcp60                        780C0000  78120FFF  00061000
04/25/2007 08:20:12,spid108,Unknown,* MSDTCPRX                       05C90000  05D07FFF  00078000
04/25/2007 08:20:12,spid108,Unknown,* XOLEHLP                        05C80000  05C85FFF  00006000
04/25/2007 08:20:12,spid108,Unknown,* COMRES                         77010000  770D5FFF  000c6000
04/25/2007 08:20:12,spid108,Unknown,* schannel                       76750000  76776FFF  00027000
04/25/2007 08:20:12,spid108,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
04/25/2007 08:20:12,spid108,Unknown,* kerberos                       05BC0000  05C17FFF  00058000
04/25/2007 08:20:12,spid108,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
04/25/2007 08:20:12,spid108,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
04/25/2007 08:20:12,spid108,Unknown,* MSCOREE                        05950000  05994FFF  00045000
04/25/2007 08:20:12,spid108,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
04/25/2007 08:20:12,spid108,Unknown,* rsaenh                         04E90000  04EBEFFF  0002f000
04/25/2007 08:20:12,spid108,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
04/25/2007 08:20:12,spid108,Unknown,* SAMLIB                         5CCF0000  5CCFEFFF  0000f000
04/25/2007 08:20:12,spid108,Unknown,* ole32                          77670000  777A3FFF  00134000
04/25/2007 08:20:12,spid108,Unknown,* NTMARTA                        77E00000  77E21FFF  00022000
04/25/2007 08:20:12,spid108,Unknown,* SQLOS                          344D0000  344D4FFF  00005000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70                       4F610000  4F7A3FFF  00194000
04/25/2007 08:20:12,spid108,Unknown,* instapi                        48060000  48069FFF  0000a000
04/25/2007 08:20:12,spid108,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
04/25/2007 08:20:12,spid108,Unknown,* comctl32                       77420000  77522FFF  00103000
04/25/2007 08:20:12,spid108,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
04/25/2007 08:20:12,spid108,Unknown,* SHELL32                        7C8D0000  7D0D2FFF  00803000
04/25/2007 08:20:12,spid108,Unknown,* NETAPI32                       71C40000  71C97FFF  00058000
04/25/2007 08:20:12,spid108,Unknown,* opends60                       333E0000  333E6FFF  00007000
04/25/2007 08:20:12,spid108,Unknown,* USERENV                        76920000  769E3FFF  000c4000
04/25/2007 08:20:12,spid108,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
04/25/2007 08:20:12,spid108,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
04/25/2007 08:20:12,spid108,Unknown,* MSWSOCK                        71B20000  71B60FFF  00041000
04/25/2007 08:20:12,spid108,Unknown,* Secur32                        76F50000  76F62FFF  00013000
04/25/2007 08:20:12,spid108,Unknown,* MSASN1                         76190000  761A1FFF  00012000
04/25/2007 08:20:12,spid108,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
04/25/2007 08:20:12,spid108,Unknown,* GDI32                          77C00000  77C47FFF  00048000
04/25/2007 08:20:12,spid108,Unknown,* USER32                         77380000  77411FFF  00092000
04/25/2007 08:20:12,spid108,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
04/25/2007 08:20:12,spid108,Unknown,* ADVAPI32                       77F50000  77FEBFFF  0009c000
04/25/2007 08:20:12,spid108,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
04/25/2007 08:20:12,spid108,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
04/25/2007 08:20:12,spid108,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
04/25/2007 08:20:12,spid108,Unknown,* kernel32                       77E40000  77F41FFF  00102000
04/25/2007 08:20:12,spid108,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
04/25/2007 08:20:12,spid108,Unknown,* sqlservr                       01000000  02BCEFFF  01bcf000
04/25/2007 08:20:12,spid108,Unknown,*  MODULE                          BASE      END       SIZE
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*   Access Violation occurred reading address 00000000
04/25/2007 08:20:12,spid108,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:12,spid108,Unknown,*   Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*   04/25/07 08:20:12 spid 108
04/25/2007 08:20:12,spid108,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,SqlDumpExceptionHandler: Process 108 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:12,spid108,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0007.txt
04/25/2007 08:20:12,spid108,Unknown,Using 'dbghelp.dll' version '4.0.5'
04/25/2007 08:20:12,spid60,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid60,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:10,spid60,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:10,spid60,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:10,spid60,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:10,spid60,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:10,spid60,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:10,spid60,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:10,spid60,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:10,spid60,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:10,spid60,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:10,spid60,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:10,spid60,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:10,spid60,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:10,spid60,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:10,spid60,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:10,spid60,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:10,spid60,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:10,spid60,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:10,spid60,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:10,spid60,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:10,spid60,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:10,spid60,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:10,spid60,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:10,spid60,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:10,spid60,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:10,spid60,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,* Short Stack Dump
04/25/2007 08:20:10,spid60,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,*      SegSs: 00000023:
04/25/2007 08:20:10,spid60,Unknown,*        Esp: 1189E584:  11895387  80C87378  80C872F0  00000000  03E90001  00087C2D
04/25/2007 08:20:10,spid60,Unknown,*     EFlags: 00010202:  00610067  00650074  0049003B  0076006E  006C0061  00640069
04/25/2007 08:20:10,spid60,Unknown,*      SegCs: 0000001B:
04/25/2007 08:20:10,spid60,Unknown,*        Ebp: 1189F67C:  1189F788  01793310  11895373  80C872F0  7093AB12  801E8B38
04/25/2007 08:20:10,spid60,Unknown,*        Eip: 0179438B:  828B118B  000000E0  C085D0FF  00B9850F  9D890000  FFFFEF8C
04/25/2007 08:20:10,spid60,Unknown,*        Edx: 00000E38:
04/25/2007 08:20:10,spid60,Unknown,*        Ecx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Ebx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Eax: 5ADE8598:  00000000  00000000  5ADE85B0  00000000  00000000  00000000
04/25/2007 08:20:10,spid60,Unknown,*        Esi: 00000000:
04/25/2007 08:20:10,spid60,Unknown,*        Edi: 80C872F0:  7093AB12  80C87FF0  00000007  B8A20008  7093AB15  00000000
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* dbghelp                        14200000  14312FFF  00113000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       76780000  76913FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       764A0000  76633FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       76300000  76493FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       341D0000  343AFFFF  001e0000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       33590000  33764FFF  001d5000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       333F0000  33583FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       14490000  1467AFFF  001eb000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       13D10000  13EFBFFF  001ec000
04/25/2007 08:20:10,spid60,Unknown,* OLEDB32R                       13770000  13780FFF  00011000
04/25/2007 08:20:10,spid60,Unknown,* MSDART                         133D0000  133E9FFF  0001a000
04/25/2007 08:20:10,spid60,Unknown,* oledb32                        13350000  133C8FFF  00079000
04/25/2007 08:20:10,spid60,Unknown,* msxml3                         11BD0000  11CE1FFF  00112000
04/25/2007 08:20:10,spid60,Unknown,* msxmlsql                       11AF0000  11BC5FFF  000d6000
04/25/2007 08:20:10,spid60,Unknown,* System.Xml                     10FA0000  11193FFF  001f4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security                10F20000  10F61FFF  00042000
04/25/2007 08:20:10,spid60,Unknown,* System                         10C10000  10EF3FFF  002e4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security.ni             10A90000  10B45FFF  000b6000
04/25/2007 08:20:10,spid60,Unknown,* System.Transactions            0FAD0000  0FB12FFF  00043000
04/25/2007 08:20:10,spid60,Unknown,* System.ni                      7A440000  7ABFDFFF  007be000
04/25/2007 08:20:10,spid60,Unknown,* System.Data                    102D0000  10596FFF  002c7000
04/25/2007 08:20:10,spid60,Unknown,* mscorjit                       0F910000  0F962FFF  00053000
04/25/2007 08:20:10,spid60,Unknown,* SqlAccess                      0F8A0000  0F8F5FFF  00056000
04/25/2007 08:20:10,spid60,Unknown,* SensApi                        0F880000  0F884FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* cryptnet                       0F680000  0F691FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* SOFTPUB                        0F670000  0F674FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* mscorsec                       0F640000  0F652FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* mscorlib.ni                    0EAC0000  0F5A7FFF  00ae8000
04/25/2007 08:20:10,spid60,Unknown,* mscorwks                       080E0000  08640FFF  00561000
04/25/2007 08:20:10,spid60,Unknown,* xplog70                        07CA0000  07CA2FFF  00003000
04/25/2007 08:20:10,spid60,Unknown,* xplog70                        07C80000  07C8BFFF  0000c000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90                       07C50000  07C75FFF  00026000
04/25/2007 08:20:10,spid60,Unknown,* odbcint                        07C30000  07C46FFF  00017000
04/25/2007 08:20:10,spid60,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
04/25/2007 08:20:10,spid60,Unknown,* BatchParser90                  07A40000  07A5EFFF  0001f000
04/25/2007 08:20:10,spid60,Unknown,* ODBC32                         07A00000  07A3CFFF  0003d000
04/25/2007 08:20:10,spid60,Unknown,* SQLSCM90                       079E0000  079E8FFF  00009000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90                       07980000  079C7FFF  00048000
04/25/2007 08:20:10,spid60,Unknown,* xpsqlbot                       07960000  07965FFF  00006000
04/25/2007 08:20:10,spid60,Unknown,* msftepxy                       07490000  074A4FFF  00015000
04/25/2007 08:20:10,spid60,Unknown,* SQLNCLIR                       007A0000  007D2FFF  00033000
04/25/2007 08:20:10,spid60,Unknown,* comdlg32                       762B0000  762F9FFF  0004a000
04/25/2007 08:20:10,spid60,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
04/25/2007 08:20:10,spid60,Unknown,* sqlncli                        337A0000  339C1FFF  00222000
04/25/2007 08:20:10,spid60,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
04/25/2007 08:20:10,spid60,Unknown,* xpsp2res                       10000000  102C4FFF  002c5000
04/25/2007 08:20:10,spid60,Unknown,* ntdsapi                        766F0000  76704FFF  00015000
04/25/2007 08:20:10,spid60,Unknown,* wshtcpip                       070B0000  070B7FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* hnetcfg                        071F0000  07248FFF  00059000
04/25/2007 08:20:10,spid60,Unknown,* dssenh                         070C0000  070E3FFF  00024000
04/25/2007 08:20:10,spid60,Unknown,* imagehlp                       76C10000  76C38FFF  00029000
04/25/2007 08:20:10,spid60,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
04/25/2007 08:20:10,spid60,Unknown,* dbghelp                        06C10000  06D22FFF  00113000
04/25/2007 08:20:10,spid60,Unknown,* msfte                          069B0000  06C08FFF  00259000
04/25/2007 08:20:10,spid60,Unknown,* security                       06190000  06193FFF  00004000
04/25/2007 08:20:10,spid60,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* winrnr                         76F70000  76F76FFF  00007000
04/25/2007 08:20:10,spid60,Unknown,* DNSAPI                         76ED0000  76EF8FFF  00029000
04/25/2007 08:20:10,spid60,Unknown,* RESUTILS                       05D50000  05D62FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* CLUSAPI                        05D30000  05D41FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* OLEAUT32                       77D00000  77D8BFFF  0008c000
04/25/2007 08:20:10,spid60,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
04/25/2007 08:20:10,spid60,Unknown,* VERSION                        77B90000  77B97FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* MTXCLU                         05D10000  05D28FFF  00019000
04/25/2007 08:20:10,spid60,Unknown,* msvcp60                        780C0000  78120FFF  00061000
04/25/2007 08:20:10,spid60,Unknown,* MSDTCPRX                       05C90000  05D07FFF  00078000
04/25/2007 08:20:10,spid60,Unknown,* XOLEHLP                        05C80000  05C85FFF  00006000
04/25/2007 08:20:10,spid60,Unknown,* COMRES                         77010000  770D5FFF  000c6000
04/25/2007 08:20:10,spid60,Unknown,* schannel                       76750000  76776FFF  00027000
04/25/2007 08:20:10,spid60,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
04/25/2007 08:20:10,spid60,Unknown,* kerberos                       05BC0000  05C17FFF  00058000
04/25/2007 08:20:10,spid60,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
04/25/2007 08:20:10,spid60,Unknown,* msv1_0                         76C90000  76CB6FFF  00027000
04/25/2007 08:20:10,spid60,Unknown,* MSCOREE                        05950000  05994FFF  00045000
04/25/2007 08:20:10,spid60,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
04/25/2007 08:20:10,spid60,Unknown,* rsaenh                         04E90000  04EBEFFF  0002f000
04/25/2007 08:20:10,spid60,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
04/25/2007 08:20:10,spid60,Unknown,* SAMLIB                         5CCF0000  5CCFEFFF  0000f000
04/25/2007 08:20:10,spid60,Unknown,* ole32                          77670000  777A3FFF  00134000
04/25/2007 08:20:10,spid60,Unknown,* NTMARTA                        77E00000  77E21FFF  00022000
04/25/2007 08:20:10,spid60,Unknown,* SQLOS                          344D0000  344D4FFF  00005000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70                       4F610000  4F7A3FFF  00194000
04/25/2007 08:20:10,spid60,Unknown,* instapi                        48060000  48069FFF  0000a000
04/25/2007 08:20:10,spid60,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
04/25/2007 08:20:10,spid60,Unknown,* comctl32                       77420000  77522FFF  00103000
04/25/2007 08:20:10,spid60,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
04/25/2007 08:20:10,spid60,Unknown,* SHELL32                        7C8D0000  7D0D2FFF  00803000
04/25/2007 08:20:10,spid60,Unknown,* NETAPI32                       71C40000  71C97FFF  00058000
04/25/2007 08:20:10,spid60,Unknown,* opends60                       333E0000  333E6FFF  00007000
04/25/2007 08:20:10,spid60,Unknown,* USERENV                        76920000  769E3FFF  000c4000
04/25/2007 08:20:10,spid60,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
04/25/2007 08:20:10,spid60,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
04/25/2007 08:20:10,spid60,Unknown,* MSWSOCK                        71B20000  71B60FFF  00041000
04/25/2007 08:20:10,spid60,Unknown,* Secur32                        76F50000  76F62FFF  00013000
04/25/2007 08:20:10,spid60,Unknown,* MSASN1                         76190000  761A1FFF  00012000
04/25/2007 08:20:10,spid60,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
04/25/2007 08:20:10,spid60,Unknown,* GDI32                          77C00000  77C47FFF  00048000
04/25/2007 08:20:10,spid60,Unknown,* USER32                         77380000  77411FFF  00092000
04/25/2007 08:20:10,spid60,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
04/25/2007 08:20:10,spid60,Unknown,* ADVAPI32                       77F50000  77FEBFFF  0009c000
04/25/2007 08:20:10,spid60,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
04/25/2007 08:20:10,spid60,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
04/25/2007 08:20:10,spid60,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
04/25/2007 08:20:10,spid60,Unknown,* kernel32                       77E40000  77F41FFF  00102000
04/25/2007 08:20:10,spid60,Unknown,* ntdll                          7C800000  7C8BFFFF  000c0000
04/25/2007 08:20:10,spid60,Unknown,* sqlservr                       01000000  02BCEFFF  01bcf000
04/25/2007 08:20:10,spid60,Unknown,*  MODULE                          BASE      END       SIZE
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*   Access Violation occurred reading address 00000000
04/25/2007 08:20:10,spid60,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:10,spid60,Unknown,*   Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*   04/25/07 08:20:10 spid 60
04/25/2007 08:20:10,spid60,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:10,spid60,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0006.txt
04/25/2007 08:20:10,spid60,Unknown,Using 'dbghelp.dll' version '4.0.5'

View Replies !   View Related

---

How Can Readers Block Readers In SQL Server 2005
Hello All,
Greetings!!!

Due to certain constraints on my Table, I am not able to place unique Key constraint on it.
So I have take care about the uniqueness in my T-SQL code. I don't want to use the serializable transaction isolation level as it will result in frequent deadlocks.
I want some means by which one select will block other select.
Can this be done in SQL Server. I tried using TablockX along with holdlock as Table hint, but still the Selects does not block other select.
Will appreciate if you can resolve this issue

Thanks in Advance,
Mitesh Shah
MCTS- SQL Server 2005

View Replies !   View Related

---

SQL Query Queue
I have a requirement where once we create a new record in a table, we submit a query to fetch some data and save it in one of the columns of the newly created record. The main requirement is that the server where we fetch the data from can be down for sometime for regular maintenance and we do not want to loose the fetch query in that process. Is there a way we can implement this?
Thanks.

View Replies !   View Related

---

Table As Queue
I have a table that I want to act as a queue.

It has no indexes and no key. Just one column.

Basically I want a stored procedure that will pull / return the first record off the queue (table) and delete it. I'd rather not use MSMQ for this.

There will be about 10 users trying to do this at the same time and will be trying to pull of about 15 times every second.

How can I do this and ensure that no two requests pull off the same row?

Thanks,

Kevin

View Replies !   View Related

---

I/O Queue Length
Running transactional replication, dedicated server for distributor. While performance in terms of latency is excellent (usually 1 sec, almost never higher than 4) the disk queue length on the distributor is extremely high (over 6 usually). Is this typical? On any other server I would be very concerned, but cpu and memory usage are excellent and as said, latency is good. what is recommended config for distributor? others see high queue length?

View Replies !   View Related

---

Everything That Will Cause A Queue To Shut Down
 

I have a queue that, after running fine for several days will mysteriously turn off. It doesn't seem to be related to a poison message because I can restart the queue and processing resumes just fine. What are all the scenarios that would cause a queue to turn itself off, so I can 1) take preemptive action to prevent it from happening in the first place and 2) respond appropriately when it occurs.

 

Also, how to properly setup and verify that the BROKER_QUEUE_DISABLED is working properly. This is the SQL that I have so far, but is there a more direct way to raise the event other than writing an activated stored procedure that rolls back 5 times?

 

CREATE QUEUE [EventNotificationsQueue];

GO

CREATE SERVICE [EventNotificationsService]

ON QUEUE [EventNotificationsQueue]

([http://schemas.microsoft.com/SQL/Notifications/PostEventNotification]);

GO



CREATE EVENT NOTIFICATION [QueueDisabled]

ON QUEUE [MyQueue]

FOR BROKER_QUEUE_DISABLED

TO SERVICE 'EventNotificationsService', 'MyDatabase';

GO

View Replies !   View Related

---

Deadlock In Queue
Hello!

I am running a basic SSB queue setup (more or less the Hello World example)and running into the following error message:

Transaction (Process ID 120) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


At first, I thought it was because I had the Initiator and Target Services on the same Queue, but I get this error even when I separate the two Services onto two Queues.  This happens when I run more than one Target application receiving messages from the Target Queue.

Does anybody have any idea what could be happening here?  Am I not allowed to set up more than one receiver?

Thanks --

Robert

View Replies !   View Related

---

Queue Not Disabling
HI There

My activated proc is rolling back the transaction and putting the message abck on the queue infinately ?

Normally it disabled the queue after a few rollbacks, i can see in the sql log that it just keeps rolling back and re-activating thousands of times.

It only stops when i disable activation on the queue.

WHy is the queue not disabling ?

Thanx

View Replies !   View Related

---

Can't Enable Queue
Hi Folks,

I was testing my error handling and purposefully failed some messages. Automatic posion message detection kicked in and disabled my queue. I tried the following, one at a time to enable it again but it doesn't work:

ALTER QUEUE MigrationQueue WITH STATUS = ON;

ALTER QUEUE MigrationQueue WITH STATUS = ON, ACTIVATION (STATUS = ON);

I would have thought the first line would've worked but I get the following when trying to receive...

The service queue "MigrationQueue" is currently disabled.

Help.

View Replies !   View Related

---

Activating The Queue
Hi,

I have created Queue with the following syntax.  But it is not getting activated itself.  What I have to do to get it activated itself, and what could be the frequency by default.

CREATE QUEUE NewCustomerQueue
WITH ACTIVATION
 (PROCEDURE_NAME = prProcessNewCustomers,
 STATUS = ON,
 MAX_QUEUE_READERS = 1,
EXECUTE AS SELF)
GO

If I execute the prProcessNewCustomers procedure manually it is showing that the Queue has been activated.  What change I have to make in the syntax to get it activated itself.

Actually I have two scenarios in my requirement,

1. One Queue processing immediately when it receives data (Order Processing)

2. Another Queue, Process when the server is idle i.e., off-peak time  (for mailing)

What syntax I have to use for these.

Please help.

Thanks in advance

Babu

View Replies !   View Related

---

Transmission Queue ?
Hi There

I have sent messages and they are all sitting in the transmission queue with a blank status, why is service broker not trying to send them ? They are no errors in the sql log. BOL says this is blank when it has not tried to send the message ? Service broker is definately activated in the database.

How do i force sql server to send anything in the transmission que ?

I have no idea what is wrong or where to check ?

Thanx

View Replies !   View Related

---

Need A Fast Queue Using A Table
I am trying to implement a very fast queue using SQL Server.The queue table will contain tens of millions of records.The problem I have is the more records completed, the the slower itgets. I don't want to remove data from the queue because I use thesame table to store results. The queue handles concurrent requests.The status field will contain the following values:0 = Waiting1 = Started2 = FinishedAny help would be greatly appreciated.Here is a simplified script to demonstrate what has been done.CREATE TABLE [dbo].[Queue] ([ID] [int] IDENTITY (1, 1) NOT NULL ,[JobID] [int] NOT NULL ,[Status] [tinyint] NOT NULL) ON [PRIMARY]GOCREATE INDEX [Status] ON [dbo].[Queue]([Status]) ON [PRIMARY]GOCREATE PROCEDURE dbo.NextItem@JobID integer,@ID integer outputASSELECT TOP 1 @ID = [ID]FROM Queue WITH (READPAST, XLOCK)WHERE (Status = 0) AND (JobID = @JobID)RETURNGO

View Replies !   View Related

---

Processor Queue - Weird
Howdy,

This is a follow on from a previous post

http://www.dbforums.com/t984271.html


And now I have found something interesting :

(1) When I was monitoring the SystemProcessor Queue locally ( Via a term server login onto the box ) I would see a queue of 3-4. If I monitor the same parameter from a remote PC, I see a Processor Queue of 1 - why?
The box had 1 GB RAM ( SQL used 500 MB and had 250 MB free according to Task manager ).

(2)
I have another almost identical box that has same CPU but twice ammount of RAM ( 2 GB ) but has SystemProcessor Queue of almost
0 - why?

All other parameters for Disk, IO etc are fine.


Cheers,

SG

View Replies !   View Related

---

Message Queue Task
Ok, im making some progress. So what i have is a Message Queue Task which is bound to a message queue connection manager (which 'tests' ok). The Message Queue Task is set to recieve, variable from string message (declared a variable of type string) and to remove the message from the queue. The output of that task is piped into the data flow task.
The data flow task expands into a XML Source which is configured to get its input from the string i declared in the Message Queue Task and i point the schemas path to an appropriate schema. I then pipe the output of that into a SQL server destination which ive mapped all the columns from the XML message to a table (which the SQL server destination created for me).

It all looks good on paper, and builds properly with no errors etc. There is already a message in the appropriate private queue. When i go to debug it, it just sits on the Message Queue Task node (its yellow) and goes no further. No data is put into the DB. I have put a watcher on the link between the XML Source and the SQL server destination, and can see no data being piped through.
Even if i send another message, the execution of my package doesnt step passed the Message Queue Task. Its just sitting there waiting for something? what? I thought it would block until there was a message on that queue, and then process it if and when it arrives. But it doesnt seem to do that.

Any ideas??

I read on MSDN that you need integration services installed. I have checked and i do, and its running. Is theres something else i need to configure?

Help!

View Replies !   View Related

---

Snding Files In A Queue
 

hi everybody,
i am working on a SSIS package that creates Multiple file from a table depending on a particular field.
now the requirement from the target system is i have send the files directly to the particular serverrs.
for that i have to post my files in msmq and then use some other technology to achieve this.
if anybody has some ideas on this it will be very helpful for me.
thanks in advance
srikanth

View Replies !   View Related

---

Message Queue Task
Simple Question.
 
I have a requirement to read XML Messages from a Remote private MSMQ.
These messages are essentially Database records that will need cleaning up and insterting into a Local Database table.
 
Is this possible with SSIS?
Would Biztalk be a more suitable tool for this type of process?
 
If its possible, are there any resources taht can point me in the right direction?
 
Thanks for your help!
J.

View Replies !   View Related

---

Modifing Queue Filegroup.
 
Hi,
 
I created several queues on the default filegroup and I was wondering how can I change a queue filegroup?
 
Thanks,
Shai.

View Replies !   View Related

---

Receive All Messages On Queue
Hi i am trying to create a batch process then commit for all messages on the queue. The problem i am having is when i run my query (As below) I only receive the first message and the corresponding end dialog for the message although i have 2000 records sitting in the queue. It is my understanding that receive without any criteria i.e top(1) or where clause should select everything of the queue. I tried receive top(100) expecting 100 records but still only got 2 back.

any help appreciated.

 

WAITFOR(RECEIVE

queuing_order,

conversation_handle,

message_type_name,

message_body

FROM [RMIS_COMMS_Queue]

INTO @tableMessages), TIMEOUT 2000;

 

 

View Replies !   View Related

---

Unable To Turn On SSB Queue
Hi all:

 

I've been stress-testing SSQ queue by pumping a lot of data to it. For the most part, the queue is cleared out fairly quickly using the activation stored procedure. However, for a second time now, I encountered a strange problem. For some reason, one message got stucked in the queue and would not dequeue. The status of the queue is turned OFF somehow. So I ran:

 

ALTER QUEUE [dbo].[TestQueue] WITH STATUS = ON;

 

to turn the queue status back on, but it would not turn ON. The last time I had this problem, I ended up dropping and recreating everything.

 

Has anyone experienced this strange behavior? Please help.

 

Thanks,

 

TDev

View Replies !   View Related

---

Queue DELETE Time
Hello!

In running some performance tests on a Queue using a message size of ~5KB, we found that we can process (SEND and RECEIVE) on the order of 600 - 800 messages / second.  However, we have found that INSERTs of new messages to the Queue appear to take great precedence over DELETEs of received messages from the queue.  In particular, we found that during heavy use the total size of the Queue (as determined using the sp_spaceused procedure) equals about the number of total messages processed, not the number of messages on the queue.

When we stop sending messages, the overall size of the Queue table appears to decrease slowly, so there is a background process that is obviously doing some work there to clean up the received messages from the Queue.  What I would like to know is if we can affect that background process in any way so that the messages are cleared out more quickly.  The performance has been determined to suffer appreciably once the Queue size grows to greater than about 3GB in size.  We also notice timeouts on the RECEIVE statements when the Queue size is that large.

Thanks for any help --

Robert

View Replies !   View Related

---

Backup The Transmission Queue
My normal scenario is tills sending live slaes to head office via service Broker queue.  Sales are sent as soon as sale is made(normally tills on adsl lines), a loss of a Link to head office will still allow a sale to be made with  the sale sitting in the transmission queue on the till but has not been commited at HO to adjust stock etc, until the link is back up. My worry is link goes down with several sales siting in the queue and then hardware failure. Is their a mechanism to backup the Transmission queue in the case of no link?

If you could back up the transmission queue at a till could i then take those messages and copy them into head offices queue for processing, this is in the case of my link to the till was down for a whole day but needed the daily sales from the shop,could i get the back up at end of the day and apply the messages at head office?

Any infomation on what would be the best way to recover from this event would be gratefully accepted.

 

any examples on a heartbeat to check the link status that is of very low cost between HO and tills bearing in mind HO needs to maintain status for large number of tills.

View Replies !   View Related

---

Pauzing SQL Queue Processing
Hello,

    I'm currently looking for a way to decently pauze the processing of messages by activation procedures.  When I pauze the processing I want to be sure that the running activation procedures terminated.
    I thought I could do this using ALTER QUEUE WITH ACTIVATION (STATUS = OFF) and sys.dm_broker_activated_tasks.
    This is what I've tested: I set up one queue with an activation procedure attached to it that receives one message, then waits for one minute, then writes that message into a table. The queues max queue readers is set to 2. Now, I put 5 messages in the queue, 2 procs pop up in sys.dm_broker_activated_tasks. I run the alter queue statement shown above and check sys.dm_broker_activated_tasks again. It is empty so allegedly there are no tasks running. I check the table in which the messages are written by the activation procs and after some time I can see the results of both activation procedures which were according to sys.dm_broker_activated_tasks not running (but of course they were). The rest of the process works as expected, the procs reactivate upon reenabling the activation status and all is well.
    Is there another way of checking the running activation procedures that checking sys.dm_broker_activated_tasks?
    Is this intended behaviour or just a bug?

View Replies !   View Related

---

Monitoring Queue Status
Hi,

I'm new to the service broker service. All I want to do is to monitor the queue status.  If the queue is disabled, send me an email alert.

Can you let me know what's the best way to accomplish it?

Thanks,

Jia

View Replies !   View Related

---

Multiple Services On Same Queue Or Not ?
Hi There

I am guessing defining multiple services on the same queue is basically for providing different services to outside sources while using 1 queue, obviously as long as the contracts and activated sp logic applies to all services defined on that queue.

I am defining a queue per service, is this right or wrong or irrelevant ? It just works better for me in terms of manageability.

I just want to make sure there is no "best practice" reason for doing either or ? Is it just a matter of preference?

Any comments?

Thanx

View Replies !   View Related

---

Queue Activation Context
Is there any way to identify the context by which a stored proc has been activated. i.e.

I want to use the same sp to end conversations on receipt of the end mesage from the target.

However I don't know how to find out which queue activated the SP.

View Replies !   View Related

---

Dynamic Queue Receive Sql ?
Hi There

My activation sp must be able to read of various queues.

I load a variable with the queue name that activated the sp btu i cannot get the syntax working to receive or get a conversation group of a queue name that is a variable.

I have tried:

WAITFOR

(

RECEIVE message_body, conversation_handle, message_type_name, message_sequence_number, conversation_group_id FROM @callingQueue INTO @msgTable WHERE conversation_group_id = @conversationGroup

), TIMEOUT 2000;

But i get this error:

Incorrect syntax near '@callingQueue'.

Looks like you cannot use a variable.

So i tried the following:

SELECT @SQL = N' WAITFOR

(

RECEIVE message_body, conversation_handle, message_type_name, message_sequence_number, conversation_group_id FROM @callingQueue INTO @msgTable WHERE conversation_group_id = @conversationGroup

), TIMEOUT 2000'

EXEC sp_executesql @SQL, N'@msgTable table output'

But i get the same error.

How do i receive of a queue using a vriable holding the queue name ?

Thanx

View Replies !   View Related

---

Identify Queue That Activated Sp ?
Hi there

I have multiple queues with the same activated stored procedure (for various reasons we are trying this scenario).

My biggest obsticle is i cannot figure out a way to determine with the activated sp which queue caused it to activate.

Basically i need to make the sp dynamic, so that no matter which queue activated the sp the sp can determine the queue name and use that dynamically to do the receive command from the right queue.

I am sure it is possible since sys.dm_broker_activated_tasks shows how many sp's are activated by each queue, however the sp name is the same for all queues so that does not help me.

How do i determine within an activated sp which queue caused it to activate?

Thanx

 

View Replies !   View Related

---

Unpredictable Queue Order - PLEASE HELP !
Hi There

I am having alot of trouble with the order in which messages are being delivered, here is my scenario.

I have a transaction action table :

message 1 - xml schema A.

message 2 - xml schema A.

message 3 - xml schema B.

message 4 - xml schema D.

I have the following SP:

BEGIN TRAN

BEGIN DIALOG CONVERSATION

SEND ON CONVERSATION message 1

 

BEGIN DIALOG CONVERSATION

SEND ON CONVERSATION message 2

COMMIT

AT the target i get message 1 in the queue first them message 2. But then i try this.

BEGIN TRAN

BEGIN DIALOG CONVERSATION

SEND ON CONVERSATION message 3

 

BEGIN DIALOG CONVERSATION

SEND ON CONVERSATION message 4

COMMIT

At the target i get message 4 first it has the lower queuing_order on the queue, somehow it got ont he queue first.

I have tried turning validation off on the mssage types as i thought it may have something to do with the xml, but same problem.

I then tried to do a commit after each message like this:

BEGIN TRAN

BEGIN TRAN

BEGIN DIALOG CONVERSATION

SEND ON CONVERSATION message 1

COMMIT

BEGIN TRAN

BEGIN DIALOG CONVERSATION

SEND ON CONVERSATION message 2

COMMIT

COMMIT

But message 4 still gets on the queue first . WTF is going on ?

The only way i can get this to work is like this.

BEGIN TRAN

BEGIN DIALOG CONVERSATION

SEND ON CONVERSATION message 1

 WAITFOR DELAY '00:00:01'

BEGIN DIALOG CONVERSATION

SEND ON CONVERSATION message 2

COMMIT

Why does this work ? and why do i not have this issue with message 1 and 2? If it has soemthing to do with the xml what is it?

Please help.

View Replies !   View Related

---

RECEIVING From QUEUE By ConversationHandle
Is it possible to receive from a queue by a conversation handle?  In the documentation there is an example that show you how to do it.  Yet, if you "read" the whole document it says that the conversation handle can not be an expression.

The WHERE clause of the RECEIVE statement may only contain search conditions that use conversation_handle or conversation_group_id. The search condition may not contain any of the other columns in the queue. The conversation_handle or conversation_group_id may not be an expression.

Here is what I'm trying to do:

;RECEIVE TOP(1) @MsgBody = CAST(message_body as XML)

FROM ProcessingLetters

WHERE conversation_handle = @Conversation_Handle

It doesn't seem to matter if I use RECEIVE or SELECT.  It will return nothing.

I've even tried this:

where cast(Conversation_Handle as varchar(100)) = cast(@Conversation_Handle as varchar(100))

Why am I doing this?  I've put something into the queue to let me know that something is processing. When it is done I want to pull it out and end the conversation.

So is the WHERE conversation_handle = @Conversation_Handle supposed to work?

Thanks.

View Replies !   View Related

---

Purging The Transmission Queue
My transmission queue has lots of messages that will never, ever be delivered because the transmission_status = "The session keys for this conversation could not be created or accessed. The database master key is required for this operation."

How can I purge the transmission queue to get rid of this junk?

View Replies !   View Related

---

Target Queue Disabled
Hi,

I receive messages in my target queue but target queue continously become disabled even aften I enable and receive message it still says target queue is disabled?

 

Please Guide

View Replies !   View Related

---

Transmission Queue Problem
" noWrap width="1%" bgColor=#b71c0c>1. Yosi   29 Temmuz 12:19     seçenekleri göster Gönderen: "Yosi" <yus...@bizitek.com> - Bu yazarın yazdığı mesajları bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | Ä°let | Yazdır | Sadece Mesaj | Aslını göster | Kaldır | Kötüye Kullanımı Bildir
I'm trying the service broker features of SQL Server 2005. I created a

View Replies !   View Related

---

How To Clean All Messages Of A Queue ?
    How to clean all messages of a queue ?

View Replies !   View Related

---

How To Delay Queue Processing?
I am looking for some suggestions on how to implement a delay in processing

View Replies !   View Related

---

Is There A Way To 'peek' The Items In A Queue?
... or some other way to prolong their presence on the queue.

The scenario I'm dealing with requires me to receive a batch of messages and fire them off (as a batch) to a legacy Unix application via TCP. What I need to do is keep those messages on the queue (or at least somewhere else in the database) until I know for certain that the legacy app has received them.

Comments?

 

View Replies !   View Related

---

Performance Of A Queue Vs Table
I know we are not allowed to benchmark SQL Server but..... It would be nice to have material to present which demonstrates the performance gains using a queue compared to  insert/delete in a SQL table.

 

Logically it seems faster to use a queue due to the conversation grouping locking and the service broker itself.  But there seems to be some overhead involved just to manage these queues that the service broker has to perform. 

I am sure we are not unique with the choice to figure out if we will get a boost in performance using SQL a queue between services rather than a table to queue data.  What is available to help understand the performance gains of using a queue?

View Replies !   View Related

---

SQL Performance - Disk Queue.
 

I am running SQL server 2000 SP4 on a server with 2 Dual core 4G processors with data attached via a SAN>
 
I have a 70G database with 10 users that is giving attrocious performance. I have just tried to run a count(*) accross a couple of tables and am still waiting for the results 15 mins later. When I look at the disk queue it is around 50/60. I thought the target for this was around 2. I am sure that the hardware that we have in place is capable of running this db. However I`m not sure how to fully analyse what is going wrong here.
 
Any tips would be greatfully received.
 
Si

View Replies !   View Related

---

TSQL Statements For Job Queue
 

I am doing backup job using windows 2003 backup. I hv several scheduled backup job. And sometimes, when the first backup job not yet finish backing up, the second backup job will automatic starts at the set time resulting 2 backup jobs at 1 time. I need to know whether  in SQL2000/2005, we can set the tsql command to do the job queue for the windows 2003 backup job, meaning if the 1st backup job is still ongoing, the 2nd backup job will hv to wait even though the set time for the job was already expired. When the 1st job done, then only the 2nd job started.
 
Appreciate the feedback..
 
tq

View Replies !   View Related

---