The Geek Forum

  • May 23, 2024, 01:55:53 AM
  • Welcome, Guest
Please login or register.

Login with username, password and session length
Advanced search  

News:

Due to the prolific nature of these forums, poster aggression is advised.

*

Recent Forum Posts

Shout Box

Forum Stats

Members
Stats
  • Total Posts: 129658
  • Total Topics: 7202
  • Online Today: 109
  • Online Ever: 1013
  • (January 12, 2023, 01:18:11 AM)

Author Topic: Question for the Hardware Guys  (Read 1887 times)

Vespertine

  • The VSUBjugator
  • Forum Moderator
  • Hacker
  • *
  • Coolio Points: +371/-38
  • Offline Offline
  • Posts: 1255
    • View Profile
Question for the Hardware Guys
« on: November 09, 2006, 11:42:03 PM »
So, for those of you who don't know, I'm a database developer.  This means that I can write (some kinds of) code like nobody's business, but I am basically ignorant about hardware.  I have a 1.5TB database that sits on a massive SAN.  Simple question...on a SAN this big, can I run a Scandisk (or something else) to view my disk fragmentation without having to bring my system down?  Thanks in advance.
Logged
I have come here to chew bubble gum and kick ass.  And, I'm all out of bubble gum.

jeee

  • Dork
  • ***
  • Coolio Points: +189/-4
  • Offline Offline
  • Gender: Male
  • Posts: 796
    • View Profile
Re: Question for the Hardware Guys
« Reply #1 on: November 10, 2006, 05:33:29 AM »
That depends what kind of database it is. Oracle for instance  has built in commands to see database fragmentation and those work much quicker than an OS command like scandisk.
Logged

Demosthenes

  • Evil Ex-HN Moderator
  • Administrator
  • Hacker
  • *
  • Coolio Points: +567/-72
  • Offline Offline
  • Gender: Male
  • Posts: 9904
  • Just try me. See what happens.
    • View Profile
    • Zombo
Re: Question for the Hardware Guys
« Reply #2 on: November 14, 2006, 06:48:53 PM »
What kind of SAN is it?  Seems like I've run across something about how some of them handle disk fragmentation as a part of the RAID, but I am pretty new to SAN-wrangling so I might be thinking of something else.
Logged

Coolio Points: 89,000,998,776,554,211,222
Detta Puzzle Points: 45

Banning forum idiots since 2001

xolik

  • King of the Geekery
  • Hacker
  • ****
  • Coolio Points: +541/-25
  • Offline Offline
  • Gender: Male
  • Posts: 5176
  • HAY GUYS
    • View Profile
Re: Question for the Hardware Guys
« Reply #3 on: November 17, 2006, 01:15:52 PM »
All I know, is that my boss threated to kill me if I even though about running Scandisk or Defrag on our EMC box. I'm assuming you're using some type of EMC storage solution?
Logged
Barium: What you do if CPR fails.

=-=-=-=-=-=-=-=-=-=-=
[The Fade^C Compound]
-=-=-=-=-=-=-=-=-=-=-

Fade^C

  • Jail Bait
  • *
  • Coolio Points: +11/-2
  • Offline Offline
  • Gender: Male
  • Posts: 68
  • I am Jack's complete lack of surprise.
    • View Profile
Re: Question for the Hardware Guys
« Reply #4 on: November 18, 2006, 12:48:38 PM »
Check what the SAN's vendor recommends. Always run some defragmentation tool on a SAN, keeping in mind Window$ defrag may not do a thing!
Logged
tl;dr