Difference between revisions of "Details about database connection"

no edit summary
m (Grammar)
Line 6: Line 6:
! ID !! Name !! Description
! ID !! Name !! Description
|-
|-
| 1 || General purpose background writer || A single persistent dedicated connection
| 1 || Bootstrap / general purpose connection || A single persistent dedicated connection<br>
Used as an initial connection to retrieve other settings from DB. Also used minimally during server run-time.
|-
|-
| 2 || idata writer || A single persistent dedicated connection<br>
| 2 || idata writer || A single persistent dedicated connection<br>
Line 39: Line 40:
| 3 || Server.DBWriter.Requests.RawData
| 3 || Server.DBWriter.Requests.RawData
|-
|-
| 1, 4, 5, 6 || Server.DBWriter.Requests.Other
| 5 || Server.DBWriter.Requests.Other
|}
|}
You can then use DCI delta calculation to get the number of per second or per minute queue insertions.
You can then use DCI delta calculation to get the number of per second or per minute queue insertions.
Line 52: Line 53:
| 3 || Server.AverageDBWriterQueueSize.RawData
| 3 || Server.AverageDBWriterQueueSize.RawData
|-
|-
| 1, 4, 5, 6 || Server.AverageDBWriterQueueSize.Other
| 5 || Server.AverageDBWriterQueueSize.Other
|}
|}
184

edits