Activity Monitor In SQL Server 2008

Asked By Puckett Buckner 0 points N/A Posted on - 07/08/2016

How can I know that which processes are doing the poor performances in the SQL Server 2008? What is the way to activity monitor in SQL Server 2008?

• Status: Open
• Question Views: 360
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Ma. Ruby Angela 0 points N/A #162736

Activity Monitor In SQL Server 2008

Asset concentrated procedures utilize much processor time, memory, and plate while they are executed. Discovering them is essential for execution checking and tuning. The following stride is to dissect these costly SQL Server questions and enhance them if conceivable.

An SQL question cost demonstrates a number of assets (processor time, memory, and circle) an inquiry has utilized amid its execution. A far-reaching question utilizes a ton of processor time and memory and has numerous I/O operations. Accordingly, an inquiry expense can be broke down from a processor, memory, and plate cost point of view.

About Ma. Ruby Angela

Questions
3

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/08/2016
• Question Category: MS SQL Server