Sql query analyze for performance

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

How to analyze sql query & improve its performance.
Is it possible using SSMS ??
Any tools available??

What I have tried:

just checked in SSMS but couldnt find any.

Posted 6-Apr-16 21:49pm

rahulshek

Updated 6-Apr-16 23:33pm

Add a Solution

Comments

CHill60 7-Apr-16 4:06am

Did you try checking in Google?

Member 11712753 7-Apr-16 4:17am

You can tell SSMS to include actual "Execution Plan" for your query such that you'll know which part is the bottleneck of your query.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2016-04-06T23:33:00

There is a plethora of tools available, but the ones I use mostly are:

SQL Server Profiler, see tutorial here: SQL Server Profiler Step by Step[^]

But I would not recommend it, it's too complex and version specific, the open-source ExpressProfiler is much easier to use, see: ExpressProfiler - Home[^]

You can also test queries in SQL Server Management Studio like this:

SET STATISTICS IO ON
SET STATISTICS TIME ON
CHECKPOINT
DBCC DROPCLEANBUFFERS

USE [XXX]

SELECT * FROM MyTable

As already mentioned by Member 11712753, you can use execution plan:
In Management Studio query editor, you can choose to either display an estimated execution plan or the actual execution plan by clicking the Display Estimated Execution Plan or the Include Actual Execution Plan button on the query editor toolbar.
Displaying Graphical Execution Plans (SQL Server Management Studio)[^]