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

MichaelMichael, 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.

Rapid Space increase & deacrease

All my files keep compressing & decompressing rapidly.
And it won't stop!!!!!!!!
Some files become corrupt!!!!
HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!"Colin Bissbort" <anonymous@.discussions.microsoft.com> wrote in message
news:0a9701c3d3b6$24be0f50$a601280a@.phx.gbl...

quote:

---

> All my files keep compressing & decompressing rapidly.
> And it won't stop!!!!!!!!
> Some files become corrupt!!!!
> HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!

---

You are talking about SQL Server files? Size your database and transaction
logs to allow for growth. Then turn off 'auto grow' and 'auto shrink'. Does
this help?
Steve