Category: Servers

Tweaking Windows File Servers and Filesystem Performance
article #1319, updated 94 days ago

Some interesting items here for overall filesystem performance:

https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/role/file-server/

Categories:      

==============

Simple Microsoft SQL performance gains
article #1256, updated 128 days ago

Open up your SQL server instance in the Studio. Go to the Properties of your instance.

Under Memory, you will see a minimum and a maximum. Set the minimum to 1024 (MB) or 2048. Reserve 4 gigabytes RAM minimum for the OS, add some more for anything else running on it, then use the rest as your maximum memory usage setting.

Also under Memory, you will see “Minimum memory per query”. Default is 1024. Set this to 2048.

Then under Processors, check “Boost SQL Server priority”.

And click OK.

Some info here:

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-2017#max_server_memory

Categories:      

==============

Rename desktops in Windows domain from command line
article #31, updated 355 days ago

The simplest appears to be thus:

wmic computersystem where caption='oldcomputername' rename newcomputername

If it is run from an administrative CMD and the machine is in good talking relationship with its domain controller, the PC and also AD rename will complete. If either prerequisite is not met, the rename will fail. A non-admin attempt fails with code 5, DC availability fails with 1355.

There is also tool, part of the 2003 server reskit and included later on, which can do the rename of a desktop from a domain controller:

NETDOM RENAMECOMPUTER OLDNAME /newname:NEWNAME /userd:domain\domainadmin /passwordd:password /force /reboot:0

It causes a reboot of the target machine. /reboot:0 means no delay; the number is in seconds.

Categories:      

==============

High Memory Use on Servers by NTFS Metafiles
article #1199, updated 533 days ago

Great info here:

http://woshub.com/fixing-high-memory-usage-by-metafile-on-windows-server-2008-r2/

using this for investigation:

https://technet.microsoft.com/en-us/library/ff700229.aspx

and this service for cure:

http://www.microsoft.com/en-us/download/details.aspx?id=9258

Categories:      

==============

Open source LAN-local search
article #1189, updated 563 days ago

There are several tools fitting this general description, but this writer has only found one turnkey installable. This is Yacy:

yacy.net

Very fast, quite straightforward to set up and configure (though you’ll learn a thing or two if you’ve never thought about search very much!), almost not at all counterintuitive. It can be easily set up as either a LAN-local search server or part of its distributed WWW network.

There is a runner up, Open Search Server:

www.opensearchserver.com

If its documentation were remotely adequate, it might be comparable, but sadly, not.

Categories:      

==============

Migrate Windows file shares between servers, with permissions
article #1168, updated 606 days ago

Good article, sent by the remarkable Zach Hogan:

https://sysblogging.com/2015/12/29/how-to-migrate-windows-file-server-shares-with-ntfs-permissions/

Categories:      

==============

GUI SFTP/SCP (SSH File Transfer) Server for Windows
article #1166, updated 620 days ago

SFTP, also called SCP, is not, accurately speaking, FTP. SFTP is “SSH File Transfer”, transfer of files over the SSH protocol, and not the FTP protocol. The FTP protocol has its own excellent secure (FTPS) capabilities, FileZilla being a recommended graphical FTP server for Windows; but GUI servers for SSH are much harder to find. Happily, here is one:

https://www.solarwinds.com/free-tools/free-sftp-server/registration?program=961&c=70150000000FJX0&CMP=BIZ-TAD-PCWDLD-SW_WW_X_PP_PPD_FT_EN_TOPFT_SW-SFTP-X_X_X_X-X

Categories:      

==============

Current version of PHP and other items on CentOS and RHEL
article #850, updated 690 days ago

Here are two very helpful sources. For many general things, the EPEL repository:

http://fedoraproject.org/wiki/EPEL

and for PHP and other server-specifics, current versions and others more recent than the OSes supply by themselves, Remi:

http://rpms.remirepo.net/

Categories:      

==============

When Group Policy Templates Are Corrupt
article #1099, updated 796 days ago

An elegant solution from here:

https://social.technet.microsoft.com/Forums/systemcenter/en-US/e266d1eb-81ca-4084-8b3b-70f7c6904047/problem-with-inetresadmx?forum=winserverGP

Just go here:

https://www.microsoft.com/en-us/download/details.aspx?id=6243

and download the current versions of all of the templates (the above is for 2008R2, here’s to hoping Microsoft makes them available for all server versions), and replace them.

Categories:      

==============

Installing the GUI onto Windows Server 2012 Core
article #853, updated 813 days ago

The indefatigable Matt Quick provides thus:

http://prajwaldesai.com/switching-between-gui-and-server-core-in-windows-server-2012/

Categories: