B.2. Weekly tasks
Collate and update Performance Monitor log information for baseline analysis purposes, looking for emerging trends among counter values. This information will feed into the monthly capacity-planning task.
Review recent wait statistics and include them alongside the Performance Monitor counter information in the performance baseline.
Execute index and statistics maintenance jobs (during periods of low activity) as appropriate. For systems with large enough maintenance windows, this may be a simple rebuild of all indexes (while being aware of the impact on log shipping/database mirroring) or a more targeted approach that selects the appropriate technique (reorganize/rebuild) based on the fragmentation level.
Record disk usage trends ...
Get SQL Server 2008 Administration in Action now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
