Storage of a large number of sensor data records

Question

I need to create a database that will save the sensor data that will be requested to generate reports later (display a graph and AVG / MAX / MIN values ​​for a given time interval).

Data points are as follows:

CREATE TABLE [dbo].[Table_1](
    [time] [datetime] NOT NULL,
    [sensor] [int] NOT NULL,
    [value] [decimal](18, 0) NULL
)

Data can be added at intervals ranging from seconds to minutes (depending on the sensor).

Should I worry that my database becomes too large when several years of data accumulate (the database will work in the editorial team of MS SQL Server 2008)?

Answer 1

, . 1 - 0,5 , . , , , .

, , . - , , .

, . , . , , "Process Historian", " " "SCADA".

Answer 2

, OSISoft PI Historian, , . PI , , , , . , PI , , .

, , OSISoft. , , .

Answer 3

, , , ..

, , 150 (~ 1 x 1 x 5 ) ~ 6 ( ). 16 , Workgroup.

Answer 4

, , , Archive_Table , 6 ( ).

, . , , , .