On May 3, 8:07 pm, tonylch...@gmail.com wrote:
> Hi,
>
> I am using notification services on my accounts table to notify
> upwards of 8-10 subscribers of any changes, and what seems to happen
> is the following:
>
> - approximately 90% of the time everytime runs great, no problems,
> speedy results from the db (sql server 2005)
> - the remaining 10% will see timeouts on queries touching the accounts
> table
>
> My deployment is as generic as possible, using all default values. As
> I am historically a sysadmin temporarily playing the role of a DBA, I
> was hoping someone here could provide an answer or an URL which
> discusses this type of problems in more depth. If I did not supply
> enough information, please let me know what info to get and I will do
> so to the best of my ability.
>
> TIA!