Changes for page SQL Performance Baseline

Last modified by Mohamed Varachia on 2024/11/06 08:54
<
From version < 8.1 >
edited by Mohamed Varachia
on 2024/11/06 07:09
To version < 2.1 >
edited by Mohamed Varachia
on 2024/11/06 06:31
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +SQL Performance Baseline
Content
... ... @@ -1,13 +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]]
1 +1. Type "perfmon" in the Windows search bar and open the **Performance Monitor** app.  [[image:__fileCreatedFromDataURI__.png||height="313" width="386"]]
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

Applications

Navigation

Need help?

If you need help with XWiki you can contact: