- 博客(2)
- 资源 (6)
- 收藏
- 关注
RSS订阅原创 通过sys.dm_exec_requests看index缺失情况
查看耗时等信息： SELECT der.session_id , --internal identifier for the running session der.status , --determines if the query is active or waiting der.start_time , --gives you an idea when the query
2013-01-30 17:21:43
1798
原创 如何确保备份有效
备份时使用WITH CHECKSUM,如下所示，可以检查DB的Page是否有损坏。没有损坏就可以备份成功。BACKUP DATABASE TO DISK= '.bak' WITH CHECKSUM GO 如果损坏，则报如下信息，备份不成功： Msg 824, Level 24, State 2, Line 1 SQL Server detected a logical cons
2013-01-30 17:11:49
963
transaction-log-management
This covers performing transaction log backup and restore, monitoring and managing log growth, including quick diagnosis of the causes of rapid growth, and optimizing log architecture to maximize log throughput and availability.
2013-06-06
How to boost DB server's performance
From this file,you can learn some tips of SQL scricp,useful DBCC commands etc. Besides, you can learn how to use SQL Server Profiler,DTA and so forth.
2008-09-25
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人