Article View: comp.databases.ms-sqlserver
Article #81Re: what is the impact of Database size on Performemce
From: HumanJHawkins
Date: Tue, 30 Mar 2004 21:09
Date: Tue, 30 Mar 2004 21:09
27 lines
2688 bytes
2688 bytes
"Avner" <avnera@cvdo.com> wrote in message news:tSjac.16658$xb.714@newssvr27.news.prodigy.com... > I need some information to understand what is the impact of Database size on > the performemce. > <CUT> > 1. Is there any impact? In queries that make use of the data, yes. > 2. Does one very large table impact the performence of the the whole DB, > meaning the overall performence and access the other tables. Essentially no. > 3. What are the ways to reduce the impact of the DB size on the DB > performence DB size is so low on the radar of performance issues, that I think it is basically worth ignoring. If your database is so big that it fills the drive it is on, that could slow the whole system down as the page file has to get chunked up. But for all reasonable scenereos, you are much better off focusing on reducing the number of calls that are required to get work done, and improving the efficiency of your functions and procedures. Cheers!
Technical Details
Message-ID:
<Wllac.7914$Dv2.545@newsread2.news.pas.earthlink.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newshub.sdsu.edu!elnk-nf2-pas!newsfeed.earthlink.net!stamper.news.pas.earthlink.net!newsread2.news.pas.earthlink.net.POSTED!ac913598!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: 104de1,2aea0b246c090747 X-Google-Attributes: gid104de1,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: 110f0d,2aea0b246c090747 X-Google-Attributes: gid110f0d,public X-Google-ArrivalTime: 2004-03-30 13:09:10 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!newshub.sdsu.edu!elnk-nf2-pas!newsfeed.earthlink.net!stamper.news.pas.earthlink.net!newsread2.news.pas.earthlink.net.POSTED!ac913598!not-for-mail From: "HumanJHawkins" <JHawkins@HumanitiesSoftware.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 References: <tSjac.16658$xb.714@newssvr27.news.prodigy.com> Subject: Re: what is the impact of Database size on Performemce Lines: 29 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: <Wllac.7914$Dv2.545@newsread2.news.pas.earthlink.net> Date: Tue, 30 Mar 2004 21:09:10 GMT NNTP-Posting-Host: 65.40.220.160 X-Complaints-To: abuse@earthlink.net X-Trace: newsread2.news.pas.earthlink.net 1080680950 65.40.220.160 (Tue, 30 Mar 2004 13:09:10 PST) NNTP-Posting-Date: Tue, 30 Mar 2004 13:09:10 PST Organization: EarthLink Inc. -- http://www.EarthLink.net