Tools used for Performance Evaluations


null

To resolve the issues related to performance issues MS SQL server we need to be aware about the below tools for resolving the issues :

  1. Dynamic Management Views (DMVs) and System Catalog Views
  2. Profiler and Server Side Traces
  3. Windows Performance Monitor
  4. Built in performance reports in SSMS
  5. Query Plans
  6. Database Tuning Advisor

We need to learn these tools to collect the performance related data for resolutions.

Advertisements

About Devendra Singh

A guy with self learning capability , Analytical Ability , Exploring in nature , Just looking for ways for spreading happiness among everyone. Little aggressive some time. Just want peace everywhere in this world.
Aside | This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s