General discussion

Locked

Installing SQL Server 7

By rob.wilcox1 ·
Hi all,

I've read some of the Microsoft blurb on getting the "right"
installation, but I wanted to see what the real world does...

We've been cornered a little bit, in that we have already had bought for
us a HP LC 3 PII 350, 512 Mb RAM, 3 x9 Gb internal disks.

What we intend to do is to run a small SQL Server 7 database, and IIS 4
with Index Server. We are then going to install our Help Desk Call
Tracking Application (Help Desk Expert from AIM) on the machine.
Basically when people email in to the Help Desk it will result in a
ticket been added to the database, and likewise people can update these
tickets by querying from the web server.

Our questions are...

1) With 512 Mb of RAM, should we allocate 256 Mb of that to SQL Server ?

2) How big should we make tempdb ??
3) What way should we 'arrange' the disks ?
We've thought of a few possibilities

Option 1.
OS & Apps on Disk 1
Page File & dumping group on Disk 2
Data on Disk 3

Option 2.
Get a RAID card, and RAID 5 the

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Installing SQL Server 7

by jeremy In reply to Installing SQL Server 7

Dear Robert
There is no perfect text book configuration, it all depends on what sort of usage etc you expect but here are my thoughts.

The tempdb should be between 25% - 40% of your largest database. If you think of the tempdb as a scribling pad which SQL uses to jot down notes about the queries that you run, if it runs out of room to make those notes the system performance will slow down. You need to make a judgement about the nature of your queries, it sounds as though they should not be too intensive, so 30% should be a good guess. Try it and see. After all thats what performance monitor is for!!!
As for as RAM goes, you are going to need at least 1Mb od level 2 cache. That said, how much RAM you allocate SQL depend on what else you are running. SQL will quite happily help itself to all your RAM and starve IIS. If you are running Index server you will need to keep the wordlists in RAM so you need to limit the amount you allocate SQL. 256Mb sound reasonable to me, but then I have not seen t

Collapse -

Installing SQL Server 7

by rob.wilcox1 In reply to Installing SQL Server 7

The question was auto-closed by TechRepublic

Collapse -

Installing SQL Server 7

by brian.burnley In reply to Installing SQL Server 7

Part of the beauty of SQL 7.0 is the automatic sizing of memory usage, databases and log files. If you set the databases and the log files to automatically grow then you will not need to be concerned with outages due to a filled log or database. The automatic memory setting will allow SQL to use what it needs. It will not grab memory if it doesn't need it. In addition, you can monitor the memory with performance monitor. Opton 2 will provide for fault tolerance and that is the one I wouldgo with.

Collapse -

Installing SQL Server 7

by rob.wilcox1 In reply to Installing SQL Server 7

The question was auto-closed by TechRepublic

Collapse -

Installing SQL Server 7

by rob.wilcox1 In reply to Installing SQL Server 7

This question was auto closed due to inactivity

Back to Windows Forum
5 total posts (Page 1 of 1)  

Operating Systems Forums