SQL SERVER PERFORMANCE TUNING TICKIf 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:
- Launch Windows Task Manager.
- Select View ➤ Select Columns.
- Select the Base Priority check box.
- 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.
Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompanySponsored Ads