SQL Server Performance Troubleshooting -7 Reporting SQLDIAG Performance Data via RML Utilities Tool

Hi,

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

RML Utilities

 

Read previous SQLDiag article before this.

 

RML Utilities tool is not available in the SQL Server, so you need to install it. You can download the RML Utilities tool for free from this link.

After downloading installing the RML Utilities tool, you can open RML CMD Prompt as follows.

 

13-1

 

After opening RML Utilities Cmd Prompt command line will appear as follows.

13

 

 

With the Readtrace command below, give the first of the trace files (D1010984_SQLDIAG__sp_trace.trc) that we generated as a result of SQLDIAG in our previous article as follows.

After it read the first one, it automatically reads the others and prepare the report.

 

 readtrace -I"D:\SQL_DIAG_OUTPUT\D1010984_SQLDIAG__sp_trace.trc" -o"D:\Result"

14

 

When you run the above command, this command creates custom tables in a database and insert all performance data into this database called PerfAnalysis on our default Instance.

 

16

 

 

To see the report prepared by RML Utility for us, open the Reporter tool as below.

17-1

 

When you open the Reporter tool, a screen like the following will appear.

 

17

 

Type the Instance and Database from which the Reporter tool above will receive the Performance Data. When you click OK button, RML Utilities tool will give you a visual report as below.

 

 

18

 

 

In this report, you can see the CPU, Reads, Writes, Duration values of the database as shown below. When you click on the Unique Batches link next to the arrow above to see the costly queries ( TOP SQL ) for the database, you will see the costly queries ( TOP SQL ) for our database as follows.

 

19

 

20

 

 

 

To see more detailed information about any query, click the Template of the query from the Query Template section and see the details as below.

21

 

I will explain how to solve these Performance problems in the SQL Server 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.

Leave a Reply

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