Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    8

    Unanswered: Raw Partitions in SQL Server 2000

    Hi,

    I have a 3gb database (SQL 2k on Windows 2k) with some performance issues and it has been suggested to me to use Raw Partitions to increase performance. After researching this on BOL, I am hesitant to use raw partitions. I know this was a common practice in SQL 6.5. Has anyone tried this? What is the performance increase? Are there any other negatives besides what is mentioned in BOL? Any other insight would be greatly appreciated?

    Thanks

    Michael

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    Michael, I have used raw partitiones back with Ver 6.0 however controler technology has greatly improved since then. You need to read the little blurb in Books Online before you go down this path. I seriously doubt you will get enough of a performace boost to warrent the limitations raw partitions impose.

    I would look instead to the drive configuration, channel allocation, transfer speed of the SCSI card, distribution of files across the drives etc.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •