보미네

Command prompt installation is supported in the following scenarios:

Upgrading from one SQL Server edition to another edition of SQL Server.

SQL Server Setup Control

/ACTION

Required

Required to indicate the installation workflow.

Supported values:

Upgrade

EditionUpgrade

The value EditionUpgrade is used to upgrade an existing edition of SQL Server 2014 to a different edition. For more information about the supported version and edition upgrades, see Supported Version and Edition Upgrades.

https://msdn.microsoft.com/en-us/library/ms144259(v=sql.120).aspx

http://optimizer.tistory.com/entry/%ED%8F%89%EA%B0%80-%EA%B8%B0%EA%B0%84%EC%9D%B4-%EB%A7%8C%EB%A3%8C%EB%90%9C-SQL-Server-%EC%97%85%EA%B7%B8%EB%A0%88%EC%9D%B4%EB%93%9C-%ED%95%98%EA%B8%B0

setup.exe /q /ACTION=editionupgrade /InstanceName=MSSQLSERVER /PID=<appropriatePid>/SkipRules= Engine_SqlEngineHealthCheck

평가기간이 끝난 경우 /SkipRules= Engine_SqlEngineHealthCheck 추가 

https://blog.brankovucinec.com/2014/07/23/upgrade-from-sql-server-2014-express-to-standard-edition/

sp_whoisactive2.txt

디스크 읽기 최대성능을 볼 때 쓸만함 

BACKUP DATABASE tt

TO DISK = 'NUL:'
,DISK   = 'NUL:'
,DISK   = 'NUL:'
,DISK   = 'NUL:'
,DISK   = 'NUL:'
,DISK   = 'NUL:'
,DISK   = 'NUL:'
,DISK   = 'NUL:'
 WITH NO_COMPRESSION
,BUFFERCOUNT = 2200

backup log tt to
disk ='NUL'
, disk = 'NUL'