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 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 ...Basic Performance Issues RCA On Postgres DB Cx
Whenever cx faces slowness in PG SQL Setup, below are the first step of actions to check and proceed based on our previous performance tickets. 1. Antivirus are main cause of slowness, high CPU, and memory consumption of PGSQL in many cx tickets. ...Inputs required for analyzing Performance Issues
We need a couple of details to analyze Performance issue. So, please send the below details : Below mentioned details should be gathered before restarting the application. 1. Let us know whether you are taking Scheduled full backup or backup without ...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 ...