cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

355
Views
0
Helpful
1
Replies
Highlighted
Cisco Employee

Query interval on db

My customer would like to use a SQL DTS to collect information from ICM HDS db and they would
like to know if they use less than 10 minutes of interval and if it could cause any impact
on ICM processes and performance.

The tables queried are t_Route_Call_Detail, t_Dialed_Number, t_Route and t_Service.






Everyone's tags (3)
1 REPLY 1
Advocate

Query interval on db

Hi,

first of all, forget the tables starting t_. They are real tables aka leaf nodes and you don't use them, ICM does.

This means you don't use them at all, not within a ten minutes interval, but not at all.

There are views, in this case "Route_Call_Detail", "Dialed_Number", "Route" and "Service". You can use them in whatever interval you pick.

G.

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here