摘要:
背景: 磁盘空间不足原因: 日志文件过大,再次需要分配磁盘空间的时候,磁盘空间不足。业务停止,生产数据库瘫痪解决办法: dbcc shrinkfile(日志文件名,选项) 具体见联机手册结果: 删除磁盘不必要的空间,清空日志。解决当前状态 阅读全文
摘要:
背景: 磁盘空间不足原因: 日志文件过大,再次需要分配磁盘空间的时候,磁盘空间不足。业务停止,生产数据库瘫痪解决办法: dbcc shrinkfile(日志文件名,选项) 具体见联机手册结果: 删除磁盘不必要的空间,清空日志。解决当前状态 阅读全文
摘要:
Creating a Performance Baseline - Part 1You'll often hear that you should monitor the performance of SQL Server. You may read a little about performance monitoring, and you may turn on a few counters or perform a query against a dynamic management view that you know about. But, you may still won 阅读全文
|