Fanr

摘要： 背景： 磁盘空间不足原因： 日志文件过大，再次需要分配磁盘空间的时候，磁盘空间不足。业务停止，生产数据库瘫痪解决办法： 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 阅读全文