|
|
Posted by Erland Sommarskog on 10/02/63 11:45
IanIpp (ian.ippolito@gmail.com) writes:
> 3) Regarding tuning queries,etc.
>
> Yes, we have control over the code but we already run
> extensive/constant query tuning and add/adjust indexes and regularly
> use the Database Tuning Advisor (see my post here for some of the
> existing bugs I've found in SQL 2005's DTA:
> http://rentacoder.com/CS/blogs/real_life_it/archive/2006/03/17/447.aspx
> ). We also update statistics and defrag the indices (and rebuild the
> ones that can't be defragged). There are 2 bugs I have open tickets on
> with indices not being defragged even after rebuilding...and not on
> small tables, but large ones with thousands of pages of data. I'll
> update my blog once MSFT gives more information on what is going on.
I don't want to belittle, but I have a strong feeling that you still
have a lot to gain by tuning the application. Maybe you've past all
the simple ones: adding indexes, finding bad queries etc, and you
will now have to look for more structural issues. That is, how much
iterative processing (cursors and the like) do you have?
After all, the numbers Stu gave for his system were appalling better
than yours.
Of course, TPC-C benchmark was even further afield, but that is a
value that more demonstrates the outer edge of what is at all possible.
I can't give any numbers for our system, but none of our customers are
close to the load that yours and Stu's system see.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|