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

Hi,

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

SQL Server Performance Troubleshooting

 

Read previous article before this.

Monitor SQL Database via SP_WhoIsActive or FogLight | SQL Server Performance Troubleshooting -1

 

 

 

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.

monitoring-performance-counters-via-perfmon-sql-server-performance-troubleshooting-3

 

 

 

Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.

SQL Server ( MSSQL DBA ) Database Tutorials for Beginners Database Administrators

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and 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 [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *