SQL Server Performance Troubleshooting -2 Monitor Databases and Instances via Activity Monitor

Hi,

I will continue to explain how to Troubleshoot Performance problems of SQL Server in this Article Series.

Read previous article before this.

 

Monitor Database and Instances via Activity Monitor

Activity Monitor is an internal tool that provides information about databases running on SQL Server Instance such as instant CPU, Process and Resource Wait, and Expensive Queries and how these processes affect SQL Server instance.

 

 

You can change the refresh interval of the Activity monitor tool that shows the active running activities if you want to refresh the information periodically.

 

 

You can monitor Processes like following. Which process is TOP and and their Wait type, Wait resource in detail with this section.

 

You can monitor Resource waits like following. You can see what is the TOP Wait event with this section.

 

 

 

You can monitor Data file I/O like following. You can learn Disk and Datafile Response Time with this section.

 

You can monitor and see Recent Expensive Queries like following. These Queries are TOP SQL, and you should examine them. If they are running Slow, you should Tune them.

 

I will continue to explain SQL Server Performance Troubleshooting in the next article.

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.