摘要：
Prefetch is a mechanism with which SQL Server can fire up many I/O requests in parallel for Nested Loop join.The SAN administrator says your data volu... 阅读全文
摘要：
IntroductionPrefetching is often ignored by developers and DBAs when they are analyzing performance problems. After you’ve read this article I hope yo... 阅读全文
摘要：
Balancing CPU and I/O throughput is essential to achieve good overall performance and to maximize hardware utilization. SQL Server includes two asynch... 阅读全文
摘要：
Reading Pageshttp://technet.microsoft.com/en-us/library/ms191475(v=sql.105).aspxHeap Structureshttp://technet.microsoft.com/en-us/library/ms188270(v=s... 阅读全文
摘要：
Create function to check SQL instance CPU loadcreate function check_cpu_load ()returns tableasreturn(SELECT SQLProcessUtilization, 100 - S... 阅读全文