February 24
今天有夠倒楣 早上摔VIAO的滑鼠 晚上摔iPhone一個鍵不能用 Today is not my day!!
February 21
終於要做資料庫整合了,也列入本年的MBO,目標減降25台,這機會會很難得的,希望加油囉!!
| · Are all necessary backups being made that should be made (full, differential, log, etc)
|
| · Have the backups been properly saved to tape or other archival storage
|
| · Did all scheduled jobs (of any type) succeed
|
|
|
| · Did any scheduled jobs conflict with each other enough to cause performance issues
|
| · Are there any jobs that have run much longer than expected
|
| · Are all databases being reindexed periodically
|
|
| · Are all databases being checked for integrity periodically
|
| · Are there any important errors in the SQL Server error log, and the OS event logs
|
| · Does the server have at least 20% free disk space
|
|
| · Do any of the system or user databases (or logs) have excess empty space
|
| · Are old backups being removed as appropriate
|
|
| · Identify significant blockingissues
|
|
|
|
| · Identifydeadlockissues
|
|
|
|
|
| · Identify extreme performance counter activity
|
|
| · Identify extreme hardware bottlenecks (cpu, memory, I/O, network)
|
| · If a cluster, has there been a failover ( I manually check this using Cluster Administrator) |
請大家參考囉!!
原處:http://sql-server-performance.com/Community/blogs/brad/archive/2007/07/30/a-sql-server-health-check.aspx
February 10
2/24 準備去上CISSP的課!!充實自己囉!!
Tools 
