Offermanager causing excessive SQL traffic

Our SMS 2.0 SP5 server is causing an excessive amount of network traffic to
our SQL server. When I watch the traffic with Network Monitor I can see that
it is constantly changing the _CPY_OfferManagerTemp_### tables in SQL. I need
to stop the SMS_OFFER_MANAGER & SMS_OFFER_STATUS_SUMMARIZER to stop the
traffic, otherwise the SQL server is to busy.

I think my advertisements have become corrupted in some kind of way. Any
suggestions on what to do?
.

Relevant Pages

  • Re: Enter Todays Date in SSMS Open Table Grid View
    ... If you don't want to consult your watch, you will have to write an INSERT ... Is there an SSMS ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: VB versus VB.NET timings!!
    ... >data held in a large number of Excel spreadsheets into SQL Server, ... >SQL Server table with the same number of columns. ... Make sure you have Option Explicit On and Option Strict set. ... Watch out for legacy VB methods, classes, etc., and use .NET versions ...
    (microsoft.public.dotnet.languages.vb)
  • Re: AWE Memory Question
    ... Minimum should be time to populate all of your cache from scratch. ... I support the Professional Association for SQL Server ... >> severe memory pressure, this won't help much. ... >> Watch CPU % of course. ...
    (microsoft.public.sqlserver.setup)
  • FileWatcher Multiple Unrelated Directories
    ... specified size a SQL connection is made to determine if any action ... The problem is that this puts an extremely high load ... rather than having to hit the SQL server so often. ... watch each directory individually? ...
    (microsoft.public.dotnet.framework)
  • Re: VS 2003 + opening a connection to SQL SERVER 2000 database
    ... I would also verify with a watch that the value being read from the ... Greg ... the server that sql server 2000 is running on is Windows ...
    (microsoft.public.dotnet.framework.aspnet)