DB "Poller" Table

bwicks

After several attempts to delete 10k + interfaces through the web interface I decided to manually delete the interfaces from the DB.  Note:  when selecting 200 interfaces to delete through the web page it would just timeout and only delete about 30 or so.  After manually deleting I noticed that the maintenance plan did not delete entries from the “poller” table.  I found the following sp_ which only deletes when joined with the “deleted interface” table.

      DELETE FROM Pollers

      WHERE (NetObject LIKE 'I%')

        AND (SUBSTRING(NetObject, 3, 10) IN (SELECT InterfaceId FROM DeletedInterfaces))

When changing the query to join the interfaces table I am finding my manually deleted interfaces

select count(*) fROM Pollers

      WHERE (NetObject LIKE 'I%')

        AND (SUBSTRING(NetObject, 3, 10) not IN (SELECT InterfaceId FROM interfaces))

Questions:         

1.       Should I be concerned about the stale “poller” table data?

2.       Is there any negative performance impact to the poller when having “stale” entries

3.       What other tables should I look at deleting stale data when manually deleting interfaces

Thanks

jan1

bwicks,

When an interface is deleted from Orion, its ID is inserted into DeletedInterfaces table, so the nightly maintenance can take care of the rest of the data related to this interface (Pollers and historical data in InterfaceTraffic and InterfaceErrors).
I would not recommend keeping the stale data, because of the possible performance impact.
If you still have the IDs of your manually deleted interfaces in the Pollers table, you can run this statement to get those IDs and insert them into DeletedInterfaces table, then you can let the nightly maintenance handle the rest.

INSERT INTO DeletedInterfaces
SELECT DISTINCT SUBSTRING(NetObject, 3, 10) from Pollers
WHERE (NetObject like 'I%') AND
(SUBSTRING(NetObject, 3, 10) NOT IN (SELECT InterfaceId FROM Interfaces)) AND
(SUBSTRING(NetObject, 3, 10) NOT IN (SELECT InterfaceId FROM DeletedInterfaces))

Let me know if you have any questions.

Jan