Guideline for SQL Server configuration, installation and database creation

Guideline for SQL Server configuration, installation and database creation 1.考慮將Windows電源選項(Power Options)調整為高性能(High Performance) 電源選項預設為平衡,系統會動態調整CPU性能,負載大的時候也會自動提高CPU性能,依照KB的描述若有遇到性能問題,首先考慮更新BIOS與Windows hotfix,另一個選擇,則是直接將電源選項改為高性能(High Performance),但此時當系統平常使用時,會增加不必要耗電量。 Slow Performance on Windows Server when using the “Balanced” Power Plan https://support.microsoft.com/en-us/help/2207548/slow-performance-on-windows-server-when-using-the-balanced-power-plan To change a power plan: 1. Click on Start and then Control Panel.  2. From the list of displayed item under Control Panel click on Power Options, which takes you to Select a power plan page. If you…

0

SQL Server Reporting Services failed to start (Reporting Services啟動失敗)

SQL Server Reporting Services failed to start Reporting Services啟動失敗 Problem 問題: The SQL Server Reporting Services (MSSQLSERVER) service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.   Resolution 解決方法: 有三種解決方法,以下是我常用的一種 To increase the default service time-out, follow these steps: Click…

0

Cluster service verification failed

Cluster service verification failed 如果在Windows 2012 R2 failover cluster上安裝SQL Server 2008 R2 cluster將會遇到此錯誤 Rule “Cluster service verification” failed.   解決方法是 事先啟用 Failover Cluster Automation Server功能 Using SQL Server in Windows 8 and later versions of Windows operating system https://support.microsoft.com/en-us/kb/2681562 Resolution To resolve this issue, do one of the following: Enable the Failover Cluster Automation Server…

0