SQL Performance Baseline

Last modified by Mohamed Varachia on 2024/11/06 08:54
  1. Type "perfmon" in the Windows search bar and open the Performance Monitor app.  image-20241106083317-2.png     
  2. Navigate to Data Collector Sets and click on User Defined. image-20241106083333-3.png
  3. Right-click User Defined, select New, and then choose Data Collector Set.image-20241106083418-4.png
  4. In the dialog box, enter "SQL Performance Baseline" as the name. Choose Create from a template, click Next.image-20241106105324-15.png​​​​​​​
  5. Click Browse and navigate to the XML file provided for the template and click Next. image-20241106083858-6.png
  6. Set the Root Directory to the desired folder on a non-business-critical drive with ample space (around 700 MB per day) and click Next. image-20241106084049-7.png
  7. Select Open properties for this data collector set and click Finish. image-20241106084322-8.png
  8. In the properties window, go to the Schedule tab.image-20241106084655-9.png
  9. Click Add, set the Start time to 6:00 AM, and select all days, then click OK. image-20241106085026-11.png
  10. Navigate to the Stop Condition tab. Check Overall Duration, set Units to Hours, and enter 17 to stop at 11 PM. Click OK to save settings. image-20241106090021-12.png
  11. Under User Defined, right-click on SQL Performance Baseline and select Start. image-20241106090216-13.png
  12. Go to the folder specified in Step 6 to confirm that the data file is being created (If no file appears, check folder permissions to ensure the running account has create and write access)
  13. If the file is created, right-click on SQL Performance Baseline and select Stop. image-20241106090346-14.png
Tags: