2014年5月23日
Prefetch – Querying at the speed of SAN
摘要： 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... 阅读全文
posted @ 2014-05-23 02:03 princessd8251 阅读(305) 评论(0) 推荐(0)
SQL Server Prefetch and Query Performance
摘要： IntroductionPrefetching is often ignored by developers and DBAs when they are analyzing performance problems. After you’ve read this article I hope yo... 阅读全文
posted @ 2014-05-23 02:01 princessd8251 阅读(214) 评论(0) 推荐(0)
Sequential Read Ahead For SQL Server
摘要： Balancing CPU and I/O throughput is essential to achieve good overall performance and to maximize hardware utilization. SQL Server includes two asynch... 阅读全文
posted @ 2014-05-23 01:45 princessd8251 阅读(287) 评论(0) 推荐(0)
Links
摘要： Reading Pageshttp://technet.microsoft.com/en-us/library/ms191475(v=sql.105).aspxHeap Structureshttp://technet.microsoft.com/en-us/library/ms188270(v=s... 阅读全文
posted @ 2014-05-23 01:22 princessd8251 阅读(164) 评论(0) 推荐(0)
Useful query
摘要： Create function to check SQL instance CPU loadcreate function check_cpu_load ()returns tableasreturn(SELECT SQLProcessUtilization, 100 - S... 阅读全文
posted @ 2014-05-23 01:08 princessd8251 阅读(171) 评论(0) 推荐(0)