Secs used for the average SQL server 3

[itmasterw]

I was wondering what are tipical RAM sises used on a giving SQL sever, and waht sise processors are used andd are dual processors tipically. I also, was wondering if there is a table or database.
I am asking this because I worked with ACCESS and I know that at about the 300,000 mark you are pushing it, but I also know that with SQL Server you are taking a more robut system; but I am not sure how much.
Thank You

 

[SQLSister]

People run databases that are terrabytes in size. Efficiency is a function of how you have the dba set up and the effficeny of the queries against it. But SQL Server can easily handle databases of extremely large sizes.

There really is no typical RAM or processors as database sizes and application vary so widely.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[Will192]

Not to insult anyone, but SQL server makes Access look like a joke.

If you planning on doing any real massaging of data, then switch to SQL Server. It's about 10 times a better product than Access. You can always use Access to build your front end.

I don't think that Access was ever designed to be used as a serious database for multiple users anyway.

 

[Catadmin]

SQL Server can host multiple databases with multiple tables. For a good look at the minimum recommended requirements for SQL Server, and the different versions of SQL Server (this too makes a difference in performance), you can download the Books Online from:

http://www.microsoft.com/sql/techinfo/productdoc/2000/

The RAM and processor requirements depend on the OS you're using. For Windows 2k, think a minimum of 256MB of RAM, one processor that is at least 386 with 133 Mhz of speed or faster (this is min. requirements now). With OEM machines, you can go up to either 32 or 64 processors.

Then you've got to worry about hard drive space for your db. Consider about 1 & 1/2 times the size of your current Access DB as a minimum starting size. (This measurement has always worked for me).

You could go out to Microsoft and see if they still have a demo version of SQL Server 2000 on their website. Given how close they are to releasing Yukon, I'm not sure if they've removed it. The demo would give you the Books Online AND help you look it over before you committ to upgrading.

Hope this helps!





Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!

 

[darrellblackhawk]

To get you started exploring SQL Server, MSDE 2000 is free.

It comes on the Office XP disk and also a few others.

You can also download it from Microsoft’s site at:

http://www.microsoft.com/sql/msde/default.asp.

It doesn't come with a front end, so you'll probably want
to download one also - unless you want to use osql.exe to
perform everything;-)

I use AquaFold's “Aqua Data Studio”, which you can
download here:

http://www.aquafold.com.

It works with a
number of DB engines.

Darrell