
	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?

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

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?

EXPERT RESPONSE
1. This is a good configuration to split the different processing types. Without performing any capacity planning, it is difficult to determine if this storage will be sufficient though. In addition, based on the controller configurations, it may be better to have independent physical disks as opposed to a single RAID 5 set. Evaluate the performance of the server under load in a test environment and see the results. If the issue is disk drive (queue) related consider additional drives and RAID sets to support the load.

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.

Digg This!

StumbleUpon

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

Tips for tuning SQL Server 2005 to improve reporting performance

SQL Server errors, failures and other problems fixed from the trenches

SQL Server database design disasters: How it all starts

Can you shrink your SQL Server database to death?

Parent-child dimensions in SQL Server 2005 with Analysis Services MDX

SQL Server database design disasters: What not to do

Tuning SQL Server performance via memory and CPU processing

Troubleshoot Web service issues in SQL Server 2005 Reporting Services

Ordering the results of a SQL query

Configuring SQL Server with a changed computer name

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
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

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 \| Reprints \| Site Map All Rights Reserved, Copyright 2005 - 2008, TechTarget \| Read our Privacy Policy