How to invoke mssqlLockStatistics.bat ?

How to invoke mssqlLockStatistics.bat ?


The mssqlLockStatistics.bat file is located under [SDP-Home]\bin folder on the ServiceDesk Plus server. This bat file will catch hold of queries which are blocked in the Database. It will generate 2 files sp_who.html and block.txt. Both these files will be present under [SDP-Home]\server\default\log fol
































This file can be invoked only if ServiceDesk Database is MSSQL. To know the ServiceDesk Database, go to Drive:\ManageEngine\ServiceDesk\server\default\conf and click on Databaseinfo.xml file.



                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • Related Articles

                    • How to find the MSSQL Lock on the database directly?

                      Connect to the MSSQL database and open the query editor for service desk database(any database should work) 1. Execute the query  sp_who2 2. Above command will show the list of database query process which is currently in execution that causes the ...
                    • How to change the database from MySQL/PostgreSQL to MSSQL

                      The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB.    For ...
                    • How to connect to the ServiceDesk database?

                      Open command prompt on the server and change the directory to MangeEngine\ServiceDesk\bin, invoke the batch file 'changeDBServer.bat' For MSSQL database  Connect to the query analyzer of the SQL server and execute the queries. For PostgreSQL database ...
                    • Performance debugging from version 9306 onwards

                      On Performance/Crash Issues, we have one URL to generate all debug details, this is applicable from 9306 onwards.  Need to execute the URL in the browser, which has already login session into the application  ...
                    • How to connect to the AssetExplorer database?

                      To find the database connected to your installation, open Command Prompt with elevated permission, navigate to [AE-Home]\bin directory and invoke the batch file 'changeDBServer.bat'. [AE-Home] is Drive:\ManageEngine\AssetExplorer\ directory. ...