Sterling SI/GIS: how to find a “quiet period”

If you are working for and international company which operates 24×7, you might need to find a quiet period of time when SI/GIS server is not processing a lot of documents (for example, for running heavy BackupService or do any kind of maintenance and so on). I use the following SQL queries to gather some usage stats:

Per day hours:

select count(*) as CNT, TO_CHAR(start_time, 'HH24') as DT from WF_INST_S
--where TO_CHAR(start_time, 'yyyy') = '2014'
group by TO_CHAR(start_time, 'HH24')
order by TO_CHAR(start_time, 'HH24')

Per week days:

select count(*) as CNT, TO_CHAR(start_time, 'D') as WeekDay from WF_INST_S
--where TO_CHAR(start_time, 'yyyy') = '2014'
group by TO_CHAR(start_time, 'D')
order by TO_CHAR(start_time, 'D')

Gennady Kim

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s