I was looking for a little help getting started with optimizing our SQL server setup. I am quite new to SQL so I was looking for some tips or great www sites to point me in the right direction. I was curious to know some baseline settings for SQL (ex how much mem for SQL and NT, Temp DB in RAM, and just general baseline settings) yes I know that ever application is different, but I am just looking for some comparitive examples. Here is my current situation..

I have a Dual Pentium II 400 Machine with 512 MB of RAM and 16GB of disk space.

The database is about 1.5 GB in size and the temp db was set to 300MB.. ( is this a good ratio??) I am interested in the optimal memory config for this server. We are going to migrate to this as we rebuild the main SQL Server..

Any ideas or links for some good information...

Thanks for your help!

Terry Truebenbach

-- Anonymous, December 15, 1998

Answers

Re: Help Tuning SQL Server

Terry,

Check out, "Microsoft SQL Server 6.5: I/O Performance Tuning Quick Reference" at http://msdn.microsoft.com/developer/news/sqlperftune.htm.

You can also consider taking the course, "Performance Tuning and Optimization of Microsoft SQL Server 6.5" available at most of the places that provide Microsoft training.

A tempdb of 20% sounds like a good start. I think the optimal memory config is to let NT have 80 MB and let SQL have the rest.

Hope this helps,

Eric

-- Anonymous, December 15, 1998