Post reply

Need help deterimining cause of slow down

  • June 1, 2004 at 8:14 am

    #108062

    Each morning, in 8 of my company's offices, two DTS jobs run on each of the 8 computers.  For the most part the configuration and hardware is identical for all 8 server machines.

     

    One machine takes 4 times as long to run through the DTS jobs as all the others.

     

    These jobs run before biz hours so there is no one even using the db.

    Any suggestions on what I can do or what I can can look at to see WHY this is happening?

    I've rebuilt all the SP's, the DTS's, the Indexes. I dont know what else to do. I run a nightly full backup on the database too.

  • June 1, 2004 at 10:55 am

    #508534

    DB Version is MS SQL Server 2000 Desktop Edition SP3A running on Windows XP SP1

    Appx: 1GB of RAM and 40GB of HDD.

  • June 1, 2004 at 11:24 am

    #508538

    I'd check the network i/o of each box, if you are writing or reading anything from a network and have the nic set on 10 base, or even 100 half duplex that could easily account for the disparity.


    Shamless self promotion - read my blog http://sirsql.net

  • June 1, 2004 at 11:46 am

    #508543

    All the processes are running locally on the same machine. (No network xmit of data)

  • June 1, 2004 at 12:03 pm

    #508546

    Things to check: hard drive fragmentation? cpu bottlenecks? memory errors? page file usage?

     


    Shamless self promotion - read my blog http://sirsql.net

  • June 1, 2004 at 12:26 pm

    #508547

    This is a good one.

     

    I was comparing the page file usage between that machine and a good machine. And the difference was crazy.  Well turns out, someone there took physical RAM out of the computer.  I love it.

  • June 1, 2004 at 3:48 pm

    #508566

    That is when you track them down and beat them summarily.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply