Re: Setting database size
From: Amol Kasbekar (apk_at_nospam.com)
Date: 04/30/04
- Next message: Duane: "Data/log file placement"
- Previous message: Gina Hoener: "RE: Deleting old instances of SQL server"
- In reply to: Mark Allison: "Re: Setting database size"
- Next in thread: Mark Allison: "Re: Setting database size"
- Reply: Mark Allison: "Re: Setting database size"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 30 Apr 2004 09:42:20 -0400
Mark,
Can this be done for an existing DB. For eg. If I already have a db in use
at 250Mb and I want to set it at a max size of 1 gigs with no growth, how
can I do that ?
Amol.
"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:OVYjP8pLEHA.3052@TK2MSFTNGP12.phx.gbl...
> Bill,
>
> Yes, it is always a good idea to create your database at the final
> anticipated size to prevent fragmentation. Before you create the database
> file, stop MSSQLServer and do a disk defragmentation.
>
> Then, create your database file to be the max you expect it to be (same
for
> log). Switch off autogrow and autoshrink. You should have a contiguous
> high-performing data file now.
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
>
>
> "Bill Bradley" <wdbradley3@comcast.net> wrote in message
> news:umbLSmnLEHA.1348@TK2MSFTNGP12.phx.gbl...
> > We're using a patch scanning product, Shavlik HFNetChkPro, with SQL2K as
> the
> > backend running on a Win2K3 server, dual CPU, and 4 GB RAM.
> >
> > I have five drives, OS, SWAP, APPS, SQL, LOGS, and have all the products
> > separated out on individual drives as named.
> >
> > We regularly scan up to 1950 computers, and have noticed that the
> ShavlikDB
> > will get as large as 180 MB and its logfile will get up to 80 MB.
During
> > actual scans, HFNetChkPro has consumed as high as 600 MB of memory, and
> SQL
> > up to 180 MB. I periodically delete old scans and reboot the machine
> which
> > seems to lower both HD and memory consumption.
> >
> > I was wondering if it would do any good to just set the database to a
> large
> > value (250 MB and 100 MB logfile) and defrag those drives, so that
there's
> > no issue with growing or shrinking or fragmentation? I have set TempDB
to
> > 20/20 MB, as it was getting into the 12-15 MB range.
> >
> > Thanks!
> >
> >
>
>
- Next message: Duane: "Data/log file placement"
- Previous message: Gina Hoener: "RE: Deleting old instances of SQL server"
- In reply to: Mark Allison: "Re: Setting database size"
- Next in thread: Mark Allison: "Re: Setting database size"
- Reply: Mark Allison: "Re: Setting database size"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
