fortnight server maintenance

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

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

Settings dialog box, select the time of retention, more than the retention time, the full backup record will be deleted. 19, double-click the "Clear Maintenance" box, pop Up the Settings dialog box, choose the time of retention, more than the retention time, the full backup file will be deleted, note the path to set the backup file, and the extension bak, not. bak. 20, after the setup is complete, this is the case. 21, the following two sub-plans,

. beyond this range, consider maintenance to improve SQL performance:There are three ways to reduce fragmentation: Delete and recreate the clustered index. Re-creating the clustered index will redistribute the data so that the data page fills up. The fill level can be configured using the FILLFACTOR option in the Create INDEX. NBSP; fragments between 10% and 30%, reorganize the index, as : ALTER indexindexname on tablename

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 to detect DDOS attacks. 1 netstat-ntu

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

") 9. Establish certificate trusts (need to establish trust relationships on certificates between ISA Server and Exchange Server, implemented through CA certificate chain) 10. Publish mail server (create Exchange Web Client Access publishing rules) 11. Verifying Mail server Publishing (using OWA Client Access) Thir

ObjectiveThe previous article describes how to improve the query performance of a database by building an index, which is really just the beginning. Subsequent to the lack of proper maintenance, the index you created earlier can even become a drag, becoming an accomplice to the decline in database performance.Find FragmentsEliminating fragmentation may be the most common task for index maintenance, and Micr

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

Tags: database management run Environment Details server processorObjectiveTo do daily inspection is an important step of database management and maintenance, and it is necessary to register each inspection date and result, and may need to make a inspection report. SQL Expert Cloud (www.zhuancloud.com) makes it easy to master the path of database managementThis series is designed to address some common prob

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

This blog post simply records some of the problems and possible solutions that I have encountered in managing and maintaining Geoglobe server.1 About boot memoryThe default startup memory of the server is 256M, and when the service is more, the boot is slow. We can modify the parameters in Tomcat to increase the boot memory. The specific practice is to:Locate the Catalina.bat in the C:\Program files\geoglob

Tags: Log report core build and space personal fully configuredObjectiveTo do daily inspection is an important step of database management and maintenance, and it is necessary to register each inspection date and result, and may need to make a inspection report. This series is designed to address some common problems: I don't know what to patrol. Don't know how to get a quick checkup Machine Too much physical examination trouble

Label:--Maintenance Database----Stored procedure (procedure)----Overview： 　　 A stored procedure for SQl serve is a collection of one or more T-SQL statements。 Common program code Snippets are often created as stored procedures that create multiple invocations at once, simplifying the programmer's work and reducing the network traffic that interacts with the server. Stored procedures can contain program stat

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

Server maintenance knowledge 1. boot sequence Generally, the system should strictly follow the steps below: Turn on the total power supply. Power on the computer Cabinet Power on external devices (such as disk arrays and tape libraries) After the external device self-check is complete, the host is powered on. Server maintenan