|
|
|
It is currently Sat May 25, 2013 11:41 am
|
View unanswered posts | View active topics | View unsolved topics
  |
Page 1 of 1
|
[ 2 posts ] |
|
| Author |
Message |
|
Jcam
Corporal
Joined: Fri Feb 08, 2008 1:21 pm
Posts: 43
Location: North Carolina
|
 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 |
 |
 |
|
Travis.Cox
Moderator
Joined: Sun Apr 02, 2006 2:46 pm
Posts: 1975
Location: Sacramento, CA
|
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 |
 |
|
|
|
|
Page 1 of 1
|
[ 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
|
|
