Summary

• Page properties (1 modified, 0 added, 0 removed)
• Attachments (0 modified, 9 added, 0 removed)
  • image-20241106084049-7.png
  • image-20241106084322-8.png
  • image-20241106084655-9.png
  • image-20241106084809-10.png
  • image-20241106085026-11.png
  • image-20241106090021-12.png
  • image-20241106090216-13.png
  • image-20241106090346-14.png
  • image-20241106105324-15.png

Details

Page properties

Content

...	...	@@ -1,6 +1,13 @@
1	1	1. Type "perfmon" in the Windows search bar and open the **Performance Monitor** app.  [[image:image-20241106083317-2.png||height="323" width="398"]]
2	2	1. Navigate to Data Collector Sets and click on **User Defined**. [[image:image-20241106083333-3.png]]
3	3	1. Right-click **User Defined**, select **New**, and then choose **Data Collector Set**.[[image:image-20241106083418-4.png||height="322" width="427"]]
4		-1. In the dialog box, enter "SQL Performance Baseline" as the name. Choose **Create from a template, **click **Next**.[[image:image-20241106083531-5.png||height="206" width="385"]]
5		-1. Click **Browse** and navigate to the XML file provided for the template and click **Next **[[image:image-20241106083858-6.png||height="412" width="482"]]
6		-1.
	4	+1. In the dialog box, enter "SQL Performance Baseline" as the name. Choose **Create from a template, **click **Next**.[[image:image-20241106105324-15.png]]​​​​​​​
	5	+1. Click **Browse** and navigate to the XML file provided for the template and click **Next. **[[image:image-20241106083858-6.png||height="412" width="482"]]
	6	+1. 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:image-20241106084049-7.png]]
	7	+1. Select **Open properties for this data collector set** and click **Finish**. [[image:image-20241106084322-8.png]]
	8	+1. In the properties window, go to the **Schedule** tab.[[image:image-20241106084655-9.png]]
	9	+1. Click **Add**, set the **Start time** to 6:00 AM, and select all days, then click **OK**. [[image:image-20241106085026-11.png]]
	10	+1. 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:image-20241106090021-12.png]]
	11	+1. Under **User Defined**, right-click on **SQL Performance Baseline** and select **Start**. [[image:image-20241106090216-13.png]]
	12	+1. Go to the **folder** specified in **Step 6** to confirm that the data file is being created ((% style="color:#c0392b" %)**If no file appears, check folder permissions to ensure the running account has create and write access)**
	13	+1. If the file is created, right-click on **SQL Performance Baseline** and select **Stop**. [[image:image-20241106090346-14.png]]

image-20241106084049-7.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+39.4 KB

Content

image-20241106084322-8.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+42.2 KB

Content

image-20241106084655-9.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+111.2 KB

Content

image-20241106084809-10.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+46.9 KB

Content

image-20241106085026-11.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+38.8 KB

Content

image-20241106090021-12.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+50.8 KB

Content

image-20241106090216-13.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+93.3 KB

Content

image-20241106090346-14.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+89.9 KB

Content

image-20241106105324-15.png

Author

...	...	@@ -1,0 +1,1 @@
	1	+XWiki.mohamedv

Size

...	...	@@ -1,0 +1,1 @@
	1	+44.7 KB

Content