Dell EMC DD Boost software, an option that is available for all Data Domain systems, has two components—a plug-in that runs on the backup server or client and a component that runs on the Data Domain systems. All connectivity between components is through industry-standard Ethernet or Fiber Channel. DD Boost software provides:
- Distributed segment processing—Distributes parts of the deduplication process from the Data Domain system to the backup server or client, increasing backup application performance by up to 50 percent
- Managed file replication—Enables backup applications to manage Data Domain replication with full catalog awareness
- Advanced load balancing and link failover—Provides link aggregation for load balancing and link failover, eliminating the need for network layer aggregation
Consider the following best practices for improving database backup and restore performance using DD Boost software for Microsoft SQL Server:
- If the Data Domain system reports reaching a stream limit, reduce the number of stripes that are being used by the operations that are running.
- To ensure the consistency of the backups on the Data Domain system, configure all the backups of a SQL Server instance to use the same Data Domain system and path.
- Do not perform five or more parallel Microsoft application agent SQL-CLR jobs. For each SQL-CLR procedure or function, the SQL Server database allocates a new thread from its thread pool and runs the SQL-CLR procedure or function in the context of that thread. The allocated thread is reclaimed in the SQL server thread pool only after the SQL-CLR function or procedure is run. If you configure many SQL-CLR jobs to run at the same time, SQL Server allocates many threads from the same thread pool and can eventually be starved for available threads and other related resources, which affects the overall performance. Be cautious when deciding on the number of parallel SQL-CLR jobs.