In this article we look at some of the customizations you need to make on the Windows Server while running a SQL Server instance on it.
Working on SQL Server Database on a system that is already installed with a default Windows Server implementation can be a tricky thing. Without proper planning, some processes and settings of Windows server can conflict with your SQL Server implementation. So, check out some easy ways to optimize your Windows Server while working on an SQL Server Database.
- Minimize the Services on the Main Server Box: The first tip is to minimize the services used on the server box. For this, you can easily remove the FTP Server Service, DHCP, WINS, Directory Replicator, IIS Service and Gopher directly from your startup. In case, you need to use any of these services on the server then you can manually start them up as and when required.
- Minimize the Counters in Performance Monitor: You must know that all the performance monitor counters make use of some of the other server resources, so a great tip in this respect is to minimize the use of counters in the performance monitor so as to enhance the Windows server while working on an SQL server database.
- Minimize the Audit Policy Events: Another similar tip to boost your performance on an SQL server in compliance with the Windows server is to minimize the use of Audit Policy Events because these events too utilize some server resources and by minimizing their use, you can enhance the overall server performance.
- Use “None” as the Performance Boost Option for Foreground Apps: By using “None” as the performance boost option, you choose to ensure that the background applications get the highest priority as compared to the foreground applications. For this, you need to double click on the Control Panel and choose the Performance Tab and select None under the Performance Box.
- Avoid Opening GL Screen Savers: For better optimization, you must also avoid opening GL screen savers wherever possible because these too consume a lot of resources available on the system.
- Disable Last Accessed Update for a File Data: A useful tip in this respect is to disable the last access update of a file data by running a specific command in the Run Box.
- Enhance the I/O Page Lock Limit: As an SQL server user you may also consider to enhance the I/O page lock limit at a maximum bytes value for boosting the overall performance.
- Use Frequently Used Protocol for Multiple Transport Protocols: Another smart tip to optimize Windows server to work on an SQL server database is to use frequently used protocol especially for multiple transport protocols. In fact, you can boost the overall performance by choosing the more frequently used protocol as a priority in the network.
- Choose Maximum Throughput Option for Network Applications: Lastly, try boosting your SQL performance by choosing the maximum Throughput for Network Applications, as by doing so Windows can allocate greater RAM for server than to the file cache. You can easily go to the Network Icon and double click it under the Control Panel to set this option. Then, click the Services Tab followed by Properties Option and choose the Maximize Throughput Option and OK Option. Make sure to Restart your computer.
SQL Crashes can happen anywhere, even in enterprise edition of SQL Server
Even if you are running the enterprise edition of SQL Server application, you can encounter a SQL crash. To avoid chances of data loss it is prudent to always keep a sql recovery tool like DataNumen SQL Recovery in the office. Next time you encounter a SQL crash, just run this powerful application extract all records from the compromised database file. The tool incidentally rather easy to use and can even work on virtual drives.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access recovery and sql recovery software products. For more information visit https://www.datanumen.com/