- 博客(1)
- 资源 (6)
- 收藏
- 关注
原创 Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)
问题: 正常情况下,执行Rebuild Index都会很快完成,可今天遇到Rebuild Index的Job一直Running。手动执行Rebuild,也一样失败,报“Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)”,如下图:解决:查看当前Running的SPID及SQL Text,特
2016-11-02 16:47:57 4274
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关注的人