PSMConfigureApplocker script with settings for Management Studio takes more than 20 minutes to run

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

PSMConfigureApplocker script with settings for Management Studio takes more than 20 minutes to run

L4 Transporter

Hi,

I'm using PSM version 14.2 and recently added connection component for SQL Management Studio (Windows Authentication). When adding the settings in PSMConfigureApplocker.xml file and running the script in PowerShell as administrator, the execution of PSMConfigureApplocker.ps1 script takes more than 20 minutes?

Any ideas?

These are the settings I added:

<!-- SQL Server Management Studio 2018 processes -->

  <Application Name="SSMS2018" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe" Method="Publisher" />

  <!-- SQL Server Management Studio 2018 Profiler -->

  <Application Name="SSMS2018-Profiler" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\PROFILER.EXE" Method="Publisher" />

  <!-- SQL Server Management Studio 2018 Tunning Advisor -->

  <Application Name="SSMS2018-DTAShell" Type="Exe" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\DTASHELL.exe" Method="Publisher" />

 

 

-- ALlowed DLL:

 

<Libraries Name="mssqlnatives" Type="Dll" Path="C:\Windows\assembly\*" Method="Path" />

  <Libraries Name="SHELLCOMPONENTS" Type="Dll" Path="%WINDIR%\SHELLCOMPONENTS\*" Method="Path" />

  <Libraries Name="SHELLEXPERIENCES" Type="Dll" Path="%WINDIR%\SHELLEXPERIENCES\*" Method="Path" />

  <Libraries Name="SQLServer" Type="Dll" Path="%PROGRAMFILES%\MICROSOFT SQL SERVER\*" Method="Path" />

  <Libraries Name="MSShared" Type="Dll" Path="%PROGRAMFILES%\COMMON FILES\MICROSOFT SHARED\*" Method="Path" />

  <Libraries Name="SSMS2018-Debugger" Type="Dll" Path="D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\Packages\Debugger\*" Method="Path" />  

1 REPLY 1

L7 Applicator

Hi @Dercel Gonzalez​ 

 

It could be due to a few reasons,

 

  • The script might be taking a long time to scan and validate the paths you specified, especially if there are many files in the directories like C:\Windows\assembly\* or %PROGRAMFILES%\MICROSOFT SQL SERVER\*. If these directories contain a large number of DLLs, this can significantly slow down the script.
  • The inclusion of many paths and libraries in the PSMConfigureApplocker.xml file could introduce performance overhead, especially if the script needs to process a large number of files.

 

 

  • Please try to narrow down the paths to only those strictly necessary. For example, instead of allowing all DLLs in C:\Windows\assembly\*, specify only the required subdirectories or DLLs.
  • Add the paths incrementally to identify which specific paths cause the slowdown
  • Also monitor the PSM server’s performance while running the script to check for any bottlenecks.

 

Hope it helps !

  • 219 Views
  • 1 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!