Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old November 23rd, 2004, 09:10 AM
klegrand klegrand is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Location: Belgium
Posts: 72 klegrand User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 h 1 m 31 sec
Reputation Power: 5
Server definition

What's the best way to define a good pc/server according the amount of records (+/- 4000records a day).
We have an excisting pc with SQL on it. We must made the descision to buy another pc or not upon the inserted records.

thx,
Kurt

Reply With Quote
  #2  
Old November 24th, 2004, 12:00 AM
MrData MrData is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Location: Sacramento, California, USA
Posts: 13 MrData User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 29 m 11 sec
Reputation Power: 0
It Depends

No. Really. It does.

How often are you selecting records from this database? How complex are your queries & stored procs?

That helps with the memory/cpu requirements.

How wide are your tables? That determines how many rows can be stored on your hard drive.

In general, figure out how much data you plan on storing. Then from there, you can determine how much hard drive space to carry in the box.

The CPU/Memory and whether or not to go RAID depends on the usage pattern, but the best advice is to get as much CPU/Memory as your budget allows, and get RAID & Multiple CPUs if at all possible.

Now if this is just a simple reporting server, you may not have high CPU/Memory needs, but a lot of hard drive space requirements.
An OLTP-style server is going to need the opposite specs (lots of CPU/Memory power and not as much hard drive space).

Your best bet of all is to not post for free advice on a forum, but talk to an actual DBA, who can give better advice than what you could ever get without your own background on the topic.

Remember, you get what you pay for.

Hope this helps,
Steve

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft SQL Server > Server definition


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT