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.
| Author |
Topic |
|
Jheds
Starting Member
17 Posts |
 Posted - 2007-01-02 : 07:26:27
|
| Hi Friends, Kindly guide me with this. A SQL query on SQL SERVER 2000 is taking a very long time to execute. I think I have to tune the performance.I feel there is a standard check list for finding where the query is taking long. How should my approach be towards solving the problem.Can anyone please help me with their own checklists which they use when encountering such issues.Regards,Jheds |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-02 : 07:31:53
|
| Generally it depends upon how the query is written, what indexes are defined, how tables are physically stored, table statistics etc. If you want tips on performance tuning, take a look at, [url]www.sql-server-performance.com[/url]Also, if you want in-depth details check this link:[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
SQL TUNING HELP !