Search Results

General This part is used to load all counters in MXSuite. The sheet in the Excel file is called “Counters”. Details fields To fill the Excel file correctly, make sure that all fields are filled correctly. Below are the fields listed. Field MAX Char...

General All maintenance tasks are linked to a maintenance job plan. The job plan is linked to a category. So the maintenance job plans are between the categories and maintenance tasks. The sheet in the Excel file is called “AssetsTasksGroups”. Details field...

General This part is used to load all tasks in MXSuite. The sheet in the Excel file is called “AssetsTasks”. Details fields To fill the Excel file correctly, make sure that all fields are filled correctly. Below are the fields listed. Field MAX Char...

In lots of databases, the file growth settings are left as the default value: 1MB or 10%. This is not optimal.  It can cause all kinds of issues, which rear their ugly heads as performance problems. We have created a SQL Server agent job that runs monthly on ...

This article describes how to set or change the target recovery time of a database in SQL Server by using SQL Server Management Studio or Transact-SQL. By default, the target recovery time is 0 or 60 seconds, and the database uses indirect checkpoints. The tar...

Since SQL Server 2016, there has been an option to enable a query store. The query store stores details about unique queries: their execution plans, the time they took, the logical reads they required, etc. This would help greatly in identifying performance is...