Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Move Primary Key to File Group? Expand / Collapse
Author
Message
Posted Monday, March 11, 2013 10:30 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 11:48 AM
Points: 17,948, Visits: 15,944
Lynn Pettis (3/10/2013)
It is possible that to improve system performance, you could more your nonclustered indexes to other file groups and have this file groups on separate spindles. This could allow for parallel access between the NCI and the CI possibly improving performance for bookmark lookups. Also, if the NCI are covering indexes and are on separate spindle(s), this would reduce reads from the file group and disks where the CI reside.

All of this could help increase performance. YMMV, so this needs to be tested completely in a test environment before being implemented in production.


Exactly. It all depends on the environment, data access patterns, and hardware. The important thing is to test, test, and test.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1429388
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse