Browse by Tags

SQL Server 2005 and Disk drive allocation unit size to 64K - any benefit or performance?

Published 28 April 8 3:1 AM | SSQA.net

You may be aware that or seen within your Database platform about slower disk performance than expect having multiple disks in Windows Server 2003 environment when you use a hardware-based redundant array of independent disks (RAID) or a software-based...

Filed under: sql server, performance, microsoft, technet, i/o, article, disk, best practices, monitoring, deployment, layout

SQL Server Clustering get pre-installation information and choose the best practices for your environment

Published 27 March 8 3:40 AM | SSQA.net

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist

Vote now: Index defragmentation best practices for SQL Server 2005 documentation - feedback received from Microsoft

Published 4 January 8 5:35 PM | SSQA.net

May 25 2007- From the snippet of Tibor Karaszi , SQL Server MVP I have raised a feedback form on Connect.Microsoft website to get newer version (SQL Server 2005) about Index Defragmentation Best practices information. Vote your interest to get newer documentation...

Filed under: defragmentation, sql server, indexes, microsoft, i/o, best practices, feedback, sql express, connect