When your database activity is low, we recommend that you run a database consistency check if you have a large database. Although it takes some time, it is important to determine that your SQL database is functioning well. For more information, see your Microsoft SQL guide.
Important! Be sure to monitor the log size periodically. If a log is full, the database cannot function. Although the default setting is “truncate log on checkpoint,” you should increase the log size to 50% of the database if you expect to keep a large number of records.
|
Copyright © 2016
|
|