I am getting error when I start notificaton.
Unable to start notification. :: The open operation did not complete within the allotted timeout of 00:01:00. The time allotted to this operation may have been a portion of a longer timeout.
The socket transfer timed out after 00:00:59.9843999. You have exceeded the timeout set on your binding. The time allotted to this operation may have been a portion of a longer timeout.
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
The status of the notificaton says "Ready but not running. Check that the service is running this database.". It take ages to show the status in Overview panel for each notification.
How many notification can be configred in one database? Is there any limit? I currently have around 9000 notifications.
Also I am attaching the screenshot of event viewer. There are lots of similar "Warnings" in the event viewer.
Can you please suggest a way forward to solve this issue?