SQLNexus and RML Utilities (ReadTrace) – SQL Server效能分析工具

SQLNexus and RML Utilities (ReadTrace) – SQL Server效能分析工具 軟體下載與安裝方法 0.SQLNexus and RML需要SQL Server DB(可以使用SQL Server Express) 1.RML Utilities (ReadTrace) Please refer this KB for detals on downloading ReadTrace RML Utilities for SQL Server (x86) – http://www.microsoft.com/downloads/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en RML Utilities for SQL Server (x64) – http://www.microsoft.com/downloads/details.aspx?FamilyId=B60CDFA3-732E-4347-9C06-2D1F1F84C342&displaylang=en   2.Report Viewer 不同版本SQL Nexus,需要不同版本的Report Viewer RML Utilities requires Report Viewer to…

0

What is ECMAScript ES (什麼是ECMAScript ES3,ES5)

What is ECMAScript ES (什麼是ECMAScript ES3,ES5) 1995年 Netscape Navigator網景的布蘭登·艾克開發的一種腳本語言的標準化規範;最初命名為Mocha,後來改名為LiveScript,一年後改名為JavaScript (PS.Javascript跟Java完全無關) ECMAScript 網景在1996將Javascript提交給ECMA International歐洲電腦製造商協會,進行標準化,確認出這版語言標準 ECMAScript 2 ECMAScript 3 (ES3) 1999年發布後就長達10年沒有變動,中間是個各大瀏覽器廠商進行自己的語言延伸 ECMAScript 4 由於關於語言的複雜性出現分歧,第4版本被放棄,其中的部分成為了第5版本及Harmony的基礎 ECMAScript 5 (ES5) 2009年,此時大部分開發者仍然寫的ES3風格的javascript 有一說法是2012年因為推動停止舊版IE支援,開發者才開始大量使用ES5 ES 5之前的協定稱為ES.Harmony後來又改為ECMAScript 2015(ES2015)   ECMAScript https://en.wikipedia.org/wiki/ECMAScript

0

Use the Maintenance Plan Wizard (使用維護計畫精靈)

Use the Maintenance Plan Wizard (使用維護計畫精靈) 1.使用SSMS連線到SQL Server,在SQL Server Instance>管理>維護計畫,按下右鍵,選擇[維護計畫精靈] 2.設定排程,建議在離峰時間執行,例如01:00,最少可以每周執行一次。   3.選擇需要定期執行的工作 如果您選擇了[重建索引],就不需要勾選[更新統計資料],因為REBUILD(重建索引)會一併更新統計資料   4.針對上一個步驟所選擇的項目,勾選您的資料庫 以下是[重建索引工作] 以下是[更新統計資料工作]     Reference: Use the Maintenance Plan Wizard (使用維護計畫精靈) https://docs.microsoft.com/en-us/sql/relational-databases/maintenance-plans/use-the-maintenance-plan-wizard?view=sql-server-2017  

0

Frequently Asked Questions for PSSDiag Collection (PSSDiag收集常見問題)

Frequently Asked Questions for PSSDiag Collection (PSSDiag收集常見問題) Q1.如果你的SQL Server是在Windows 2016環境,請先安裝.NET Framework 3.5 (include .NET 2.0 and 3.0),不然會出現錯誤,無法收集 Q2.如果出現這個錯誤 SQLDIAG There are no instances of version 13 on this computer Possible Cause: 錯誤的pssdiag.zip檔。(version 13=SQL2016, version 12=SQL2014, version 11=SQL2012) Answer 2:下載正確SQL版本的pssdiag.zip檔 或 Answer 3 :如果你的下載的版本正確 解法1: 修改pssdiag收集設定檔 F:\pssdiag\pssdiag.xml, 找到<Instance name=”*” user=”” windowsauth=”true” ssver=”13″> 把ssver=”13″改成ssver=”*” ,並且要指定Instance <Instance name=”MSSQLServer” user=””…

0

Windows Server Performance Tuning Guidelines

Windows Server Performance Tuning Guidelines   OS Documents Windows 2016 Performance Tuning Guidelines for Windows Server 2016 https://docs.microsoft.com/en-us/windows-server/administration/performance-tuning/ Windows 2012 R2 Performance Tuning Guidelines for Windows Server 2012 R2 https://www.microsoft.com/en-us/download/details.aspx?id=51960Performance Tuning Guidelines for Windows Server 2012 R2https://www.microsoft.com/en-us/download/details.aspx?id=51960Performance Tuning https://msdn.microsoft.com/en-us/library/windows/hardware/dn529133 Windows 2012 Performance Tuning Guidelines for Windows Server 2012 http://download.microsoft.com/download/0/0/B/00BE76AF-D340-4759-8ECD-C80BC53B6231/performance-tuning-guidelines-windows-server-2012.docx Windows 2008 R2 Performance Tuning Guidelines…

0

The distribution agent failed to create temporary files in xxx directory. System returned errorcode 5 散發代理程式建立暫存檔失敗

The distribution agent failed to create temporary files in … directory. System returned errorcode 5 散發代理程式建立暫存檔失敗 Error: 錯誤訊息 當你修改了散發代理程式的處理帳號(執行帳號) When you change the Agent process account in the Distribution Agent Security  The distribution agent failed to create temporary files in ‘C:\Program Files\Microsoft SQL Server\110\COM’ directory. System returned errorcode 5 Cause: 原因 新的執行帳號,對C:\Program Files\Microsoft SQL Server\110\COM…

0

Replication Log Reader Agent Error “The principal dbo does not exist” 複寫記錄讀取器代理程式出現主體dbo不存在

Replication Log Reader Agent Error “The principal dbo does not exist” 設定SQL Server Replication複寫時,Log Reader Agent複寫記錄讀取器代理程式出現以下錯誤 Error: 錯誤訊息 Error messages: The process could not execute ‘sp_replcmds’ on ‘SQLPublisher’. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be…

0

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