Home > Ask the SQL Server Experts > Jeremy Kadlec - Performance Tuning Questions & Answers > Is my SQL Server 2000 optimized?
Ask The SQL Server Expert: Questions & Answers
EMAIL THIS

Is my SQL Server 2000 optimized?

Jeremy Kadlec EXPERT RESPONSE FROM: Jeremy Kadlec

Pose a Question
Other SQL Server Categories
Meet all SQL Server Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 29 December 2005
My server is x366 (02 CPU 3.16GB, 4GB memory, 6x73GB HDD/RAID5-C, D, E, F, CD-ROM) with MS Windows 2003 Enterprise and SQL Server 2000 Standard (SP4) for Database Server purpose (client/server app). I have two questions for you:

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?



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Jeremy Kadlec - Performance Tuning
View query execution plan in SQL Server with this method
Adding non-clustered indexes to SQL Server columns
Change collation to SQL Server 2005 after upgrading databases
What impact does changing one record have on the database?
Is there a maximum number of sockets that SQL can handle?
Why is my SQL Server frequently corrupted?
How to speed up a composite nonclustered index-based query
What's the best way to page SQL Server data results?
Can I change the date format when moving a flat file to SQL?
Performance differences between Windows and Linux-based databases

SQL Server performance and tuning
Top 10 SQL Server Tips of 2008
Tutorial: Performance tuning SQL Server via queries, indexes and more
SQL Server Management Studio 2008: New features, part 1
Tutorial: SQL Server indexing tips to improve performance
SQL Server virtualization pros and cons: Weigh the performance impact
How to configure storage in SQL Server DB with more writes than reads
Avoid cursors in SQL Server with these methods to loop over records
Solve SQL Server errors and more from the DBA trenches -- part 2
Tutorial: Learn SQL Server basics from A-Z
FAQ: Troubleshooting SQL Server Reporting Services

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
contiguity  (SearchSQLServer.com)
contiguous  (SearchSQLServer.com)
drilldown  (SearchSQLServer.com)
hashing  (SearchSQLServer.com)
hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



SQL Solutions - SQL Database Design
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts