承修's profile~真相只有一個!!那就是唯一不變的事實!!~南無...PhotosBlogListsMore ![]() | Help |
|
September 28 How to Script User and Role ObjectSeptember 27 治頭痛偏方September 26 工作監視 SQL Server 2000 效能與活動September 25 After upgrade sql 2008
SQL CLUSTER DEPENCESQL Server Agent { SQL Server Agent }
SQL Server Fulltext { Microsoft Search Service Instance } +(1)-----Depends On-> SQL Server { Instance Name for named instances } +(2)-----Depends On-> SQL network name (Virtual Server Name) { Network Name } +(3)-----Depends On-> SQL IP address1 (Virtual Server Name) { IP address } +(2)-----Depends On-> Disk Z: { Physical Disk }
September 22 EVENT MGR 須符合程序面 A.11.1控制資訊的存取 l 既有之存取控制之政策(相關準、細則)--11.1.1 l 書面紀錄使用者註冊帳號之過程,如:註冊及註銷之相關異動紀錄--11.1.1 技術面 以下以Event Manager檢驗如上之作業 A.11.2使用者存取管理(確保經授權使用者對資訊系統的存取與防止未經授權的存取) l 可調閱使用者註冊之過程,如:註冊及註銷之相關異動紀錄(須與書面紀錄相勾稽)--11.2.1 l 特權(高權限)授權紀錄--11.2.2 l 使用者存取權限之ACL--11.2.4 A.11.5作業系統存取控制(防止作業系統遭未經授權的存取)等事件之偵測,進行分析與告警;進而訂定標準作業手冊,達到外稽與內控及管理資訊安全的要求事項 l 紀錄未經授權企圖存取拒絕之紀錄--11.5.1, l 鑑別人員或應用程式之帳號使用--11.5.2 A.10.10偵測未經授權的資訊處理活動 l 比對作業表單與ACL之吻合性 l 監視經授權企圖存取拒絕之紀錄--10.10.2
September 20 the differences between using multiple instances and using multiple virtual machines for consolidation.出處:http://www.microsoft.com/taiwan/sql2008/solutions/server-consolidation.aspx
伺服器整合白皮書
September 12 SQL SERVER DOCSeptember 11 測試 DISK IO C:\Program Files\SQLIO 詳閱 Readme.txt
1.Performance Monitor 可調整 SQLIO 參數,
2.觀察 Performance Counter 以模擬各種狀況下之系統呈現
September 09 資料庫轉移確認事項偵測ASP 原始程式碼的SQL injectionMicrosoft Source Code Analyzer for SQL injection
September 04 Automating Performance Monitor Statistics Collection for SQL Server and WindowsAutomating Performance Monitor Statistics Collection for SQL Server and Windows Written By: Ranga Narasimhan Problem Solution Logman is the command line utility for Perfmon. Thru logman, it is easy to automate perfmon data collection which I will show you below. Data Collection First, we need to identify what Objects and Counters we need. From my experience, the below counters are good from a SQL Server point of view. We can automate creating one perfmon log file for each day. Then move the old files to a network share for later reference. Cut and paste the contents below to a file name "SQL2005BaselineCounters.config" and save the file in "E:\perflogs". You can choose any local drive/folder, make sure there is enough space in it. Try not to use the same storage that your SQL Server databases use, because this can slow down your I/O throughput. Note in the below code I am collecting SQL Server data for an instance named "MSSQL$DEV". This will need to be replaced for your server. If you just have a default instance this will just be "SQLServer"
Next step is to create a counter log in perfmon which will use the above counters. From a command prompt, execute the statement below on your SQL Server box.
You will be prompted for the password
This will create a new counter log named "SQL2005Perf". To verify this, open perfmon and click "counter logs" under Performance logs and alerts.
Here is the notes for each option used above:
You can manually start and stop the above counter logs with below commands:
To get a list of all your counter logs you can run this command.
Automate Data Collection It would be nice if we have performance data for each day. This can be done by stopping the counter log at 11:59:59 PM and again starting it at 12:00:01 AM daily. Once you stop the counter log the log file is closed and starting the counter log creates a new log file. Lets create a scheduled task which will do this. Lets first create a batch file “StopCopyStart.bat” that will be executed by the scheduled task. Copy the contents below and save it in the folder “E:\perflogs”. Make sure to change the “Servername”, “SourceServerName” to match your servers.
A new scheduled task with name "Stop Copy And Start SQL2005Perf Perfmon Counter Log" will now be created. From the command prompt type "schtasks", this will list all the scheduled tasks.
Next Steps
經驗法失靈!看不見的5%經驗法失靈!看不見的5%何時,我們的世界開始被「百年難得一見」包圍?難得一見的雨量、天候異常、天災人禍……密集出現。我們該怎麼辦?求天告神?還是置之不理?反正,一切都是命!現在,告訴你,透過學習,你可以和那不可測的五%相處,擁有掌控它的能力! 巨人一夕倒下,你有料到嗎?2008年9月,雷曼兄弟破產,全球股市在10 週後,市值下跌超過50%,35兆美元人間蒸發。(攝影者.翁挺耀) 今年一月一日,有想過達賴喇嘛今年會來台灣的人請舉手。 一位連動債受災戶感嘆回憶,當時他曾經問理專:「連動債最大的風險是什麼?」理專回答:「銀行倒閉。」而雷曼兄弟有一百五十八年歷史,經歷過無數金融風暴,都安然無恙,因此,他自己推衍出:「雷曼倒閉風險等於零。」於是,投入資金。 為什麼人會那麼容易忽略、漠視那五%,著名的法國人類學大師李維史陀(Claude L炝i-Strauss)說:「人類是喜歡穩定和循環的動物,不喜歡擺盪。」人有日出而作、日落而息的慣性,當慣性被打破,沒有多久,就會恢復原來的運行 模式。而那不常出現的五%,就容易被忽略掉,因為人類喜歡依照經驗法則來生活。那九五%,就是依我們的習慣,所形成的「舒適圈」。 曾任職證券公司、當過外匯交易員,今年三月出版《空手的勇氣》的黃國華,在博客來網站上的心得,強調我們要用「保險」的機制去預防「機率很低但傷害很大」的那些「黑天鵝效應」,來避免不可測的風險。 但結果是,六、七百億元時「不敢買」,兩千億時「勇敢進場」。這種操作上的謬誤,不斷發生。 因為這是一個變動、不斷修正的新世界,未來的世界不再存在假設模型與過去的經驗值裡,就好像股市、景氣反轉速度加速一樣,你必須很有彈性,隨時有應變能力。 *巨人一夕倒下,你有料到嗎? 送給孩子五把通往未來的鑰匙 文/翁嘉伶 園長
|
||||||||||||||||||||||||||||||||||||||||||||||
|
|