SQL & Hardware
文章平均质量分 66
envykok
这个作者很懒,什么都没留下…
展开
-
Analyzing Disk Capacity for SQL Server
<br />http://www.sqlservercentral.com/articles/Administration/analyzingdiskcapacityforsqlserver/2467/By Arindam Banerjee, 2006/07/04 <br />Setting up a new SQL box: Analyzing Disk storage capacity<br />The important places to look for considering the capac转载 2010-12-18 23:48:00 · 157 阅读 · 0 评论 -
Microsoft SQL Server identify I/O bottlenecks
<br />http://www.sqlservercentral.com/blogs/sql_performance/archive/2010/03/15/microsoft-sql-server-identify-i-o-bottlenecks.aspx<br />You can also identify I/O bottlenecks by examining the latch waits. These latch waits account for the physical I/O waits转载 2010-12-19 13:34:00 · 188 阅读 · 0 评论 -
Analyzing Memory Requirements for SQL Server
<br />http://www.sqlservercentral.com/articles/Performance+Tuning/analyzingmemoryrequirementsforsqlserver/2498/<br /> <br />In my previous article I had talked about analyzing disk capacity for a SQL Server box. In this article, we will look at memory requ转载 2010-12-18 23:43:00 · 165 阅读 · 0 评论 -
Optimizing SQL Server Performance Using Files and Filegroups
<br />http://www.sql-server-performance.com/articles/per/optimize_filegroup_performance_p1.aspxBy : Alexander Chigrik<br />Jan 31, 2003 <br /><br />There are no devices or segments in SQL Server 7.0 and SQL Server 2000, as there were in SQL Server 6.5. Now转载 2010-12-19 02:08:00 · 195 阅读 · 0 评论 -
SQL Server and Memory
For snapshot or transactional publications, articles can be dropped with no special considerations prior to subscriptions being created. If an article is dropped after one or more subscriptions is created, the subscriptions must be dropped, recreated, and原创 2010-12-19 02:23:00 · 153 阅读 · 0 评论