Help:Query slow

Question

Post reply

Help:Query slow

jane20030920

Grasshopper

Points: 22
More actions
December 21, 2009 at 8:57 am

#136139

I have one query. It take 2~10 seconds Nomoral, but It's very slow sometimes, take 5~10 minutes. There are more than 10000 rows in the table.
It was fine when we run it on sql server8.0. We are using sql server9.0 right now.
Any one has idea to solve it?
Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

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

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

See the links in my sig below on how to help us to help you...

Clear Sky SQL
My Blog[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Have you updated the statistics (with fullscan) since moving the database to SQL Server 2005?

jane20030920 Grasshopper Points: 22 More actions · Answer 3

Another guy installed new sql server. I don't know he did it or not.

Rome1981 SSC-Addicted Points: 445 More actions · Answer 4

Rome1981

SSC-Addicted

Points: 445

December 21, 2009 at 9:24 am

#1094860

Can you post the explain plan?

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

jane20030920 (12/21/2009)
Another guy installed new sql server. I don't know he did it or not.

Assume not and update them.

Clear Sky SQL
My Blog[/url]

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

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

myheadhurts Ten Centuries Points: 1262 More actions · Answer 7

Are there any triggers on that table?

-MarkO

"You do not really understand something until you can explain it to your grandmother" - Albert Einstein