|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Database SizeHi,
I have a web application (MS SQL 2000 / ASP). Database has grown from 20 MB to 400 MB in the last year or so. I am a little concerned about the size and how to be prepared when something needs to be done in this sense. At what size should I be concerned and is there any site that tells what to do when the database grows a lot ? Will I have performance issues ? Any information is greatly appreciated Aleks If this 400 MB is al data then you can not make it smaller without deleting
data You can however shrink the transaction log, do you have autoshrink enabled, does someone else shrink it on regularely? 400 MB is nothing for SQL Server we have a DB here that well over 100 GB with some tables having 8 million records If you see problems in the future you can always 'archive' old records into another DB or Data WareHouse http://sqlservercode.blogspot.com/ Show quote "Aleks" wrote: > Hi, > > I have a web application (MS SQL 2000 / ASP). Database has grown from 20 MB > to 400 MB in the last year or so. I am a little concerned about the size and > how to be prepared when something needs to be done in this sense. > > At what size should I be concerned and is there any site that tells what to > do when the database grows a lot ? Will I have performance issues ? > > Any information is greatly appreciated > > Aleks > > > Are you concerned about database administration/maintenance of large
databases or optimizing the performance of queries? Actually, 400mb is not large at all for a medium powered box running SQL Server. A typical database (or collection of related databases) for an insurance or ecommerce company with a few years of transactional data would be > 20 GB. It's not until you reach 100 GB that you're talking about something serious. Basically you want to start gradually introducing data warehousing concepts into your system design. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx http://www.microsoft.com/sql/techinfo/administration/2000/scalability.mspx http://www.microsoft.com/technet/community/chats/trans/sql/sql0326.mspx http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_00_9okw.asp Show quote "Aleks" <arkark2***@hotmail.com> wrote in message news:eWrusJEwFHA.2556@TK2MSFTNGP15.phx.gbl... > Hi, > > I have a web application (MS SQL 2000 / ASP). Database has grown from 20 > MB to 400 MB in the last year or so. I am a little concerned about the > size and how to be prepared when something needs to be done in this sense. > > At what size should I be concerned and is there any site that tells what > to do when the database grows a lot ? Will I have performance issues ? > > Any information is greatly appreciated > > Aleks > Thanks .. this gives me some peace of mind.
A Show quote "JT" <some***@microsoft.com> wrote in message news:eae8N%23EwFHA.2960@tk2msftngp13.phx.gbl... > Are you concerned about database administration/maintenance of large > databases or optimizing the performance of queries? Actually, 400mb is not > large at all for a medium powered box running SQL Server. A typical > database (or collection of related databases) for an insurance or > ecommerce company with a few years of transactional data would be > 20 GB. > It's not until you reach 100 GB that you're talking about something > serious. Basically you want to start gradually introducing data > warehousing concepts into your system design. > http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx > http://www.microsoft.com/sql/techinfo/administration/2000/scalability.mspx > http://www.microsoft.com/technet/community/chats/trans/sql/sql0326.mspx > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_00_9okw.asp > > "Aleks" <arkark2***@hotmail.com> wrote in message > news:eWrusJEwFHA.2556@TK2MSFTNGP15.phx.gbl... >> Hi, >> >> I have a web application (MS SQL 2000 / ASP). Database has grown from 20 >> MB to 400 MB in the last year or so. I am a little concerned about the >> size and how to be prepared when something needs to be done in this >> sense. >> >> At what size should I be concerned and is there any site that tells what >> to do when the database grows a lot ? Will I have performance issues ? >> >> Any information is greatly appreciated >> >> Aleks >> > >  |
|||||||||||||||||||||||
Other interesting topics