Chapter 20 - Operations
On This Page
Introduction and Goals
Operational Framework
Windows Environment Operations
SQL Server Environment Operations
Introduction and Goals
After the solution has been deployed, the operations staff inherits ownership of the solution and is required to manage and maintain it. The operations team has been prepared for this task by its involvement in the Deploying and Stabilizing Phases and by reviewing the documentation prepared by the project team. Even if the Windows® environment existed before the migration, this project will have a great impact on operational tasks and responsibilities. This chapter provides additional links to guidance on how to operate the production infrastructure containing Microsoft® SQL Server™ and Windows technologies.
Operational Framework
With the penetration of technology into every aspect of modern day business, success is based not only on the technology but also on the people and processes that control the technology. The migration project has only contributed the technology and not the operational aspects of the deployed solution. Microsoft Operations Framework (MOF) is a collection of best practices, principles, and models. It provides comprehensive technical guidance for achieving mission-critical production system reliability, availability, supportability, and manageability for solutions and services built on Microsoft products and technologies.
The following links provide information about the operational framework:
Microsoft Solutions for Infrastructure and Management (MSIM) provides in-depth technical procedural guidance on the management and operation of Windows-based servers and computer data centers. More information is available at https://www.microsoft.com/technet/itsolutions/cits/mo/default.mspx.
A brief overview of the MOF process model and concepts is provided in "Appendix A" of the UNIX Migration Project Guide (UMPG): https://go.microsoft.com/fwlink/?LinkId=19832.
An entire discussion of MOF, its Service Management Functions (SMFs), and all the resources that support the framework, is available at https://www.microsoft.com/technet/itsolutions/techguide/mof/mofpm.mspx.
Windows Environment Operations
This section provides information about various aspects of a Windows Server™ 2003 deployment in an enterprise environment.
System Administration
For common administrative tasks, refer to https://www.microsoft.com/technet/prodtechnol/windowsserver2003/proddocs/entserver/ctasks_topnode.mspx.
For tools, refer to https://www.microsoft.com/windowsserver2003/downloads/tools/default.mspx.
The Active Directory Operations Guide is available at https://www.microsoft.com/downloads/details.aspx?familyid=84dfe61e-fb7b-4673-89b8-55bcc801b431&displaylang=en.
A technical overview of network load balancing is available at https://www.microsoft.com/technet/prodtechnol/acs/reskit/acrkappb.mspx.
Security Administration
The Windows Server 2003 Guide is available at https://www.microsoft.com/technet/security/prodtech/win2003/w2003hg/sgch00.mspx.
A source containing a wide range of security topics and technologies is available at https://www.microsoft.com/security/guidance/default.mspx.
For best practices for implementing a Microsoft Windows Server 2003 Public Key Infrastructure, refer to https://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/ws3pkibp.mspx.
Information on account passwords and policies is available at https://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/bpactlck.mspx.
Information on certificate templates is available at https://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/ws03crtm.mspx.
The Security Services FAQ is available at https://www.microsoft.com/resources/documentation/WindowsServ/2003/standard/proddocs/en-us/Default.asp?url=/resources/documentation/windowsserv/2003/standard/proddocs/en-us/safer_howto.asp.
Monitoring
Information on the tools available for monitoring is available at https://www.microsoft.com/resources/documentation/WindowsServ/2003/enterprise/proddocs/en-us/Default.asp?url=/resources/documentation/WindowsServ/2003/enterprise/proddocs/en-us/tools_monitoring_status.asp.
For monitoring of server performance, refer to https://www.microsoft.com/technet/prodtechnol/windowsserver2003/proddocs/entserver/ctasks019.mspx.
For monitoring of security-related events, refer to https://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/ServerHelp/bc9f1bed-1c85-413a-869e-98d467853978.mspx.
Additional Links
Information on Windows Server 2003 performance and scalability is available at https://www.microsoft.com/windowsserver2003/evaluation/performance/perfscaling.mspx.
Information on account management for Windows Server 2003 is available at https://www.microsoft.com/windowsserversystem/overview/benefits/manageability/account.mspx.
Best practices for managing Windows Server 2003 are available at https://www.microsoft.com/technet/community/events/windows2003srv/tnt1-106.mspx.
SQL Server Environment Operations
This section provides information on various aspects of a SQL Server 2000 deployment that can be used to ensure optimal performance in an enterprise environment. Performance is also critical to scalability.
Administration
For detailed information on SQL Server administration, refer to https://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_adminovw_7f3m.asp.
Information about administration subjects is available at https://www.microsoft.com/sql/techinfo/administration/2000/default.asp.
For detailed discussions on topics such as indexes, statistics, automation, and memory management, refer to SQL Server 2000 Operations Guide: System Administration at https://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops4.mspx.
Information about backup and recovery is available at https://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_9zcj.asp.
A discussion on recovery models is available at https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/dbRecovery.asp.
Security
For detailed discussion on managing security, refer to https://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_05bt.asp.
Monitoring
For monitoring of system performance and activity, refer to https://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_mon_perf_00mr.asp.
Additional Links
The following links provide information on SQL Server 2000 environment operations:
Information about security patch management for SQL Server is available at https://www.microsoft.com/windowsserversystem/overview/benefits/manageability/patch.mspx.
The SQL Server 2000 Operations Guide is available at https://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx.
Also refer to Appendix B, "Getting the Best out of SQL Server 2000 and Windows," for links to additional information about performance, scalability, and high availability.
Download
Get the Solution Guide for Migrating Oracle on UNIX to SQL Server on Windows
Update Notifications
Sign up to learn about updates and new releases
Feedback