Announcement

Collapse
No announcement yet.

SQL Server Q

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Server Q

    So I've got this SQl Server 2005 SP2 running on:
    AMD 64 X2 4400+
    2 Gb
    146GB SATA Raid 0 (2x73GB WD Raptors), OS etc on seperate 7200 rpm drive
    Win XP

    It's a small thingy but the SPs take a long time to run (and my guess is indexing or query optimising won't change that a lot, ahem).

    So I am looking for an easy way to improve performance.
    - Should I expect better performance by migrating to WinXP 64 / SQL Server 64 bit?
    - Could I try increasing to 4GB while running WinXP 32 bit or do I need 64 bit to potentially benefit?
    - Because it is my development machine, loads of files are by now stored at the end of the HD. Is there a program that would re-allocate files to the start of the drive? Defrag puts m together but does not seem to move them...
    Join MURCs Distributed Computing effort for Rosetta@Home and help fight Alzheimers, Cancer, Mad Cow disease and rising oil prices.
    [...]the pervading principle and abiding test of good breeding is the requirement of a substantial and patent waste of time. - Veblen
Working...
X