nagios log server

This article is the fifth of the SQL Server Agent series, please refer to the original text for more information. As mentioned in the previous series, SQL Server Agent jobs are composed of a series of job steps, each of which is executed by a separate type. In the fourth chapter we see that SQL Server Agent can send notifications through Database Mail. If a

13.2.5 Deploying log shipping with T-SQL commandsSQL Server also provides the means to deploy log shipping as a T-SQL command. In the previous section, after you complete step (6) or (8), you can save the generated command script. The results of this script command and the results of the operation in Management Studio are equivalent, and this command script can a

server| Data | database The steps that you must perform when the transaction log expands to an unacceptable limit. The extension of the transaction log will cause the Microsoft SQL Server database to become unusable. In SQL Server 2000, each database contains at least one da

Log cleanup methods under SQL Server 2008 (2011-07-14 10:30:45) Transfer from http://blog.sina.com.cn/s/blog_4bdd3d0b0100wfvq.html Tags: it Every time the database log to see the explosion of some big head, so random search a way to get rid of the log, the next big head, and search f

Transaction logs are very important but often ignored in the database structure. Since it is not as active as the schema in the database, few people are concerned about transaction logs. Transaction logs are records of database changes. They can record any operations on the database and save the record results in an independent file. Transaction logs are fully recorded for every transaction process. Based on these records, data files can be restored to the pre-transaction status. Starting from t

When a system fails, it can be used to recover data to resolve database failures as long as there is a data log. As a SQL Server database administrator, it is important to understand the role of data log files and how to use them to troubleshoot common failures in some databases. Since the transaction log is so importa

Transaction log files transaction log file is a file that is used to record database updates, with an extension of LDF.In SQL Server 7.0 and SQL Server 2000, the transaction log files are automatically expanded if the autogrow feature is set.In general, the size of the trans

CatalogueWhat is a transaction logComposition of the transaction logTransaction log Size Maintenance methodsTruncateShrinkIndex fragmentationSummarizeWhat is a transaction logTransaction Log is a record of a series of actions performed on a database management system and uses these records to ensure acid availability in the event of a hardware failure or disaster. Physically, the transaction

Too many VLFsSQLServer database engines divide each physical log file into multiple virtual log files, so that the log management system can easily track which parts can be reused. The transaction log file determines the number of VLFs generated based on the following formula, whether it is automatic or manual growth:

(a) Rsyslog profileRyslog is a fast-track process for collecting system logs, providing high performance, security features, and modular design. Rsyslog is an upgraded version of Syslog that converts multiple source input and output conversions to destinations.Rsyslog is an open source tool that is widely used in Linux systems to forward or receive log messages through the TCP/UDP protocol. The Rsyslog daemon can be configured into two environments, o

Tags: style blog http using io strong file dataEvery time the database log to see the explosion of some big head, so random search a way to get rid of the log, the next big head, and search for half a day, so or write a blog, do not look for a mess.1. Set the database to Simple modeSelect the database you want to shrink, right-click Properties---options, select Simple Mode2. Select tasks, shrink-file3. Sele

Tags: style blog http ar color OS using SP filesIntroductionThe transaction log in SQL Server is undoubtedly one of the most important parts of SQL Server. Because SQL Server uses transaction logs to ensure persistence (durability) and transaction rollback (Rollback). This also partially ensures the acid properties of

Set up rsyslog log server in CentOS Functions provided by the software: 1. rsyslog is a log service of RHEL or centos 6. x, replacing the syslog service of the previous system. In this architecture, the rsyslog service is mainly used to collect logs, classify logs, and write them into the database. 2. mysql is a simple database. In this architecture, the main tas

Applications: Mainly used with virtual host, can also be used for personal server Background: 2005 a month, the normal operation of the virtual host crashed, let the computer room on duty to restart a number of times, are not, the display into the system to see, tips: C disk space is insufficient, the middle of the night to go to the room to deal with, to the computer room after the first break network, and then into the system found two places have

full mode when the purge is complete.Use[Master]GOAlterDATABASEDnnameSETRECOVERY SimpleWithno_waitGOAlterDATABASEDnnameSETRECOVERY Simple--Simple ModeGOUseDnnameGODbccShrinkfile (N' Dnname_log ', One, Truncateonly)GOUse[Master]GOAlterDATABASEDnnameSETRECOVERYFullWithno_waitGOAlterDATABASEDnnameSETRECOVERYFull--Revert to full modeGOAdvantages: This cleanup log runs short of time, 90GB of log can be cleared

References: Http://msdn.microsoft.com/en-us/library/ms187103.aspxOverview SQL Server uses log transmission, you can automatically back up transaction logs in the "primary database" on the "primary server" instance to one or more "secondary databases" on the separate "secondary server" instance ". Transaction

Introduction of Environment Configuration 1. Introduction of experimental environment Rsyslog Server Os:centos Release 6.5 (Final) x86_64Rsyslog SERAVR ip:211.149.204.229Rsyslog Client Os:centos Release 6.5 (Final) x86_64Rsyslog Client ip:63.223.64.110Rsyslog version:rsyslog-5.8.10-8.el6.x86_64LNMP Version:nginx 1.6 +mysql 5.1.72 + PHP 5.3.28 2. Dependent Package Installation [root@ebs-28723 src]# yum install gcc gcc-c++ make Rsyslog rsyslog-mysql

Friends who use the MS database will know a problem, C disk space is very easy to fill up. Because the system disk on the partition is relatively small, this is because the database during the use of the log files will increase, so that the performance of the database decreased, and occupy a lot of disk space. The SQL Server database has log files,

the log analysis statistics file, add a scheduled task as follows: 5 0 ***/bin/mv/www/logs/secfocus/'date-v-1d + \ %W'/access_log/www/logs/secfocus/access_log_yesterday In this way, the log statistics and analysis program is used to process the file access_log_yesterday.For large websites that use Server Load balancer technology, there is a prob

Configure the SSH service to log on to the Linux server using the certificate Common authentication methods for logging on to a Linux server through SSH (Secure Shell) include passwords and certificates. From the security perspective, we recommend that you log on with a certificate. It takes a lot of effort to configur