Page blocking in Windows 10 memory. Cleaning the disk from files that are no longer required

Optimization of 1C. Configuring MS SQL Server

1. Enable the possibility of instant file initialization (Database Instant File Initialization)

• Database creation
• Adding files, logs or data to an existing database
• Increase the size of an existing file (including operations of autoways)
• Restore database or file group

To enable configuration:

1. On the computer where the backup file will be created, open the Local Security Policy application (secpol.msc).
2. Expand the Local Policy Node on the left pane, and then click Purpose User Rights.
3. On the right pane, double-click the tasks for maintaining volumes.
4. Click the "Add" user or group button and add a user here under which the MS SQL Server server is running.
5. Click the Apply button.

1. Turn on the "Lock Pages in Memory" option

This setting determines which accounts can save data in RAM so that the system does not send the data page into the virtual memory on the disk, which can increase productivity.

To enable configuration:

1. In the Start menu, click Run. In the Open field, enter the gpedit.msc.
2. In the console, the local group policy editor expand the computer configuration node, then the Windows Configuration node.
3. Deploy Safety Settings and Local Policy.
4. Select the User Rights Purpose folder.
5. Politicians will be shown in the details panel.
6. On this panel, double click the Lock Page option in memory.
7. In the Local Security Setting dialog box, select the user or group page.
8. In the Selects dialog box: Users, Services or Group accounts, add the account under which you run the MS SQL Server service.
9. To make changes to force, restart the server or go to that user under which you are running MS SQL Server.

1. Disable DFSS disk mechanism.

The Dynamic Fair Share Scheduling mechanism is responsible for balancing and distributing hardware resources between users. Sometimes his work can negatively affect 1C performance. To disable it only for disks, you need:

1. Find in the registry HKEY_LOCAL_MACHINE \\ SYSTEM \\ CURRENTCONTROLSHARE \\ SERVICES \\ TSFAIRSHARE \\ DISK
2. Set the value of the Enablefairshare parameter in 0

1. Disable data compression for directory in which the database files are.

When the compression is enabled, it will be attempted to further process files when modified, which will slow down the recording process itself, but save space.

To disable file compression in the directory, you must:

1. Open catalog properties
2. On the General tab, click Other
3. Remove the flag to "compress" the contents for saving space on the disk.

1. Set the Max Degree of Parallelism (Max Degree of Parallelism) to 1.

This parameter determines how many threads can perform one request. By default, the parameter is 0, which means that the server itself selects the number of streams. For databases with characteristic for 1C load, it is recommended to deliver this parameter to 1, because In most cases, this will positively affect the operation of requests.

To configure the parameter you need:

1. Open server properties and select a bookmark additionally
2. Set the value of the parameter equal to one.

1. Limit the maximum amount of MS SQL Server Memory.

Memory for MS SQL Server \u003d Memory Total - Memory for OS - Memory for Server 1C

For example, a 64 GB of RAM is installed on the server, it is necessary to understand how much memory is to allocate the DBMS server to have enough 1C server.

For normal operation, OS in most cases is more than enough 4 GB, usually 2-3 GB.

To determine how much memory is required to serve 1C, it is necessary to see how much memory is occupied by the processes of server cluster in the midst of the working day. These processes are RAGENT, RMNGR and RPHOST, details these processes are considered in the section that is dedicated to the server cluster. It is necessary to remove the data during the period of peak working activity, when the maximum number of users is running in the database. After receiving this data, it is necessary to add 1 GB to them - in case of running in 1C "heavy" operations.

To set the maximum amount of memory using MS SQL Server, you must:

1. Run Management Studio and connect to the desired server
2. Open Server Properties and select Bookmark Memory
3. Specify the value of the maximum server memory size.

1. Turn on the "maintain" flag SQL Server Priority (Boost SQL Server Priority).

This flag allows you to increase the priority of the MS SQL Server process over other processes.

It makes sense to turn on the flag only if the server 1c is not installed on the DBMS server.

To install the flag you need:

1. Run Management Studio and connect to the desired server
2. Open Server Properties and select Processor Bookmark
3. Enable the Flag "Support SQL Server Priority (Boost SQL Server Priority)" and click OK.

1. Set the size of the auto increase in database files.

Autoway allows you to specify the value to which the size of the database file will be increased when it is filled. If you put too small outrage, then the file will be too often expanding, to which it will be time. It is recommended to set the value from 512 MB to 5 GB.

1. Run Management Studio and connect to the desired server
2. Opposite each file in the column Autoway to deliver the required value

This setting will only be valid for the selected base. If you want this setting to operate for all the databases, you need to perform the same actions for the MODEL service database. After that, all the newly created databases will have the same settings as the base model.

1. Scroll to MDF data files and LDF log files for different physical disks.

In this case, working with files may not be sequentially, but almost in parallel, which increases the speed of disk operations. Best of all, the wheels are suitable for these purposes.

To transfer files you need:

1. Run Management Studio and connect to the desired server
2. Open the properties of the desired database and select the Files tab
3. Remember the names and location of files
4. Disconnect the database by selecting the task through the context menu - disconnect
5. Put the flag to remove connections and click OK
6. Open Explorer and move the data file and log file to the desired media
7. In Management Studio, open the context menu of the server and select the item Attach the database
8. Click the Add button and specify the MDF file from a new disk
9. In the bottom window, the database information in the log file must specify a new path to the transaction log file and click OK.

1. Take the TEMPDB database files to a separate disk.

Restart MS SQL Server

1. Turn the Shared Memory if the 1C server is located on the same computer as the DBMS server.

Shared Memory protocol will communicate with applications through RAM, and not through the TCP / IP protocol.

To enable Shared Memory you need:

1. Run SQL Server Configuration Manager.
2. Go to SQL Native Client - Client Protocols - Shared Memory - Included
3. Put the value and click OK.

Protocol The named channels must be turned off in the same way.

Attention! When all settings are executed, you must restart the MS SQL Server service

Windows Defender Security Center, including a new device security section, which offers enhanced security tools, such as kernel insulation.

The kernel isolation is a security technology based on virtualization, which provides an additional level of protection against intelligent attacks. The integrity of the memory is one of the components of the kernel insulation technology - the function is intended to prevent malicious code insertion into high-security processes. Protection is ensured due to the fact that the kernel's virtual memory page begins only after the successful passage of integrity check.

Consider how to enable the "memory integrity" function in Windows 10 April 2018 UPDATE to enhance computer security.

Enable memory integrity

• Open Windows Defender Security Center.
• Select the section "Device Safety".

• In the "kernel insulation section" section, click the link "Nucleus insulation information".
• Move the memory integrity switch to the active position.

After completing these actions, you need to restart the computer so that the changes take effect.

Note: To work this feature, your processor must support virtualization technologies. In addition, virtualization must be enabled in BIOS or UEFI. Otherwise, the function will be unavailable.

Correction of kernel insulation problems

In some cases, you can encounter compatibility issues in some applications, if the kernel isolation is turned on. To fix the problems will have to turn off the function.

If you are trying to disable the memory integrity in the Windows Defender Security Center, but the option has become inactive and the message is shown. "This parameter drives your administrator", then you can still deactivate the function using the system registry.

Note: Incorrect registry change can lead to serious problems. It is recommended to create a backup copy of the Windows registry before performing these steps. In the Registry Editor menu, select File\u003e Export to save the backup.

• Press the Windows + R key combination to bring up the "Run" window.
• Enter the REGEDIT and click OK to start the registry editor.
• Go to the next way:

HKEY_LOCAL_MACHINE \\ SYSTEM \\ CURRENTCONTROLSET \\ CONTROL \\ DEVICEGUARD \\ SCENARIOS \\ HYPERVISORENFORCEDCODEIGRITY

• Double-click Enabled..
• Change the value from 1 to 0.
• Click OK.

To disable you can also use the Ready

Automatic cleaning of the disk from files that are no longer required, such as temporary or contents of the basket, is now available in the tenth version of Windows.

Configure and actively use such a system function each user of a personal computer. It is ideal for those who before and for the same goals used third-party software.

We all know that after working on a computer over a long period of time, some users face the problem of insufficiency of the volume of disk space. This, first of all, relates to a PC with small volumes of hard drives.

In previous versions of the operating system, when to install any program, games or records to the local section of the files of large sizes, there was not enough free space, the user received a system message with a proposal to start the classic "cleaning of the disc".

Also, when we delete any file, it moves in automatic mode to the basket and if the size of the selected location for it is exceeded, all other files will be deleted immediately. Using the SHIFT + DELETE key combination, you will not move anything to the basket.

During the installation of various applications, in the process of their work, as well as after deleting, the files created by them remain in the system and also occupy a precious place. A new feature of the Windows 10 Operations feature will help to deal with these problems, while wonderful fully automatically. Now let's see how it can be activated and go through another settings.

Cleaning a disc

Open the "Parameters" window and go to the System section, where click on the "Storage" item. You will see the "Memory Control" parameter, which is turned off by default and turn it on. After that, all operations to free disk space from unnecessary more files will be held in the background without user participation.

You can make some additional settings, namely, go to the link below called "Change the way of freeing out the place" and select preferred parameters. The "Clear Now" button will allow you to remove unnecessary files in manual mode and will notify the user about the number of released disk space.

After selecting your preferences, you can exit the configuration and the Storage Sense function will start working as needed. That's all!

I suggest you visit where you can find many different computer tips. Discussing various issues, as well as receive computer assistance in case of participation in our group in the FB.

With the update of Creators Update last year, Windows 10 got a very cool and interesting feature that will have to do gamers and not only. Sonic Surround - Virtual Sound Sound Emulator for Headphones. Include it is very simple:

• right click on the speaker icon in the bottom right of the screen;
• select "Spatial Sound" → "Windows Sonic for Headphones".

Not exactly "the very" volume sound, but the difference you must feel.

2. Virtual desktops

An extremely useful feature that helps to systematize work with a large number of programs and applications. For this you need:

• press WIN + TAB to open the "Task View" menu;
• click on "Create Desktop" at the bottom right of the screen.

Of course, you can switch using Task View, but it is much more convenient to manage virtual desktops using:

• Ctrl + Win + left or right arrow - switch between desktops;
• Ctrl + Win + D - creating a new desktop;
• Ctrl + Win + F4 - closing the current desktop.

3. Memory control

Over time, turns into a trash dump. A hundred-other unnecessary files and downloaded serials are accumulated on the computer, which you have forgotten, and the unfortunate crowded basket is cracking on the seams. You have to take yourself in hand and arrange general cleaning. This situation will help or another similar program. And you can proceed easier and use the built-in tool that will clean your system regularly.

• Go to "Parameters" → "System" → "Storage".
• Place the switch on "On".

It remains to configure the cleaning system. To do this, change the item "way of freeing the place" in the "Storage" tab. The system can automatically clean the "Download" folder and the basket, provided that the files have not been used more than 30 days. In addition, the system can automatically delete previous versions of Windows 10 days after the update.

This method will not be replaced by regular cleaning on the hard disk, but will save you from some routine actions.

4. Backup using file history

Excellent backup tool built into the system. Moreover, Windows 10 will create backup copies, you just need to specify the frequency and place where they will be saved.

• Go to "Parameters" → "Update and Security" → "Archiving Service".
• Add a disk or device where backup copies will be saved.

In additional settings, you can select folders for which you want to create backup copies.

5. Windows update settings

• Go to "Parameters" → "Update and Security" → "Windows Update Center" → "Change Activity Period".
• Set the time to which you use the computer. Windows promises that during this period will not restart the device.

If this is not enough, go to "Restart Settings" and set the day and hour when you can restart the device to install the update.

6. Dynamic blocking

The bottom line is that Windows can automatically block access to the computer when you are not near. For this you need:

• connect the phone to the computer via Bluetooth;
• go to "Parameters" → "Accounts" → "Input parameters";
• scroll down to the section "Dynamic Lock" and put a tick to allow Windows to determine when you are absent.

Windows will block access to the computer after a minute after you leave the Bluetooth Receiver Sign.

7. Alternative entry methods

You definitely need to protect the Windows account. True, enter it every time it is not so convenient. Windows developers are offered to use alternative paths.

• Go to "Parameters" → "Accounts" → "Input parameters".
• Select what you want to use: PIN or graphic key.

If in the first case everything is simple and understandable, then the second option looks more interesting. You choose any picture and invent three different gestures for it. The next time you want to unlock the computer, you will need to repeat these gestures. True, it is not very convenient without a touch screen.

8. Controlled access to folders

Take advantage of this feature if you do not want to become a victim who attacked users worldwide last year.

• Go to the Windows Defender Security Center → "Protection against viruses and threats" → "Protection parameters from viruses and other threats."

• Scroll down to the section "Controlled access to folders" section and place the switch to "On".

Select which folders need to be protected and what applications to access them.