Welcome to Sign in | Help

Re: Tabela cu foarte multe inregistrari

  •  10-19-2009, 8:04 PM

    Re: Tabela cu foarte multe inregistrari

    Eu aş sugera să evaluaţi şi soluţii bazate pe striping (RAID-0), adică să faceţi din mai multe discuri fizice un singur disc logic.

    Citat din Designing Partitions to Improve Query Performance:
    "It may be tempting to map your partitions to filegroups, each accessing a different physical disk drive, in order to improve I/O performance. When SQL Server performs data sorting for I/O operations, it sorts the data first by partition. Under this scenario, SQL Server accesses one drive at a time, and this might reduce performance. A better solution in terms of performance is to stripe the data files of your partitions across more than one disk by setting up a RAID. In this way, although SQL Server still sorts data by partition, it can access all the drives of each partition at the same time. "

    Răzvan
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems