Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

Join our "Ask Me About" community webinar on May 20th at 9 AM CET and 5 PM CET to explore cybersecurity and monitoring for Data Center and edge IT. Learn about market trends, cutting-edge technologies, and best practices from industry experts.
Register and secure your Critical IT infrastructure

Online Defragmenter Exclusions

Geo SCADA Knowledge Base

Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • Knowledge Center
  • Geo SCADA Knowledge Base
  • Online Defragmenter Exclusions
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close
Top Labels
Top Labels
  • Alphabetical
  • database 32
  • Web Server and Client 31
  • WebX 19
  • Request Form 18
  • Lists, Events & Alarms 16
  • ViewX 15
  • Application Programming 12
  • Setup 12
  • Telemetry 8
  • Events & Alarms 7
  • Lists 7
  • Mimic Graphics 7
  • Downloads 6
  • Support 5
  • IoT 5
  • SCADA 5
  • Geo SCADA Expert 5
  • Drivers and Communications 4
  • Security 4
  • DNP 3 3
  • IEC 61131-3 Logic 3
  • Trends and Historian 2
  • Virtual ViewX 2
  • Geo Scada 1
  • ClearSCADA 1
  • Templates and Instances 1
  • Releases 1
  • Maps and GIS 1
  • Mobile 1
  • Architectures 1
  • Tools & Resources 1
  • Privacy Policy 1
  • OPC-UA 1
  • Previous
  • 1 of 4
  • Next
Latest Blog Posts
  • OPC UA - Driver and Server
  • Requirements for Generating a Valid OPC UA Server Certificate
  • Load Events Using LoadRecord and LoadRecords
  • Geo SCADA Embedded Component Licenses
  • Geo SCADA 2023 Known Issues
Related Products
product field
Schneider Electric
EcoStruxure™ Geo SCADA Expert

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Anonymous user
Not applicable
‎2021-06-09 07:10 PM
0 Likes
0
857
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content

Link copied. Please paste this link to share this article on your social media post.

‎2021-06-09 07:10 PM

Online Defragmenter Exclusions

Originally published on Geo SCADA Knowledge Base by Anonymous user | June 10, 2021 04:10 AM

📖 Home  Back  

 

It is not recommended that Geo SCADA runs on systems which do not have the required exclusions configured. Doing so risks Geo SCADA database corruption and ongoing performance problems


Many defragmentation products claim to "transparently" defragment files without interfering with a process's access to files. In some cases however it is possible for these programs to still cause performance problems with the Geo SCADA database, and possibly leading to database corruption.

Simply put, exclusions similar to as documented in Anti-virus Scan Exclusions should be set for defragmentation software, however as the purpose of defragmentation software on Geo SCADA machines is typically to improve the performance of Geo SCADA then exclusions do not necessarily make sense. The rest of this article is designed to help diagnose possible issues.


Memory Resident Streams

The memory resident Streams, such as the Config and Data streams, are written to disk once a minute if changed. The data is saved to a temporary file, the existing file deleted and then the temporary file is renamed to the correct name. As this happens often then the chances of file fragmentation on disk are minimal and fairly transient, and as these files are only read during the database start-up the effects of fragmentation are also minimal. If you watch a directory containing the Config and Data streams you may very briefly see files named similar to 'TempDbConfig0001' or 'TempDbData0001'. These should disappear almost immediately. If these files exist for more than a minute then this is signs of something interfering with the file write. Any Temp files older than a hour can be deleted safely, any files more recently should be kept in case of a database restart and the database being corrupt.

Where possible any file storage of the memory resident streams should just be excluded from defragmentation as they are not necessary and causes more problems than they solve.\


Disk Resident Streams

Disk resident Streams such as historic data values will greatly benefit from defragmentation. These streams do not create a fresh file each minute and instead either creates new files or appends data to the existing files as necessarily which will cause heavy fragmentation long term. Refer to the Streams article for how the files are arranged for each stream.

For example, when a new historic value is received from the field it is first stored in memory. Once a minute Geo SCADA will flush the historic in memory to disk for a maximum period of 1 second (by default, can be changed). Any remaining data in memory will be flushed the following minute. When this flush happens to ensure all the data can be flushed successfully speed is important.

It is recommended that any defragmentation that does 'real time' defragmentation, such as Diskeeper, has the real-time function disabled as this has been shown to impact the flush speed of the data to disk. The file flush can be observed by enabling HISREC and JNLREC in the DB logging and observing each file written to disk, note that the event journal is slightly less impacted due to the way those files are structured.

Scheduled defragmentation can still occur, and suitable planning performed to perform the action at a time that does not conflict with other operations, such as backups and reporting.


Defragmentation Software

Each defragmentation software works in different ways, and between different versions of the same product, as such we can't provide definitive information. The above information is provided to help you understand how the software works and the things you need to consider. Defragmentation software should not be installed without prior configuration, monitoring and testing within a suitable environment.

Also see Anti-virus Scan Exclusions.

Go: Home Back

Author

Biography

Anonymous user

Link copied. Please paste this link to share this article on your social media post.

  • Back to Blog
  • Newer Article
  • Older Article
To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of