We are seeing poor server performance when running simple data driven
subscriptions. The subscription references a simple view that provides
parameter data. When we run the subscription, we see disk usage and memeory
usage increase dramatically on the server and the server becomes very slow
(almost to the point where other activity on the server stops).
Has anyone seen this behavior and does anyone have any recommendations?We are experiencing the same performance issue, our server gets 100% busy
when we run subscriptions, also, some subscriptions never get completed.sql
Friday, March 30, 2012
Poor Server Performance When Running Data Driven Subscriptions
Labels:
database,
driven,
microsoft,
mysql,
oracle,
performance,
poor,
provides,
references,
running,
server,
sql,
subscription,
subscriptions,
view
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment