Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Performance Tuning, Hardware Rss

   Items 1 to 13 of 13   
 

Benchmark SQL Server Disk Latency

Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking...  Read more...
By jsterrett 2013/03/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,446 reads

Running SQLIO with Multiple Files

Not exactly groundbreaking information, but were you aware that you can run SQLIO with multiple files?  Until a couple months...  Read more...
By StrateSQL 2013/02/21 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,454 reads

Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2

Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in...  Read more...
By GlennBerry 2011/01/24 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,218 reads

EVA Partition Alignment

Partition alignment is a well documented best practice, but does it have any benefit on an HP EVA?  Read more...
By Additional Articles 2009/09/09 | Source: SQL-Server-Pro | Category: hardware
Rating:  Rate this |   Briefcase | 2,506 reads

Disk Partitiona Alignment Best Practices for SQL Server

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.  Read more...
By Additional Articles 2009/08/18 | Source: Microsoft MSDN | Category: performance tuning
Rating:  Rate this |   Briefcase | 3,043 reads

Understanding File System IO, Lessons Learned From SQL Server

I do more than just SQL Server. I enjoy programming. In my former life I have worked with C/C++ and Assembler. I also spent quite a bit of time in Visual Basic. I loved it for prototyping and what we now call RAD development efforts.  Read more...
By Wesley Brown 2009/06/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,016 reads

Deployments and Tests in an iSCSI SAN

This paper describes the deployment and testing results of SQL Server 2005 using the Microsoft iSCSI Initiator with an EqualLogic iSCSI SAN. It helps you understand best practices and the benefits of using an iSCSI SAN with SQL Server 2005.  Read more...
By Additional Articles 2008/02/08 | Source: TechNet Blogs | Category: hardware
Rating:  Rate this |   Briefcase | 1,899 reads

Which is Faster: SAN or Directly-Attached Storage?

Or should I place my database files on SAN or directly-attached storage? This is a frequently asked question. It comes up repeatedly in public newsgroups, email discussion lists, and private meetings with customers who are concerned with database performance.  Read more...
By Additional Articles 2008/02/05 | Source: SQLTeam.com | Category: hardware
Rating:  Rate this |   Briefcase | 6,301 reads

Predeployment I/O Best Practices

The I/O system is important to the performance of SQL Server. When configuring a new server for SQL Server or when adding or modifying the disk configuration of an existing system, it is good practice to determine the capacity of the I/O subsystem prior to deploying SQL Server. This white paper discusses validating and determining the capacity of an I/O subsystem. A number of tools are available for performing this type of testing. This white paper focuses on the SQLIO.exe tool, but also compares all available tools. It also covers basic I/O configuration best practices for SQL Server 2005.  Read more...
By Additional Articles 2008/01/04 | Source: TechNet Blogs | Category: sql server 2005
Rating:  Rate this |   Briefcase | 2,678 reads

RAID Scaling Charts, Part 3: 4-128 kB Stripes Compared

This is the third article that deals with analyzing the various possibilities involving various RAID setups and differing numbers of hard drives. We used the same hard disks again here: eight Samsung HM321KJ SATA/300 drives powered all of the possible RAID 0, RAID 5 and RAID 6 setups, with from three to as many as eight hard drives configured to use stripe sizes of 4 to 128 kB.  Read more...
By Additional Articles 2007/12/19 | Source: Tom's Hardware | Category: hardware
Rating:  Rate this |   Briefcase | 2,011 reads

RAID Scaling Charts, Part 2: RAID 5 And RAID 6

For our RAID tests, we once again use Samsung HM321KJ SATA/300 drives. This time, we benchmarked RAID 5 and RAID 6 setups with three to eight hard drives.  Read more...
By Additional Articles 2007/12/18 | Source: Tom's Hardware | Category: hardware
Rating:  Rate this |   Briefcase | 2,399 reads

RAID Scaling Charts, Part 1

Most enthusiast and mainstream users would consider setting up a RAID array mainly for performance reasons - few really care about data safety. For this reason, the majority of arrays installed consists of only two drives, which run a simple RAID 0 stripe set. Haven't you ever asked yourself how these RAID arrays scale as you increase the number of hard drives?  Read more...
By Additional Articles 2007/12/17 | Source: Tom's Hardware | Category: hardware
Rating:  Rate this |   Briefcase | 2,546 reads

Optimize SAN setup for improved SQL Server performance

SAN setup for improved SQL Server performance and scalability means optimizing disk system design. Consider bandwidth, RAID and data consistency.  Read more...
By 2007/10/12 | Source: SearchSQLServer | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 3,670 reads
   Items 1 to 13 of 13   
 
Tags
blogs (4)    
hp eva (1)    
i/o (1)    
partition alignment (1)    
san (1)    
sql server 2005 (1)    
storage management (1)