We are running SQL Server 7.0. What kind of performance improvement should we expect in 2000 and in 2005? Thanks.
Wow -- that's a very open-ended question. If I were in your shoes, I'd skip SQL Server 2000 and go straight to SQL Server 2005. You can expect to see major improvements in scalability (the number of users and transactions a single server can support at one time), availability (the amount of time between server outages, either planned or unplanned) and maintainability (the ease with which you can manage the server). Read more about SQL Server 2005 at the Microsoft SQL Server Resource Center.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Kevin Kline
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain. Continue Reading
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline. Continue Reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.