How to know the queries running in SQl server currently

If SQl server consumes 100% CPU usage execute the below query to know which thread is repetitive and consuming more CPU.

 

SELECT p.spid, p.status, p.hostname, p.loginame, p.cpu, r.start_time, t.text FROM sys.dm_exec_requests a

Integrate SDP MSP with Opmanager

Opmanager integrates with SDP MSP via API using login details for sending the emails to ServiceDesk. This integration allows Technicians to log critical alarms raised in OPM as tickets in ServiceDesk and track those tickets.

For integra…

AD Duplicate Users Sync Issue

While performing AD import,you may not be able to import few users. This article helps you to find the reason and solution for the same.

Use the following query to find out the  duplicate users and remove them from requesters, technici…

Need More Help?

Are you looking for a personalized customer support? Submit your question or Call our Toll Free Number to speak with ServiceDesk Plus MSP Expert who can offer a better solution for your requirements.

Submit a Ticket
Email : sdpmsp@manageengine.com
Toll Free : 1-888-720-9500