How to determine the number of rows return by a query

Question

0.00/5 (No votes)

See more:

i have a query that takes more than 3 hours before it return the results. i have already add indexes based on the suggestion of DTA. and i don't know what else should i do with it. please give me advice.. thanks

What I have tried:

Use Profiler and DTA then add indexes to the tables

Posted 22-Aug-16 21:03pm

ProgrammingEnthusiast

Updated 23-Aug-16 10:36am

Add a Solution

2 solutions

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)

CPallini · Answer 1 · 2016-08-22T21:19:00

Solution 1

You have first to estimate if your query execution is taking more time than expected, then you could try this: Checklist for Analyzing Slow-Running Queries[^].

Posted 22-Aug-16 21:19pm

CPallini

Comments

ProgrammingEnthusiast 23-Aug-16 3:37am

Thanks on your TIP, i'm reading it right now. but, would you happen to know if there's a calculator that suggests how much memory should i install on my machine? my Database size is more or less 400GB and my memory is 64GB only, do you think it falls to #2: Inadequate memory in the server computer, or not enough memory available for SQL Server.

Maciej Los · Answer 2 · 2016-08-23T10:36:00

Code Project Knowledge Base[^] is full of articles/tips which can be helpful for you. For example:
How to Improve Performance of Query[^]
Improving the performance of queries using SQL Server: Part 1[^]
Improving the performance of queries using SQL Server: Part 2[^]
Improving SQL query performance using JOIN[^]

Try!