Restituisci
-
Titolo
Is it supported to move the Foglight repository (FMS) database from SQL Server Enterprise Edition to SQL Server Standard Edition? -
Descrizione
Is it supported to move the Foglight repository FMS database from SQL Server Enterprise Edition to SQL Server Standard Edition?
The SQL Server Enterprise database is using compression, how it is impacting Foglight if compression will be removed?
-
Risoluzione
Foglight will enable compression on observation tables if the database supports it. Foglight is checking whether it is the Enterprise Edition and will only attempt to use table compression if that is the case.Using a Standard Edition of the database should be fine and the server just will not use table compression. The main impact will be that the tables are larger and there could be more I/O when inserting data and performing queries.In terms of migrating from an Enterprise Edition to an Standard Edition: Please contact your SQL Server DBA to discuss the way to move from one version to another. It might be necessary to perform some sort of export and re - import. -
Informazioni aggiuntive
The SQL statement to remove compression on a table is: ALTER TABLE yourTableName REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = NONE) The same would have to be repeated for compressed indexes. Given the number of tables and indexes involved, it may not be feasible unless the DBA can write a script to automate the commands for each table.