Wednesday 22 February 2017

How to find 3-party DLLs loaded in SQL Server

There are cases where heap memory get corrupted and SQL Server generally does not use heap, for this kind of case, it is possibly caused by third party DLL which did not manage heap well.

ListDlls tool is one of solution, which will help us get all loaded DLL in SQL Server, it will help us figure out if there is any 3rd-party DLLs loaded in SQL Server. You could download the tool here,

https://technet.microsoft.com/en-us/sysinternals/bb896656.aspx

And the command to use it is,

1.Please open a command prompt with run as administrator. And then switch to the folder of ListDlls.exe
2.Then run “ListDlls -v sqlservr.exe” will list all loaded DLLs of SQL Server.

No comments:

Post a Comment