SQL SERVER – Download RML Utilities for SQL Server

Microsoft RML Utilites are very helpful when analysing performance. It helps answering questions like

  • Do you know which databases are using the most resources on your server?
  • Do you know which applications are using the most resources on your server?
  • How will a service pack upgrade, configuration change or application change affect your production SQL Server?
  • Which application, database or login is using the most resources?
  • Which queries are responsible for high utilization of performance?
  • What queries are running slower in today’s workload?

I believe it is a good tool to give it a try.

Download RML Utilities for SQL Server

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Monitoring SQL Server Never Got This Easy
Next Post
SQL SERVER – Can Database Primary File Have Any Other Extention Than MDF

Related Posts

1 Comment. Leave new

  • Hi,

    one of the utilities is OStress.exe, it allows you to simulate many users running SQL on your system – ideal for load testing.

    Thanks
    Ian

    Reply

Leave a Reply

Menu