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

Tech-Archive recommends: Speed Up your PC by fixing your registry

Derrick, what will the UPDATE STATISTICS do for me??

Also, I'm setting up performance monitor, it's sunday night so no one
working and it shows the buffer cache hit ratio, target server memory,
and total server memory all at 100 on the scale. what is this telling
me?

I'm also monitoring page hits, disk writes/sec on the data and log
drives, as well as transactions per second on the database. when
everyone starts working tomorrow, I'll expect these to start showing a
lot of activity during the day.

randy

.