How to analyse performance of SQL Query - Urgent

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to analyse performance of SQL Query - Urgent

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-28 : 09:11:04

Sekar writes "Hi,

Was wondering to use execution plan in query analyser or sql profiler OR any other tools.

Plz. help
Thanks
Sekar"

izaltsman
A custom title

1139 Posts

Posted - 2001-11-28 : 09:43:32

That's a pretty broad question... Have you tried looking in BOL? It has some info on query tuning.

When looking at the query plan you typically want to reduce the number of scans on large tables.

And here is a couple of links to help you with Profiler
http://support.microsoft.com/servicedesks/Webcasts/wc051800/wcblurb051800.asp?LN=EN-US&SD=gn&FR=0&qry=profiler%20troubleshooting&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=SQL

http://support.microsoft.com/support/kb/articles/q224/5/87.asp?LN=EN-US&SD=gn&FR=0&qry=profiler%20troubleshooting&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=SQL

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2001-11-29 : 00:02:44

Hi
How specific can i be make my question narrower ?
Thanks for the tips and links.
Had been extremely helpful.

Sekar

quote:

That's a pretty broad question... Have you tried looking in BOL? It has some info on query tuning.

When looking at the query plan you typically want to reduce the number of scans on large tables.

And here is a couple of links to help you with Profiler
http://support.microsoft.com/servicedesks/Webcasts/wc051800/wcblurb051800.asp?LN=EN-US&SD=gn&FR=0&qry=profiler%20troubleshooting&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=SQL

http://support.microsoft.com/support/kb/articles/q224/5/87.asp?LN=EN-US&SD=gn&FR=0&qry=profiler%20troubleshooting&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=SQL

izaltsman
A custom title

1139 Posts

Posted - 2001-11-29 : 07:59:26

quote:

How specific can i be make my question narrower ?

Basically, if you have a certain query that you are struggling with, you could post your code as well as table and index structure, and someone here would probably be able to come up with some tuning tips that pertain to that specific query.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources