Chapter 14. Administering a SQL-NS Instance


IN THIS CHAPTER

  • Monitoring and Reporting

  • Maintenance Techniques

  • Backup and Restore

This chapter explains some of the common tasks involved in administering a SQL-NS instance in a production environment. Administration tasks typically fall into two buckets: monitoring and maintenance. Monitoring tasks involve checking the instance periodically to verify that it is running as you expect. SQL-NS provides a number of facilities that you can use to monitor a running instance, including event logs, performance counters, and reports. Maintenance encompasses both the tasks you do regularly to keep the instance running smoothly and tasks that you do only when the need arisesto respond to problems, make configuration changes, or add functionality to your applications.

Before taking a SQL-NS deployment live, it's a good idea to practice some of the administration tasks described in this chapter. Although most SQL-NS applications tend to run trouble-free after a few initial problems are worked out, learning the proper administration techniques is still important. Careful administration will alert you to potential problems early and enable you to respond to them effectively.




Microsoft SQL Server 2005 Notification Services
Microsoft SQL Server 2005 Notification Services
ISBN: 0672327791
EAN: 2147483647
Year: 2006
Pages: 166
Authors: Shyam Pather

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net