HP IO Accelerator for BladeSystem c-Class Podręcznik Użytkownika Pobierz pdf (Strona 12)

Architectural scenarios 12

• Determine the maximum size of the tempdb file you need and then create each tempdb data file to

be the same size.

• Turn off auto-grow on the tempdb file.

For more detailed information, see the Microsoft® website

(http://support.microsoft.com/default.aspx?scid=kb;en-us;328551).

Index considerations

Indexes help retrieve data from the tables, so consider moving all indexes to a separate file group and

then placing the file group on an IO Accelerator. For more information, see the following article on

creating file groups for indexes (http://deepakrangarajan.blogspot.com/2008/12/moving-index-to-

seperate-filegroup.html).

HP recommends that you delete indexes that are not being used. They cause unnecessary I/O overhead.

For more information, see the following article on detecting which indexes are being used by the

database (http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/04/20/how-can-you-tell-if-

an-index-is-being-used.aspx).

Frequently accessed tables

Placing frequently accessed tables in individual file groups and then placing the file groups on your IO

Accelerator can greatly improve performance. To identify the most frequently accessed tables:

1. Run a profile trace.

2. Review the stored procedures and statements that run most frequently.

Optimize the tables accessed by these stored procedures and statements.

Large tables

Large tables create an I/O bottleneck for most activities. Index maintenance and reads on large tables

can be time-consuming. To relieve stress, move large tables to a separate file group and then place the

file group on IO Accelerators.

For a method of listing all the tables and sizes, see the following article

(http://searchsqlserver.techtarget.com/tip/Find-size-of-SQL-Server-tables-and-other-objects-with-stored-

procedure ).

Log files

Log files consume a lot of write performance. Every committed transaction results in date being written to

the log file. IO Accelerators improve sequential write performance compared to traditional media, so

putting log files on IO Accelerators improves the speeds of committing data transactions.

Partition tables

Microsoft® added partition tables to SQL Server 2005 and enhanced them in SQL Server 2008. This

feature enables you to split the data in one large table into many small tables based on certain criteria.

For example, you can split order data, based on data ranges. For example, you can devote one table to

1 2 ... 7 8 9 10 11 12 13 14

Brak uwag

HP IO Accelerator for BladeSystem c-Class Podręcznik Użytkownika Strona 12