VAIYDEYANATHAN.V.S (10/24/2007)

---

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/indexvw.mspx

kiruba (10/24/2007)

---

What is the maximum response duration for TSQL Query?

Bob Fazio (10/26/2007)

---

Nice blog Grant!

1) If it is too slow to be useful -> then you need to tune it more :)
2) If no one is complaining, then it might be ok, but refer to 1 just in case.
3) If they are complaining... Good! You don't have 1 (they are trying to use it).
4) If they are using system and NOT complaining, you are busy with other things.
Then you are done.
5) If they are using the system and NOT complaining, but you have some free time.
Then you should look for something that could be improved...
6) HOWEVER don't change it until 3 happens ;)

TheSQLGuru (11/1/2007)

---

I think 6 should be removed from the list. Performance improvements are always welcome IMHO. Preventing user complaints should be a goal of all companies!

Bob Fazio (11/1/2007)[hrComplaints come from many sources. A stable system is a good goal too. Performance is also a goal. If you haven't noticed before a high performance system is almost always less stable than one that performs just a little less optimal.