Article View: comp.databases.ms-sqlserver
Article #80what is the impact of Database size on Performemce
From: Avner
Date: Tue, 30 Mar 2004 19:27
Date: Tue, 30 Mar 2004 19:27
19 lines
2242 bytes
2242 bytes
I need some information to understand what is the impact of Database size on the performemce. Few questions : 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 will apreciate help in regards . Thanks Avner
Technical Details
Message-ID:
<tSjac.16658$xb.714@newssvr27.news.prodigy.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr27.news.prodigy.com.POSTED!cb2250e8!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f816f,2aea0b246c090747,start X-Google-Attributes: gidf816f,public X-Google-Thread: 104de1,2aea0b246c090747,start X-Google-Attributes: gid104de1,public X-Google-Thread: fa825,2aea0b246c090747,start X-Google-Attributes: gidfa825,public X-Google-Thread: 110f0d,2aea0b246c090747,start X-Google-Attributes: gid110f0d,public X-Google-Thread: 107d2f,2aea0b246c090747,start X-Google-Attributes: gid107d2f,public X-Google-Thread: ff490,2aea0b246c090747,start X-Google-Attributes: gidff490,public X-Google-ArrivalTime: 2004-03-30 11:28:03 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr27.news.prodigy.com.POSTED!cb2250e8!not-for-mail From: "Avner" <avnera@cvdo.com> 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: what is the impact of Database size on Performemce Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: <tSjac.16658$xb.714@newssvr27.news.prodigy.com> NNTP-Posting-Host: 216.163.191.3 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr27.news.prodigy.com 1080674841 ST000 216.163.191.3 (Tue, 30 Mar 2004 14:27:21 EST) NNTP-Posting-Date: Tue, 30 Mar 2004 14:27:21 EST Organization: SBC http://yahoo.sbc.com X-UserInfo1: S[OQBU_DPRROVV\X\JK^OFXBWR\HPCTL@XT^OBPLAH[\RWYAKVUOPCW[ML\JXUCKVFDYZKBMSFX^OMSAFNTINTDDMVW[X\THOPXZRVOCJTUTPC\_JSBVX\KAOTBAJBVMZTYAKMNLDI_MFDSSOLXINH__FS^\WQGHGI^C@E[A_CF\AQLDQ\BTMPLDFNVUQ_VM Date: Tue, 30 Mar 2004 19:27:21 GMT