Does anyone have any experience using query notifications with a high volume of data changes and a large number of subscribers? Anyone know if it scales well?
What's happened is that a outsource company's developer decided (after consultation with his architect) to use query notifications for a project involving a data feed. Unfortunately this is the first I've heard of any of this, so I have very little details.
The developer has 'stress' tested at the volume that's expected for the pilot project, that is 5 users and 5 inserts/sec with the notification on (I assume a subset of) the inserts. He says the desktop he was testing on can handle that load.
If the pilot is a success, we're expecting the usage to increase to around 200 users and 400-500 inserts/sec. The developer hasn't tested at those levels. He said he would, but I doubt he's going to get to it before the pilot goes live (monday)
Should I be panicking at this point?
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass