Some statistics on the server: 1) Statistics 80 portNumber of connectionsNetstat-nat|grep-i |wc-l 1 2) Statistical HTTPD protocolNumber of connectionsPs-ef|grep httpd|wc-l 1 3), statistics connected, the status of "established ' Netstat-na|grep established|wc-l 2 4), to find out whichIPThe address is most connected and sealed. Netstat-na|grep Established|awk ' {p
The following is a collection of common maintenance commands for linux servers. I hope this command will be helpful to you.
Change the time zone to Zone 8, Shanghai
1 cp/usr/share/zoneinfo/Asia/Shanghai/etc/localtimeModify host name
1 # modify the following two files:
2 vim/etc/hosts
3 vim/etc/sysconfig/networkView the number of connections per IP address on the server
operations. This is called the reaching. But note that some additions and deletions with a where condition, in these cases, some indexes can improve performance, such as the millions of the table to delete a row of data, if there is no index (assuming that even the clustered index does not), then only scan the entire table delete, in the formal environment to try to know, the speed is simply unacceptable.
Too many indexes also cause the database to "volume" to become larger. In essence, the p
Combined with the operation and maintenance problems encountered in my work, this paper summarizes the common operation and maintenance problems of Linux server and the location method. The server here mainly refers to the self-developed logic server,web SRV because it usual
Article Title: Linux server maintenance. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
Linux server maintenance statistics on the number of connections to view some statistics on
Tags: server error code base SYS about MDA tar Restart Center Error symptoms: D:\Program Files\Microsoft SQL Server\mssql.1\mssql\log below Erroelog, hit with text, view run dimension plan unsuccessful is the generated error log details: 2011-08-11 14:16:48-! [298] SQL Server error: 15404, unable to get information about Windows NT Group/user ' computer name \ad
vchannelserver.Vchannelloadserver are single-server, Vchannelserver and vchannelmediaserver are dynamic-boot multi-server.Vchannelsuperserver Direct-to-air superior server that provides an up-to-the-connection interface to all related servers in the live broadcast.Data maintenance includes: Dynamic boot Vchannelserver server
Most of the servers we use are windows server 2000 and windows server 2003 windows. server2003 is currently the most mature network server platform, which greatly improves security compared with windows 2000, however, the default security configurations of 2003 and 2000 are not necessarily suitable for our needs. Therefore, we need to complete the security config
separated from the database, you can consider Table partitions and then back up the data of other tables (primary partition backup) after Partitioning. These backups cannot use differential backup, only full backup can be used each time, and Table partitions cannot be used during restoration. You can only change the table name and create a new table. For details, refer:SQL Server maintenance plan backup pr
ServerSecurity issues cannot be ignored in a certain sense. So how to perform security maintenance on the server becomes the focus. Below we will introduce several skills for your reference.
Tip 1: Start with basics
When we talk about network server security, the best advice I can give you is not to be a layman. When a hacker starts to launch an attack on your ne
ObjectiveAn earlier article introduced indexes to improve query performance in a database, which is just the beginning. Perhaps assuming a lack of proper maintenance, index the performance of your previously established and even become a drag-and-drop database of accomplices.Looking for fragmentsThe elimination of fragmentation index maintenance is probably the most common task, and is to use REORGANIZE to
Article Title: server maintenance: troubleshooting methods under RHEL5 system. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.
I. All files under/boot are lost: (grub, kernel, initrd ramdisk)
1. Start with bootdisk and enter the liunx rescue mode. Select local install or
Tags: time detail Way NET write database backup ICA database management ATI in database management, database backup is very important. The Maintenance Plan Wizard makes it easy to complete a database backup. The following example shows how to implement a backup of a database with a backup strategy of One full backups per Sunday, differential daily backups (except Sunday), and hourly log backups. In addition, you can specify to delete outdated backu
First, restrict internet access
Create access rules, in Access rule properties, to limit Internet time and access to audio and video
Open access to internal network resources
After the ISA firewall is established in the Enterprise network, the extranet users can't access the internal network, including the network services and resources. So we're going to post the specified service.
Publish an internal SSL Web site
1. Establish the SEC virtual directory in the Web site and enable SSL
The article summarizes about 20 common commands related to Linux server maintenance. If you need them, please refer to this article.
Vi Delete empty rows
: G/^ s * $/d
Find the file in the directory that contains the specified string
Find./-name '*. conf' | xargs grep-in "baidu.com.demo.upall.cn"# Note: "baidu.com.demo.upall.cn" is the string to be searched.# This command is used to quickly locate the name
=pc.index_idWHEREPs.avg_fragmentation_in_percent> Ten andIx.name is not NULL Execution Result:Execute the generated SQL statement:ALTER INDEX [PK__GD_MOVEB__1489BC61D65FF2AA] on [dbo].[Gd_movebarcode_detail]REBUILDGoALTER INDEX [Pk_branchstylealldata] on [dbo].[Branchstylealldata]REORGANIZEGoALTER INDEX [pk_pubbranchlocation_1] on [dbo].[pubbranchlocation]REBUILDGo5. Rebuilding the entire library's statisticsExec sp_updatestats;6. View SQL statement execution time, CPU usageSET STATISTICS
SQL Server Performance Tuning 3 Index MaintenancePreface
The previous article introduced how to improve database query performance by creating indexes, which is just the beginning. If you do not need proper maintenance in the future, the indexes you have previously created may even become a drag-and-drop attack and a helper for database performance degradation.Search for fragments
Removing Fragments may be
uses this page to determine whether the index is useful for a particular query. However, this statistic is not dynamically recalculated. This means that when the data of the table is changed, the statistic information may be outdated, thus affecting the optimizer's goal of pursuing optimal work. Therefore, run the update statitics command in the following scenario:(1), inserting and deleting data rows modifies the distribution of the data.(2) Add dat
Summary of SQL SERVER partition tables-Maintenance and Management of partition tables
After creating a partition table as required, you must manage and maintain the partition table. The main content is:
1. Use the Sliding Window Scenario solution to split partition tables and data moving intermediate tables.
2. Structure Change Management of Partitioned Tables.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.