Browse by Tags

• benchmarking
• dba
• disk space
• hardware
• indexes
• monitoring
• optimization
• performance
• raid
• reindexing
• san
• scsi
• sorting
• sql server

Is RAID5 better for performance when SQL Server Clustering and SAN is involved?
22 January 08 11:28 PM | SQL Master | 8 Comments   

One of the recent usergroup meeting brought an interesting question that "what type of hardware I need for a RAID-5 Shared Array for SQL Server Cluster"? By default RAID5 hardware controller is best to hold as not to go with software RAID5 as it will Read More...

Filed under: performance, sql server, raid, hardware, disks, best practice, monitoring, benchmarking, san, scsi

Disk Space Requirements for Index DDL Operations
28 September 07 06:38 AM | SQL Master | 3 Comments   

Are you watching your disk space during the indexes operations where these database objects are stored? Recently I was stumped on a database that is only 5GB had reindexing process failure due to 10% of disk free space was available. For your information Read More...

Filed under: performance, sql server, indexes, optimization, dba, hardware, disks, best practice, reindexing, disk space, sorting