Some services (including third-party services) frequently provide their own monitoring and analysis utilities. Examples include the SQL Management views, and the Query Performance page in the SQL Management Studio.

These tools are dependent on the nature of the service being provided. For example, the Query Performance page in the SQL Management Studio lets you view the details of the query execution plan for recently executed SQL statements. If you have an understanding of how SQL Server optimizes queries, you might be able to use this information to make your queries more efficient.