|
This session concentrates on the non T SQL aspects of performance tuning.
Performance tuning a SQL Server is more than just running a profiler or capturing long running queries. There may be any number of factors within the setup and configuration of your server which are impacting your sql performance. This presentation will expose possible problem areas, in effect providing a checklist for the DBA. We wil also cover x64 and x32 memory usage including system cache settings, DEP, AWE and the various memory switches. We'll also look at the microsoft tools you can use to help your diagnosis. The impact of memory on storage and storage itself will also be covered. This session is based on Windows 2003 operating system.
|