Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Simple way to estimate memory for small SQL 2008 DW

Simple way to estimate memory for small SQL 2008 DW

Simple way to estimate memory for small SQL 2008 DW


I need to consolidate data from several sources for reporting needs, I have been pushing to put this in SQL instead of Access (!!) and have been asked to estimate the memory needs.

We don't have a DBA or access to one, and all the calculations I have found seem complicated and frankly if I don't get this approved fast I'm going to have to build it in Access, which I dread. Since this is a relatively small (I think) database I'm hoping that there is a simple way to make this estimate.

It will be a star, with the main table having about 50K records. I expect to add or refresh about 2000 records per week using SSIS. I've been reading up on various tricks to make this more memory efficient, but I guess I should assume the worst.

Can someone please point me in the right direction? Or is there a simple calculation I can use? Everything I find seems to assume something much larger and complex than what I need.

Thank you in advance.


RE: Simple way to estimate memory for small SQL 2008 DW

Honestly, with such a small number of rows, your memory needs will most likely be quite small. I would suggest that instead of trying to use a formula to estimate the memory needs, that it would actually be better to just put the data in to a SQL Server database.

I would recommend that you download and install SQL Server Express. SQL Express is a free version of Microsoft SQL Server. There are some limitation to express that are not likely to affect you. For example, the per database size limit is 10 GB. If you've been doing your work in Access, which has a much lower database size limit, then you won't have any problems with the free version.

Microsoft SQL Server MVP
My Blogs
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close