June 3, 2003 at 4:32 pm
Hello,
The company I work for collects data from a variety of sources. Our databases contain the following data: Social Demographic, Social Economic, Retail, Car etc, etc. They're currently in Microsoft Access, but I have a migration plan for migrating them to SQL Server 2000.
Some of the files I import (using the DTS wizard) from our clients are over 1.8 gigabytes and contain over 9 million records. The smallest file contains about 500, 000 records. Currently the information in these files are totals on a postcode level, however, we will soon be collecting data on household levels, meaning even more records. New clients are always sending us data to be analyzed. I have a few questions in relation to my scenario, and I will appreciate as much feedback as possible.
I also have several database for clients that contains 5 years of historical data
1. What should be the minimum size (MB) of my TEMPDB database?
2.I have been asked to put a specification together for a new server. I don't have the exact specification I put forward at the time but it looks something like this:
2 * 146 GB 10, 000 rpm SCSI Hard Disk Drive
SCSI Controller card
DUAL Intel Xeon Processor (2.4 GHz)
512MB of the fastest RAM
1 GB DDR SDRAM
Windows 2003 Server
Backup Drive
I will need to create Composite Indexes on all of these tables, and some views to enable our analysts to work quicker. I expect such objects to consume a great amount of disk space.
Management is currently debating if I need such a machine. Unfortunately, the machine I'm currently using is a Pentium 2, with 128MB of RAM, and hardly and disk space remaining.
I really need some help in convincing them that I need the Server, so any help in relation to this will be very much appreciated
Cheers,
Rudi
Regards,
Rudi
Regards,
Rudi
June 4, 2003 at 4:36 am
Please do not cross post. See/leave responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12821&FORUM_ID=5&CAT_ID=1&Topic_Title=Help+needed+with+Sizing+TempDb+and+Server&Forum_Title=Administration
Moderator please handle this thread.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply