How you will check the Priority assigned to SQL Server management studio?

SQL SERVER PERFORMANCE TUNING TICK
If SSMS Priority is low then it will degrade SSMS performance so if your server responding slow then you must check base priority of SSMS
Priority is the weight given to a resource that pushes the processor to give it greater preference when executing. To determine the priority of a process, follow these steps:

  1. Launch Windows Task Manager.
  2. Select View ➤ Select Columns.
  3. Select the Base Priority check box.
  4. Click the OK button.

These steps will add the Base Priority column to the list of processes. Subsequently, you will be able to determine that the SQL Server process (ssms.exe) by default runs at Normal priority, whereas the Windows Task Manager process (taskmgr.exe) runs at High priority.

Comments

Archive

Contact Form

Send