SQL Server 2000 Self-Tuning - Myth or Reality
Here's a question that's bothered me for a long time. I remember hearing from marketing types and even Microsoft partners early in the SQL 2000 product cycle that the product is self tuning. I distinctly remember a situation thrown around with DBA types saying that they would delete all the indexes and run the server for 24 hours and the server's processor would be pegged at 100% utilization for this time-period. SQL Server would then miraculously self-tune itself and processor utilization would drop to 25%. Obviously these numbers are app specific, but I've never seen this 'self-tuning' aspect.
Now I guess if you count running a SQL Profiler Trace and then run the index tuning wizard against the result, then you could say the database is capable of tuning itself. But 'self-tuning' is a pretty loaded phrase. After all, when did the DBA become considered part of the database? I'd love to see an example of how to get SQL Server 2000 to be self-tuning, but I can't find this anywhere outside the marketing docs.