optimizig the queries in need some links

Question

optimizig the queries in need some links

SAT_SQL

Default port

Points: 1465
More actions
June 26, 2009 at 11:46 pm

#211281

Hi all
I need the links for the query optimization , controls of the CPU USAGE ,..
regards
sat_SQl

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

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

ps. One Orange Chip Points: 29422 More actions · Answer 1

SAT_SQL (6/26/2009)
Hi all
I need the links for the query optimization , controls of the CPU USAGE ,..

The foremost thing to lookout for is having indexes on the columns in the where clause. Besides this you should look after index fragmentation issues and updating statistics.

You may like to go through

http://blogs.msdn.com/queryoptteam/

and

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1299403_mem1,00.html

Pradeep Singh

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

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

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

ps. One Orange Chip Points: 29422 More actions · Answer 3

GilaMonster (6/27/2009)
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Thanks Gail for writing such a great article series, undoubtedly the best on the subject one could ever find anywhere:-).

Pradeep Singh

SAT_SQL Default port Points: 1465 More actions · Answer 4

SAT_SQL

Default port

Points: 1465

June 29, 2009 at 5:23 am

#1016723

Thanks Gail

Regards

sat_sql