|
|
09 2011 档案
摘要：List of Threshold Value for SQL Server Performance CountersBy : Kasim Wirama, MCDBA, MCITPMonitoring database performance is proactive task that a DBA should do. Possible bottleneck for SQL Server is memory, processor, I/O subsystem, tempdb database, and locking. For SQL Server specifics, below list
阅读全文
摘要：原文是E文，做一下翻译并且提取一些重要的思路。1.定义业务规格What are your most critical business processes and how often are they processed (e.g. number of sales activities per day, number of client requests per day, etc.)最重要的业务流程是什么，使用频率如何What is regarded (required) as acceptable response times from the online application? How
阅读全文
摘要：聚集索引：Clustered Indexes in SQL Server: Things You Need to Know- 08 Dec 2005数据库压力测试：How to Set Up a SQL Server Stress Test Environment in 8 Steps: Lessons From the Field- 01 Dec 2005数据库监控：SQL Server Monitoring in 8 Steps: Lessons From the Field- 02 Aug 2005基线tips：10 Baselining Tips for SQL Server: Les
阅读全文
摘要：Downloading and Configuring SQLIOSQLIO Video Tutorial： http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO[Download SQLIO from Microsoft]Notice that I said SQLIO, not SQLIOSIM. Experienced database administrators will often direct you to SQLIOSIM because it's easier to use and mimic
阅读全文
摘要：Stress Testing Your SQL Server Databases - A Systematic ApproachStress Testing your SQL Server environments is a practice that can yield great benefits. Stress Testing can be used for performance tuning, to uncover bottlenecks, and for capacity planning among other things. In this article we will us
阅读全文
摘要：下面给出了限制优化时间和事件数的建议：对于单个查询和小型工作负荷（少于 100 个事件），请指定无限制的优化时间。如果指定不限制优化时间，数据库引擎优化顾问将给出最佳建议，并且在大多数情况下，优化会在相对较短的时间内完成。对于大型工作负荷（多于 100 个事件），请考虑以下方案，其优先级以其列出顺序为准。首先考虑方案 1 到方案 3，最后考虑方案 (4)。如果用户在时间上有约束，请限制优化时间。如果优化固定数量的事件就足够了（例如，前 10,000 个事件可以代表其余工作负荷），请使用 dta 命令行实用工具，并通过 –n 参数指定事件数。如果使用的是 dta 命令行实用工具，并希望进一步限制
阅读全文
|
