Summary

• Page properties (2 modified, 0 added, 0 removed)
• Attachments (1 modified, 0 added, 14 removed)
  • __fileCreatedFromDataURI__.png
  • image-20241106083303-1.png
  • image-20241106083317-2.png
  • image-20241106083333-3.png
  • image-20241106083418-4.png
  • image-20241106083531-5.png
  • image-20241106083858-6.png
  • 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

Details

Page properties

Title

...	...	@@ -1,0 +1,1 @@
	1	+SQL Performance Baseline

Content

...	...	@@ -1,14 +1,2 @@
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		-1. Navigate to Data Collector Sets and click on **User Defined**. [[image:image-20241106083333-3.png]]
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="315" width="587"]]
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]]
14		-1.
	1	+1. Type "perfmon" in the Windows search bar and open the **Performance Monitor** app.  [[image:__fileCreatedFromDataURI__.png||height="312" width="384"]]
	2	+1. Navigate to Data Collector Sets and click on **User Defined**.

__fileCreatedFromDataURI__.png

Size

...	...	@@ -1,1 +1,1 @@
1		-611.4 KB
	1	+98.8 KB

Content

image-20241106083303-1.png

Author

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

Size

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

Content

image-20241106083317-2.png

Author

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

Size

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

Content

image-20241106083333-3.png

Author

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

Size

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

Content

image-20241106083418-4.png

Author

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

Size

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

Content

image-20241106083531-5.png

Author

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

Size

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

Content

image-20241106083858-6.png

Author

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

Size

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

Content

image-20241106084049-7.png

Author

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

Size

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

Content

image-20241106084322-8.png

Author

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

Size

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

Content

image-20241106084655-9.png

Author

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

Size

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

Content

image-20241106084809-10.png

Author

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

Size

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

Content

image-20241106085026-11.png

Author

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

Size

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

Content

image-20241106090021-12.png

Author

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

Size

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

Content

image-20241106090216-13.png

Author

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

Size

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

Content

image-20241106090346-14.png

Author

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

Size

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

Content