SQL Server Performance

Kalen Delaney visit - UK SQL Server user group

Discussion in 'Forum Announcements' started by satya, Jan 25, 2005.

  1. satya Moderator

    Feb 8th, 2005 - READING

    In this 2-part seminar, Kalen Delaney presents internal details and management tips on two crucial aspects of SQL Server.

    Part 1: Transaction Log Internals and Management
    In this session, we#%92ll examine how SQL Server manages and maintains the transaction log internally, and we#%92ll examine some undocumented commands for examining log usage and log growth.

    We#%92ll discuss what happens and the log grows or shrinks and the pros and cons of placing the transaction log on multiple files.

    Finally, we#%92ll look at how the log is processed during BACKUP and RESTORE commands, and how that processing changes in different recovery models.

    Part 2: Index Internals and Best Use

    In this session, we#%92ll have a quick review of the most important structural differences between clustered and nonclustered indexes, and then take a look at the details of their internal storage using both documented and undocumented TSQL commands.

    We#%92ll discuss special index use scenarios such as covering indexes, index intersection and the best use of composite indexes. We#%92ll examine the ways that the ordering of columns in a composite index can make a difference in query performance.

    Finally, we#%92ll put all the pieces together to come up with some general guidelines for designing the best index structures for your tables.

    More information:http://www.sqlserverfaq.com?eid=48

    Feb 10th, 2005 - EDINBURGH

    This seminar will concentrate on 3 main areas:

    · SQL Server 2000 Index Structures

    This section will discuss details of the internal storage of indexes, and understanding how the structural differences between clustered and nonclustered index affects their usefulness in improving query performance.

    · Query Tuning Tools and Techniques

    We will look at the SQL Server query optimizer in detail, and explore how to read the execution plan output, and how to determine if tuning is necessary. We will also look at the SQL Server#%92s plan caching, and how and why reoptimization and recompiling might take place. Options for troubleshooting will include the SQL Server Profiler and the Index Tuning Wizard. We will explore options for tuning including re-indexing, over-indexing, and denormalization and the use of SQL Server 2000 Indexed Views.

    · Query Tips and Tricks

    In an ideal world, how you write your query should not affect the performance. However, SQL Server is a work in progress, and it is not perfect yet. There are ways you can rewrite a query to encourage the SQL Server optimizer to make better decisions and to change a slow running query into a fast one.

    More information:http://www.sqlserverfaq.com?eid=49

    Tony Rogerson SQL Server MVP
    Torver Computer Consultants Ltd

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  2. satya Moderator

    Atlast the day was valuable to tuck in SQL wisdom from Kalen Delaney sessions.

    Though the subject was known to me it was my wish to meet Kalen one day... I was more than happy that she recognised my contribution in SQLMag forums & DB forums.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page