.png)
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 http://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): http://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 http://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 http://www.microsoft.com/technet/prodtechnol/windowsserver2003/proddocs/entserver/ctasks_topnode.mspx.
-
For tools, refer to http://www.microsoft.com/windowsserver2003/downloads/tools/default.mspx.
-
The Active Directory Operations Guide is available at http://www.microsoft.com/downloads/details.aspx?familyid=84dfe61e-fb7b-4673-89b8-55bcc801b431&displaylang=en.
-
A technical overview of network load balancing is available at http://www.microsoft.com/technet/prodtechnol/acs/reskit/acrkappb.mspx.
Security Administration
-
The Windows Server 2003 Guide is available at http://www.microsoft.com/technet/security/prodtech/win2003/w2003hg/sgch00.mspx.
-
A source containing a wide range of security topics and technologies is available at http://www.microsoft.com/security/guidance/default.mspx.
-
For best practices for implementing a Microsoft Windows Server 2003 Public Key Infrastructure, refer to http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/ws3pkibp.mspx.
-
Information on account passwords and policies is available at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/bpactlck.mspx.
-
Information on certificate templates is available at http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/ws03crtm.mspx.
-
The Security Services FAQ is available at http://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 http://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 http://www.microsoft.com/technet/prodtechnol/windowsserver2003/proddocs/entserver/ctasks019.mspx.
-
For monitoring of security-related events, refer to http://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 http://www.microsoft.com/windowsserver2003/evaluation/performance/perfscaling.mspx.
-
Information on account management for Windows Server 2003 is available at http://www.microsoft.com/windowsserversystem/overview/benefits/manageability/account.mspx.
-
Best practices for managing Windows Server 2003 are available at http://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 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_adminovw_7f3m.asp.
-
Information about administration subjects is available at http://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 http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops4.mspx.
-
Information about backup and recovery is available at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_9zcj.asp.
-
A discussion on recovery models is available at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/dbRecovery.asp.
Security
For detailed discussion on managing security, refer to http://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 http://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 http://www.microsoft.com/windowsserversystem/overview/benefits/manageability/patch.mspx.
-
The SQL Server 2000 Operations Guide is available at http://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
