|
摘要：
以下是一些sql server的DBCC命令，可以在优化 sql server时使用。1． DBCC CacheStats：显示存在于当前 buffer Cache 中的对象的信息，例如 ：hit rates,编译的对象和执行计划例：DBCC CACHESTATS执行结果（缩略）Object Name Hit Ratio-------------------------Proc0.86420054765378507Prepared0.99988494930394334Adhoc 0.93237136647793051ReplProc0.0Trigger 0.99843452831887947C 阅读全文
摘要：
Detect CPU Bottleneck in SQL ServerBy : Kasim Wirama, MCDBAWhen you have your database server experiencing a problem, there are many possibilities here, such as CPU, memory, hard disk or database configuration itself. There should be a systematic way to trouble shooting performance problem in SQL Se 阅读全文
摘要：
Detecting and Resolving I/O BottleneckBy : Kasim Wirama, MCDBAI/O subsystem is one of critical component in SQL Server. I/O subsystem is used when SQL Server moves page between memory and I/O subsystem. With intensive activity of DML and DDL, SQL Server generates significant log entries and to tempd 阅读全文
摘要：
Detect Memory Bottleneck in SQL ServerBy : Kasim Wirama, MCDBAThis article, I would like to give information about memory bottleneck at SQL Server. The easiest way to know whether your SQL Server undergoes memory bottleneck is by looking at Task Manager, tab Performance, Physical Memory section. Com 阅读全文
|
