It seems like your browser didn't download the required fonts. Please revise your security settings and try again.
Barracuda RMM
formerly Managed Workplace

SQL Server Configuration - Hosting Provider

  • Last updated on

To ensure maximum database performance, ensure that you have a dedicated SQL Server, which is defined as a system with Service Center and SQL Server installed. Do not install Windows Services and other web applications. Additionally, it is recommended that set the Max Degree of Parallelism (DOP) to 1.

Performing periodic DBCC CHECKDB operations on SCData database is not advised, as it can result in a large number of databases, and can swell database size. However, it is recommend that you run DBCC CHECKDB against the MW SCMaster database, as this is a Barracuda RMM system database that stored minimal amounts of data.

For scalability reasons, the SQL Reporting Server component must be installed on a different server from the SQL Server Database Engine. This is recommended primarily to off load CPU and memory usage from the SQL Server.

Separating the SQL Reporting services might have an impact on licensing. For more information, see the Microsoft licensing documentation.