|
摘要：
A Performance Troubleshooting Methodology for SQL Server28 September 2011byJonathan KehayiasWhenhealing a sickSQL Server, you must forget the idea that therecould ever bea simple correspondence between symptom and disease: The art of troubleshooting is much more the art of discovering, and assemblin 阅读全文
摘要：
今天在 相同环境测试 2000 和 2008 性能让我意外的是 2008 明显比2000 慢很多测试sql：SET STATISTICS IO ONSET STATISTICS TIME ON SELECT COUNT(1) FROM dbo.tbtext a INNER LOOP JOIN dbo.tbtext b ON a.id = b.id option (maxdop 1)SET STATISTICS IO OffSET STATISTICS TIME Off 表结构：CREATE TABLE [dbo].[tbtext]( [id] [int] IDENTI... 阅读全文
|
