Abstract: In SQL Server, Performance Tuning can be achieved through many avenues: hardware, software, the database and the client. While there are many pathes that yield gains, finding the imporvements that give the greatest gain with the least impact on your current systems is a must. In SQL Server there is no other area in the product where you can get better performance gains than with indexes. However, knowing the right types of indexes as well as finding the right balance of indexes (e.g. Balancing OLTP and DSS requirements) takes strategy. Moreover, once created – indexes must be maintained. Even when properly created (and with the right strategies based on data usage patterns) indexes can lose their effectiveness over time due to fragmentation through inserts, updates and deletes. In this session you will learn the effect of data modifications on indexes and how to clean up the fragmentation. Did you know there are multiple ways? Did you know that each method provides different pros and cons in terms of maintenance and availability?
Prerequisites: Blog entry which has the prerequisite Webcast Resources: the link to the on-demand webcast from June 11, the pdf for that deck, the sample database and all scripts, the Q&A write-up and more here.
PDF: So you can print and be ready for the webcast on Monday, July 19, 2004 here it is: IndexesRightBalance-Defrag.pdf (2.13 MB)
To Register: go here and DO NOT BELIEVE the abstract :)… I am NOT repeating last month’s session this is a follow-on to that session which focuses on Index Defrag Best Practices!
See you Monday (and yes, I know! I still owe you a few Table Design Best Practices… it’s been a long week already! :)