Activity Monitor in sql server- How to Use ?

preview_player
Показать описание
This is the default tool provided by Microsoft SQL server to monitor server activity. SQL Server Activity Monitor is a feature in SQL Server Management Studio that displays information about the SQL Server processes and their effect on SQL Server performance
Рекомендации по теме
Комментарии
Автор

Nice job. That was very helpful. Thanks

McCallumClips
Автор

I have few SPID in BackGround status in SQL sever and it have huge CPU time, does it cause slowness in the DB ?
activity monitor, lazy writer are also in Background status and have High CPU time does it slow down other process ?

kondetiumamahesh