/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.SsisPerformanceCounters ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ]

This table records the value of various [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|SSIS performance counters]] at [[sprockit.Property#ProcessManagerPollInterval|intervals]].

The table is populated with the results of querying SSISDB's [[https://docs.microsoft.com/en-us/sql/integration-services/functions-dm-execution-performance-counters|catalog.dm_execution_performance_counters()]] function, run once in each iteration of Sprockit's [[..:introduction#process manager]] for all [[.:sprockit.execution|Sprockit-executed]] SSIS packages in progress at that time. Records in the table that are older (in days) than Sprockit's ''[[sprockit.Property#SsisPerfmonRetentionPeriod]]'' property are automatically deleted.


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^Column type  ^Description   ^Notes   ^
|PK  |__**ActivityDateTime**__  |DATETIME  |The date and time at which the data in this row was retrieved.  |  |
|PK, [[sprockit.Execution|RL1]]  |__**ExecutionId**__  |INT  |Identifies the Sprockit [[.:sprockit.execution|execution]] to which the record relates.  |If required, the SSISDB package execution ID can be [[.:sprockit.execution#parsing_execution_configurations|extracted from Sprockit's execution configuration]].  |
|  |**BuffersInUse**  |BIGINT  |Buffers in use [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**BuffersSpooled**  |BIGINT  |Buffers spooled [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |A non-zero value indicates that the SSIS server flushed working buffers to disk during this package run, indicating memory pressure. This is usually associated with noticeable -- possibly severe -- performance deterioration.  |
|  |**BufferMemory**  |BIGINT  |Buffers memory [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**PrivateBuffersInUse**  |BIGINT  |Private buffers in use [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**PrivateBufferMemory**  |BIGINT  |Private buffer memory [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**FlatBuffersInUse**  |BIGINT  |Flat buffers in use [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**FlatBufferMemory**  |BIGINT  |Flat buffer memory [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**RowsRead**  |BIGINT  |Rows read [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**RowsWritten**  |BIGINT  |Rows written [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**BlobBytesRead**  |BIGINT  |BLOB bytes read [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**BlobBytesWritten**  |BIGINT  |BLOB bytes written [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |
|  |**BlobFilesInUse**  |BIGINT  |BLOB files in use [[https://docs.microsoft.com/en-us/sql/integration-services/performance/performance-counters|performance counter]]  |  |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
Relationships with integrity enforced by a foreign key constraint have identifiers
prefixed with //FK//; others are prefixed //RL//.

[[sprockit:v1.5:Sprockit tables:Sprockit tables|Click here to view the data model diagram.]]
==== References to other tables ====

^  ^Attributes \\ (in this table)  ^Referenced table  ^Referenced attributes \\  (in referenced table)   ^
|RL1  |ExecutionId  |[[sprockit.Execution]]  |ExecutionId  |

==== References to this table from others ====

^Relationship  ^Attributes \\ (in referencing table)  ^Referenced attributes \\ (in this table)   ^
|(None).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */