Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 22

Thread: Faster HD access

  1. #11
    Variable Bitrate blurp's Avatar
    Join Date
    Sep 2003
    Location
    Hampshire, TN
    Posts
    349
    Quote Originally Posted by Matthew230
    It has slowed down quite alot recently

    Have you done basic maintenance, like defragging the drive, and re-indexing the DB?
    www.bradleyjacobs.com

    There is more stupidity than hydrogen in the universe, and it has a longer shelf life. -- Frank Zappa

  2. #12
    Variable Bitrate
    Join Date
    Sep 2004
    Posts
    326
    Quote Originally Posted by xBrady
    Ask the guy that set up the server what database he put on there

    You have to use some profiling software to find your bottle neck. Google will produce plenty of results.
    Thanks,

    Just to be sure, is it what the Server has, or is the database held by the application ?

  3. #13
    Variable Bitrate
    Join Date
    Sep 2004
    Posts
    326
    Quote Originally Posted by blurp
    Have you done basic maintenance, like defragging the drive, and re-indexing the DB?
    Tried De-fragging the HD, though it won;t let me do it properly. Even tried with perfectdrive, though for some reason I can't do a offline defrag. The drive is very fragmented.

    Don't know how to re-index a DB, any suggestions ??

  4. #14
    Variable Bitrate blurp's Avatar
    Join Date
    Sep 2003
    Location
    Hampshire, TN
    Posts
    349
    Quote Originally Posted by Matthew230
    Thanks,

    Just to be sure, is it what the Server has, or is the database held by the application ?
    Depends. It could be using a SQL DB, or it could be something like MS access, which is part of the app.
    www.bradleyjacobs.com

    There is more stupidity than hydrogen in the universe, and it has a longer shelf life. -- Frank Zappa

  5. #15
    Variable Bitrate blurp's Avatar
    Join Date
    Sep 2003
    Location
    Hampshire, TN
    Posts
    349
    Quote Originally Posted by Matthew230
    Tried De-fragging the HD, though it won;t let me do it properly. Even tried with perfectdrive, though for some reason I can't do a offline defrag. The drive is very fragmented.

    Don't know how to re-index a DB, any suggestions ??
    AHA! There's the first thing you need to take care of. If it is incapable of defragging, you might have some corrupt data, or the HD might be too full, or the OS might be hosed. What OS is it?
    www.bradleyjacobs.com

    There is more stupidity than hydrogen in the universe, and it has a longer shelf life. -- Frank Zappa

  6. #16
    Variable Bitrate
    Join Date
    Sep 2004
    Posts
    326
    Quote Originally Posted by blurp
    AHA! There's the first thing you need to take care of. If it is incapable of defragging, you might have some corrupt data, or the HD might be too full, or the OS might be hosed. What OS is it?

    The O/S is MS Small Business Server 2000.

    I have had another look at the drive. The partition that holds the database data is completely defragmented.

  7. #17
    Variable Bitrate blurp's Avatar
    Join Date
    Sep 2003
    Location
    Hampshire, TN
    Posts
    349
    Quote Originally Posted by Matthew230
    The O/S is MS Small Business Server 2000.

    I have had another look at the drive. The partition that holds the database data is completely defragmented.
    OK, then. Let's go with the next easiest thing. Check with whoever wrote the app and find out how, or get them to do some database maintenance. We have lots of databases at work that have to have regular tweaking to keep them efficient, just becase of the volume of data that gets changed every day.
    www.bradleyjacobs.com

    There is more stupidity than hydrogen in the universe, and it has a longer shelf life. -- Frank Zappa

  8. #18
    Variable Bitrate roadhog's Avatar
    Join Date
    Jul 2005
    Location
    Hampshire UK
    Posts
    291
    I only know MS Access (boo!) but purely as an example they have a utillity under Tools > Database Utilities > Compact and repair Database. Look upon such an action as "defragging" your database. Needless to say, back it up first.

  9. #19
    Variable Bitrate
    Join Date
    Sep 2004
    Posts
    326
    Ok, I have managed to get some profiling software running. Most of the results seem pretty good, and I have run the application from the Server and the speed is too slow, which I think means that the network isn;t the problem.

    The results that do look like they may be causing the problem are the Disk Speeds:

    Disk Sequential Read - 52mb/sec
    Disk Sequential Write - 1.8mb/sec
    Disk Random Seek + RW 2.35mb/sec

    Could this be causing the issues ??

  10. #20
    Variable Bitrate roadhog's Avatar
    Join Date
    Jul 2005
    Location
    Hampshire UK
    Posts
    291
    Sounds like the disk is full or a file is mucking up the MFT.

Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. Problem with ITPS / hibernation and External USB HD
    By veetid in forum Power Supplies
    Replies: 5
    Last Post: 01-02-2006, 08:35 PM
  2. IDE EXTERNAL HD Pt-2
    By PaCMaYNE in forum General Hardware Discussion
    Replies: 1
    Last Post: 01-23-2005, 02:43 AM
  3. booting from flash card faster than HD?
    By ecolner in forum Newbie
    Replies: 26
    Last Post: 02-24-2004, 01:36 PM
  4. Why does my HD stops???
    By nl4jy in forum General Hardware Discussion
    Replies: 1
    Last Post: 02-05-2004, 10:53 AM
  5. Dying HD?
    By MikeHunt79 in forum General Hardware Discussion
    Replies: 15
    Last Post: 03-07-2002, 09:47 PM

Bookmarks

Posting Permissions

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