Activity Monitor In SQL Server 2008

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #162736

Activity Monitor In SQL Server 2008

qa-featured

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.

Related Questions