hey guys--i need some expert advice!
we have a Dell PE 2650 with 2GHz and 2MB RAM with 2000 Server. on it we
have about 6 MSSQL DB's. a couple of the DB's are the back-end for a
decent sized web app (5-10 users on average, 20 users at most). many
times, the cpu skyrockets on our db server when using the web app.
sometimes things timeout, other times not. at this time, upgrading the
hardware is not an option. aside from increasing the timeout periods, i
was wondering if windows 2003 server would utilize the processor better
(even just a little bit?) enough to know the difference.
should i attempt the upgrade, or is 2003 no more efficient with
processor resources?
thanks a bunch!