Browse by Tags

• 2005
• baseline
• benchmarking
• cache
• configuration
• deployment
• disk space
• disks
• downloads
• hardware
• iometer
• memory
• monitoring
• performance
• san
• scsi
• sql server
• sqlio
• system
• tools
• troubleshoot

SQL Server Memory - what's your method on Configuration and Troubleshooting Issues
01 April 08 02:49 AM | SQL Master | 5 Comments   

Memory - an important aspect of system performance within a RDBMS platform, not specific to a database product or application. Coming to Microsoft related products such as Windows Server and SQL Server so on, various resources available on web such as Read More...

Filed under: performance, sql server, cache, memory, troubleshoot, raid, hardware, best practice, disk space, monitoring, system, baseline, configuration

Best way to deploy SQL Server 2005 with SAN
28 January 08 01:01 AM | SQL Master | 6 Comments   

If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct Read More...

Filed under: performance, sql server, sqlio, raid, hardware, best practice, downloads, benchmarking, san, iometer, configuration, tools, 2005, deployment

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