Re: SQL Server 2000 Performance - 10K vs. 15K

Man, I've been having a heck of a time adding messages to this today.
I add them but they never show up.

Anyway, what about moving the tempdb log file, since it is on the
original drive with the data file? Would that impact performance?? If
this is an option, how do I move it since it can't be backed up or
detached?

Also, I'm getting a message in event viewer that the tempdb log file is
full, but can't find how to shrink it other than stopping and
restarting sql. everything is set to grow automatically, and there is
plenty of disk space.

thanks
Randy


MeanOldDBA wrote:
> Have you looked at your disk queue lengths in performance monitor? I would
> be looking at both the logical and physical disk reads per disk to identify
> where/if the bottleneck is occurring at the hardware level. In addition,
> monitor the cache hit ratio, buffer cache hit ratio, target and total server
> memory counters, pages/sec, and processor to make sure you have no issues
> there.
>
> After you moved to the new hardware, did you run UPDATE STATISTICS on the
> databases? If not, you might want to consider that.
>
> Post the counter averages above, and include max(counter) values for the
> physicals. That should help us quickly identify if it's hardware.
>
> Other than that, people have given you really good advice on using Profiler.
> You need to find out if there is a hot spot causing you issues. Sometimes,
> moving to a bigger system can change dynamics enough to cause particular
> processes to run poorly. After they are identified and tuned, you can really
> begin enjoying the full benefit of the upgrade.
> --
> Derrick Leggett
> Mean Old DBA
> http://weblogs.sqlteam.com/derrickl
>
> When life gives you a lemon, fire the DBA.
>
>
> "Hank Arnold" wrote:
>
> > I'm definitely not in the same league as John and Andrew, but it sure makes
> > sense to investigate where the bottlenecks are before investing that kind of
> > money. You know how the finance folks are!! ;-)
> >
> > That's one powerful system you have there. It *should* really rock.....
> >
> > --
> > Regards,
> > Hank Arnold
> >
> > "randy" <rhenson@xxxxxxxxxxxx> wrote in message
> > news:1126967769.711673.44190@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > Hi SQL Gurus, I've got a scenario that I need some help with.
> > >
> > > I recently upgraded our company's erp system from the old foxpro
> > > version, to the latest sql version. I'm seeing a couple of performance
> > > issues. It doesn't matter which workstation config. I've got some with
> > > 2.8GB processor and 2GB of RAM, still have the same problem. I can run
> > > the client on the server, and still have to same issue.
> > >
> > > It's like the reads are OK, but the writes seem slower than on the
> > > foxpro version. Not a lot slower, but still slower -- and you know
> > > how users can be!!
> > >
> > > My server config is just as the software company recommends. Dell
> > > PowerEdge 2850, Dual 3GB processors, 6GB RAM with sql tuned to use 5gb.
> > > . RAID controller is PERC4e/DI, with 2X4 backplane. SQL Server 2000
> > > Enterprise with AWE enabled. Log files and data files on separate raid
> > > arrays on different channels. OS and Log array is RAID 1 on channel 0,
> > > Data array is RAID10 on channel 1. RAID Policy is set to write-back.
> > >
> > > My database is about 10GB.
> > >
> > > I said all that to ask this question, all of my drives are 140GB 10K,
> > > would the performance increase be significant enough to spend the money
> > > if I upgraded the 4 hard drives on the RAID-10 Data drive to 140GB and
> > > 15K?? I've got the budget to do it, but if it's not a big difference,
> > > I won't bother spending the money.
> > >
> > > I appreciate any guidance you will be able give me on this.
> > >
> > > Randy
> > >
> >
> >
> >

.

Relevant Pages

  • Re: Data lost after rebuilding new txn log after disk failure
    ... How did you "build a new log file"? ... Tibor Karaszi, SQL Server MVP ... > Had a problem recently with some lost data after a disk in one of our DB servers failed. ... > disks to guard against disk failure. ...
    (microsoft.public.sqlserver.server)
  • Re: How to change DC for Exchange server
    ... I'd take a look at the following article and use the section on Disk ... more as it overwrites the log file when it gets to the end. ... If you have a server problem that requires you to restore ... the Exchange log files are sequential writes. ...
    (microsoft.public.exchange.admin)
  • Performance Monitor statistic listed but no data generated?
    ... I am trying to generate log files on free disk space on a file server ... The server has two 36GB drives in hardware RAID1 ... will just not have an entry for E: in the log file. ...
    (microsoft.public.windows.file_system)
  • Re: Data lost after rebuilding new txn log after disk failure
    ... Have you performed LOG file backup? ... When the disk is faild you was be able to run BACKUP LOG file WITH NO ... > Is there anything I should be checking on the server? ...
    (microsoft.public.sqlserver.server)
  • Dynamic Disk Moves
    ... moving from one server to a different Server, copying data and then moving it ... signature and would not import disk. ... My Tasks is to temporally install a new large LUN to the old server to copy ...
    (microsoft.public.windows.server.general)