IN THIS CHAPTER
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. |