1. Here's my SQL Server 2000: C: (OS + SQL program install ) D: (50GB for Database data files .MDF) E: (50GB for
Database log files .LDF) F: (other data) Would you consider this to be optimized?
2. It is my understanding SQL 2000 Enterprise supports a maximum of 2GB memory. Can I use TEMPDB in RAM to enhance the performance? If so, how do I go about configurating my system for optimal performance?
2. SQL Server 2000 Standard edition can support up to 2 GB of memory with Windows 2003 Enterprise Edition. If you upgraded to the Enterprise Edition of SQL Server 2000 a total of 32 GB could be leveraged.
TempDB in RAM was an option with SQL Server 6.5 and is no longer an option with SQL Server 2000.
Dig deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Jeremy Kadlec, Contributor
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ...continue reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ...continue reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ...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.