Tuesday, March 23, 2010
Excel VBA - "operation is not allowed when the object is closed"
Monday, March 1, 2010
Mission Critical: SQL Server 2008 General Maintenance
Mission Critical: SQL Server 2008 General Maintenance
15 February 2010
by Buck Woody
CTL10.02.001
Revision 09/21/2009 A
SQL Server 2OO8
General Maintenance
CRITICAL TASK LIST PROGRAM
This document contains steps that will assist you in the day-to-day SQL Server 2008 RTM Enterprise Edition (non-clustered) operations. It defines the basics of standard maintenance and checks for a single Instance of SQL Server 2008, and should be used as a starting point.
Review each item, placing a check in the “Confirmed” column when the task line is complete. Any line not marked “Confirmed” should stop the process until you have completed that line item.
This CTL is not meant to be a replacement for the official documentation from the product manufacturer.
CTL NUMBER
This Critical Task List is identified by a CTL number in the upper right-hand side of this document. You should use the latest CTL (identified by the date and an alpha-numeric code.
HOW TO BE ASSURED OF HAVING LATEST DATA
You can add additional information to this checklist based on your organization’s need.
CONTENT
Critical Task List 10.02.001All content is the sole responsibility of the server owner; Microsoft Corporate provides no warranties implied or implicit in this document. This document is not a product of the Microsoft Corporation.
SUPPLEMENTS
Official Site Link: (Not available at this revision level)
Whenever you receive a supplement affecting your checklist, write in the appropriate information. Printed replacement checklist pages will be made available to you as quickly as possible. A notation on the bottom inside corner of these pages will indicate that they reflect certain supplements.
COMMENTS AND QUESTIONS
Comments and questions should be directed through buck.woody@microsoft.comCritical Task Lists Managers
Buck Woody “Real World DBA”(MSFT U.S.).
| Frequency | Task | References | Confirmed |
| Post-Installation | Server and Database Settings Configured for Environment. | | |
| | Latest Service Packs Installed. | | |
| | Database Mail Configured and Tested. | | |
| | Maintenance Wizard or other Automated Maintenance Implemented. | | |
| | Baseline Performance Metrics Created and Archived. | | |
| Daily | Backups Checked. | | |
| | Windows Event Logs Reviewed. | | |
| | SQL Server Error Logs Reviewed. | | |
| | Drive Space Checked. | | |
| | Jobs History Reviewed. | | |
| | Backups Taken. | | |
| | Indexes Updated. | | |
| | Statistics Updated. | | |
| Weekly | Indexes Reviewed. | | |
| | Long-Running Queries Reviewed | | |
| | Data Archival Performed. | | |
| | Security Reviewed. | | |
| | Service Packs and OS Security Bulletins Evaluated and Applied. | | |
| Monthly | Security Tests Performed. | | |
| | New Performance Baseline Recorded. | | |
| | Restore Tests Performed on Production Server to Backup Server. | | |
| Yearly | Performance Reviews Completed from Baseline Comparisons. | | |
| | Growth Predictions Created from Baseline Metrics. | | |
| | Instance Audit Performed. | | |
| | Version Upgrade Plan Evaluated. | |
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
Elevating LLM Deployment with FastAPI and React: A Step-By-Step Guide
In a previous exploration , I delved into creating a Retrieval-Augmented-Generation (RAG) demo, utilising Google’s gemma model, Hugging ...
