SEO

#1 (**permalink**) 02-28-2008, 06:15 PM

Hello

Does anyone one know the max size of a database that I can create on
MS-SQL server 7. Have had any problems using databases near the max
size (slow performance, etc)

Thanks
Helena

#2 (**permalink**) 02-28-2008, 06:15 PM

hmatijaca@yahoo.ca (Helena) wrote in message news:<c5a36d06.0310080727.2468ecd5@posting.google. com>...
> Hello
>
> Does anyone one know the max size of a database that I can create on
> MS-SQL server 7. Have had any problems using databases near the max
> size (slow performance, etc)
>
>
> Thanks
> Helena

Hi Helena,

According to Books Online, it's 1,048,516 TB which is definitely a big DB.
Yes definitely for DBs os this size, the hardware needs would change.

Regards,
-Manoj

#3 (**permalink**) 02-28-2008, 06:17 PM

"Helena" <hmatijaca@yahoo.ca> wrote in message
news:c5a36d06.0310080727.2468ecd5@posting.google.c om...
> Hello
>
> Does anyone one know the max size of a database that I can create on
> MS-SQL server 7. Have had any problems using databases near the max
> size (slow performance, etc)

Backups are generally one of the biggest problems I've seen with VLDBs.

You have to have a backup/restore strategy that works for your business
rules.

If it takes 24 hours to restore your database and business rules require you
to back it up in less than 6, you'll have to change your infrastructure.

Generally performance comes down a LOT to design. Proper hardware can make
a huge difference, but even with extremely fast hardware, if you have a
lousy design and end up doing a table scan of a multigig DB, your
performance will suck.

On the other hand, if you have mediocre hardware, but you can do index
lookups for every query (as opposed to a table scan) you'll do a lot better.

>
>
> Thanks
> Helena

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Max database size on SQL-SERVER7