Improve performance--need help

Question

Post reply

Improve performance--need help

antonyp 46888

SSChasing Mays

Points: 640
More actions
September 27, 2010 at 3:56 am

#227388

Hello,
Hello,
We are downloading data more than 5000 records through Sql server.
For the optimization purpose i have applied Indexes and also i have used all kind of perfomance improve rules.
But still we are facing the problem to download the data,its too slow.
Could someone give the suggestion for improve the performance..
Thanks,
ARP

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

What tool are you using to "download data"?

Can you post the query you are using?

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

antonyp 46888 SSChasing Mays Points: 640 More actions · Answer 2

Hello,

Here is code we are searching for contacts.

Thanks,

ARP

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Please post table definitions, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 4

This is a very big "catch all" procedure.

First off you are running the final query upto 3 times, I suggest you run it once , cache the results to a temp table and process that, if you have to have three result sets.

What does the function fn_generate_contact_search_criteria do ?

Its obviously code that generates code , but are all the possible conditions support by indexes ?

As Gail says, we need more info though...

Clear Sky SQL
My Blog[/url]

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 5

While we're waiting for more information, a pretty simple rule, if you're moving everything, every time, it's pretty difficult to "tune" the process. You should validate that the amount of info you're trying to move is the amount of info needed.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning