Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

Like this article? We recommend

Monitoring and Tuning Processing Commands

Monitoring Backups, DDL Statements, and Synchronization Events

Profiler allows you to capture data definition language (DDL) commands for creating, altering, or deleting objects such as partitions or dimensions. Normally DDL commands require no tuning, but if the command takes a long time to complete, it could be blocked by another DDL, backup, or processing command. You can check Command Begin events that don't have corresponding Command End events to see which processing/DDL commands are currently "in flight."

Backup commands compress all files of a particular database into a single file with an .abf extension. Profiler events can show backup progress. If you notice that backup is slower than usual, you might want to check the backup's file-destination share for disk issues.

Synchronization copies files from one SSAS instance to another. Synchronization events show the name and size of files that have been transferred. By aggregating this data, you can deduce how many files and how much data has been transferred. Synchronization speed is usually dependent on these two factors, unless a network issue exists between source and target hosts.

  • + Share This
  • 🔖 Save To Your Account