Article View: comp.databases.ms-sqlserver
Article #83Re: what is the impact of Database size on Performemce
From: louis nguyen
Date: Tue, 30 Mar 2004 23:56
Date: Tue, 30 Mar 2004 23:56
18 lines
2254 bytes
2254 bytes
> 1. Is there any impact? > 2. Does one very large table impact the performence of the the whole DB, > meaning the overall performence and access the other tables. > 3. What are the ways to reduce the impact of the DB size on the DB > performence I've run into 2 problems w/ very large DB. A) Backups. I have a 50G DB. I backup to file then delete yesterday's backup file (I have another process which transfers the backup file to tape). So I have a 50G backup file and I need another 50G freespace, to run my backup process. B) Reindexing. On any given day maybe 5% (max) of new data is added to my DB. But DBCC reindex has to work on all the indexes. So DBCC reindex takes 3 hours a night. Yuck. Maybe there is a better way. But I try to keep each database as small as possible.
Technical Details
Message-ID:
<b0e9d53.0403301556.69835854@posting.google.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!postnews2.google.com!not-for-mailReferences:
<tSjac.16658$xb.714@newssvr27.news.prodigy.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f816f,2aea0b246c090747 X-Google-Attributes: gidf816f,public X-Google-Thread: ff490,2aea0b246c090747 X-Google-Attributes: gidff490,public X-Google-Thread: fa825,2aea0b246c090747 X-Google-Attributes: gidfa825,public X-Google-Thread: 107d2f,2aea0b246c090747 X-Google-Attributes: gid107d2f,public X-Google-Thread: 104de1,2aea0b246c090747 X-Google-Attributes: gid104de1,public X-Google-Thread: 110f0d,2aea0b246c090747 X-Google-Attributes: gid110f0d,public X-Google-ArrivalTime: 2004-03-30 15:56:55 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews2.google.com!not-for-mail From: louisducnguyen@hotmail.com (louis nguyen) Newsgroups: comp.databases.ms-sqlserver,comp.databases.postgresql.admin,cz.comp.microsoft.sql,microsoft.public.il.hebrew.sqlserver,microsoft.public.sqlserver,microsoft.public.sqlserver.misc Subject: Re: what is the impact of Database size on Performemce Date: 30 Mar 2004 15:56:54 -0800 Organization: http://groups.google.com Lines: 18 Message-ID: <b0e9d53.0403301556.69835854@posting.google.com> References: <tSjac.16658$xb.714@newssvr27.news.prodigy.com> NNTP-Posting-Host: 144.9.158.106 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1080691015 26581 127.0.0.1 (30 Mar 2004 23:56:55 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 30 Mar 2004 23:56:55 +0000 (UTC)