Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prabhu
Starting Member
1 Post |
 Posted - 2008-06-02 : 08:15:19
|
| Hi friends,My existing project does db operation with help of MSMQ.Consider following steps ;1.Main Application writes binary dataa to MSMQ2.Sub application reads data from MSMQ and update DB.I have tried this with service broker 1.Main applicate puts data into Database Queue through Service broker2.Service broker does DB operation.But Comparatively the performance in service broker is very very slow.I have used Binary data which passes through Queue and i have used CLR enabled stored procedure to use this bianry data.Can any one explain wats wrong in this.Hi friends,My existing project does db operation with help of MSMQ.Consider following steps ;1.Main Application writes binary dataa to MSMQ2.Sub application reads data from MSMQ and update DB.I have tried this with service broker 1.Main applicate puts data into Database Queue through Service broker2.Service broker does DB operation.But Comparatively the performance in service broker is very very slow.I have used Binary data which passes through Queue and i have used CLR enabled stored procedure to use this bianry data.Can any one explain wats wrong in this.Hi friends,My existing project does db operation with help of MSMQ.Consider following steps ;1.Main Application writes binary dataa to MSMQ2.Sub application reads data from MSMQ and update DB.I have tried this with service broker 1.Main applicate puts data into Database Queue through Service broker2.Service broker does DB operation.But Comparatively the performance in service broker is very very slow.I have used Binary data which passes through Queue and i have used CLR enabled stored procedure to use this bianry data.Can any one explain wats wrong in this. |
|
|
Geosql
Starting Member
1 Post |
Posted - 2008-08-06 : 03:15:06
|
| very good post, I just hope there have some tool, such as sql server performance monitor, it can test the performance details. |
 |
|
|
remusrusanu
Starting Member
2 Posts |
Posted - 2008-09-02 : 12:15:24
|
| For end-to-end reliable transacted operations Service Broker is orders of magnituted faster than MSMQ. For a starter check http://rusanu.com/2007/04/03/orlando-slides-and-code/ to see how can transmit and receive ~2500 msgs 1K payload per second between two comodity machines. For higher end systems I've managed deployments that achieved half million messages per minute.http://rusanu.com |
|
|
|
|
|
|
Service broker vs MSMQ performance