It is currently Tue Sep 02, 2014 10:56 pm




Post new topic Reply to topic  [ 2 posts ] 
 Datasource fault 
Author Message
Corporal
Corporal

Joined: Fri Feb 08, 2008 1:21 pm
Posts: 43
Location: North Carolina
Post Datasource fault
When too many clients log on we get a datasource fault. What can we do to fix this?

This is what the datasource is currently running, a lot of times the Throughput is over 100 queries/sec

Total Queries 3,012,988
Query Duration
(Min / Avg / Max) 0.00 / 0.00 / 3.39
Throughput 93.22 queries/sec


Mon Feb 07, 2011 10:54 am
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 2:46 pm
Posts: 1982
Location: Sacramento, CA
Post Re: Datasource fault
It looks like your connection is getting overwhelmed. Two things you can do:

1) Try to consolidate queries

2) Increase the Max Active property for the DB connection in Ignition Gateway Configuration. It is an advanced setting on the connection edit screen.

The second one will increase the number of active connections to the database at a time. This assumes your DB allows that number of connections. The default setting is 8 but you can increase it to 20 or so.

_________________
Travis Cox
Inductive Automation
Technical Support Rep.


Mon Feb 07, 2011 1:40 pm
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: