Re: MSDE database too big

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Guoqi Zheng (no_at_sorry.nl)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 12:59:00 +0200

ok, thanks, I will do that... 

-- 
Kind regards
Guoqi Zheng
guoqi AT  meetholland dot com
http://www.meetholland.com
"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:e%23GDeq4XEHA.2364@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I agree with tibor, the the high usage will be with ntext column.
>
> To check the exact situation, create a new new database and then execute
the
> below command
>
> select col1,col2,.. avoid column with ntext,... coln  into
newdb..table_name
> select  col1,col2,.. avoid column with ntext,... coln   from
> currentdb..table_name
>
> now inside OSQL prompt execute :-
>
> 1>use newdb
> 2>go
> 1>sp_spaceused <table_name>
> 2>go
>
> THis will give you the table size with out text column.
>
> Thanks
> Hari
> MCDBA
>
>
>
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
in
> message news:eAiiEY3XEHA.3100@TK2MSFTNGP09.phx.gbl...
> > Probably the ntext column...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Guoqi Zheng" <no@sorry.nl> wrote in message
> news:elj7TD3XEHA.2408@tk2msftngp13.phx.gbl...
> > > Ok, thanks
> > >
> > > I saw the following.
> > >
> > > name       rows          reserved          data
index_size
> > > unused
> > > tblMsg     47576     779536 KB      779368 KB   8 KB           160 KB
> > >
> > > Is there any problem with above? It seems strange that I have so much
> data
> > > there. Only 47476 rows seems not to be so big...
> > >
> > > Below is my table structure, do you think there is any problem with my
> > > table? Should I make those fields much smaller?
> > >
> > > AutoId int 4
> > > MsgId varchar 200
> > > GroupId int 4
> > > MsgTitle nvarchar 500
> > > MsgAuthor nvarchar 200
> > > Ref varchar 500
> > > RefTo varchar 200
> > > MsgContent ntext 16
> > > MsgDate varchar 100
> > > AddDate datetime 8
> > > ServerId int 4
> > > isRef bit 1
> > >
> > > --
> > > Kind regards
> > >
> > > Guoqi Zheng
> > > guoqi AT  meetholland dot com
> > > http://www.meetholland.com
> > >
> > > "Hari" <hari_prasad_k@hotmail.com> wrote in message
> > > news:OQ4RfR2XEHA.2972@TK2MSFTNGP12.phx.gbl...
> > > > Hi Tiber,
> > > >
> > > > It is MSDE  :) .  It seems he meant a user database inside his MSDE
> > > server.
> > > >
> > > > Guoqi Zheng,
> > > >
> > > > Can you login to SQL Server from command prompt and do below:-
> > > >
> > > > OSQL -Usa -Ppassword -Sserver_name (Enter)
> > > >
> > > > 1>use <dbname>
> > > > 2>go
> > > > 1>sp_spaceused table_name,@updateusage='true'
> > > > 2>go
> > > >
> > > > THis will give you the exact usage of the table, See the reserved
> column
> > > for
> > > > the usage in KB.
> > > >
> > > > After that you can execute the below command to get the size of MDF
> and
> > > LDF
> > > > file
> > > >
> > > > 1>sp_helpdb <dbname>
> > > > 2>go
> > > >
> > > >
> > > > --
> > > > Thanks
> > > > Hari
> > > > MCDBA
> > > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
> wrote
> > > in
> > > > message news:#VqDi#1XEHA.4000@TK2MSFTNGP09.phx.gbl...
> > > > > Which file for the msdb database is big. I.e., can you post the
file
> > > names
> > > > and the size for each
> > > > > file?
> > > > >
> > > > > --
> > > > > Tibor Karaszi, SQL Server MVP
> > > > > http://www.karaszi.com/sqlserver/default.asp
> > > > > http://www.solidqualitylearning.com/
> > > > >
> > > > >
> > > > > "Guoqi Zheng" <no@sorry.nl> wrote in message
> > > > news:ulbhW61XEHA.3512@TK2MSFTNGP12.phx.gbl...
> > > > > > Dear sir,
> > > > > >
> > > > > > I have a MSDE database, with only one table. I have about 50,000
> > > records
> > > > > > with content of article on it.  The database space seems a
little
> > > > strange
> > > > > > for me, because it is 800 MB already... I am running W2k3 web
> edition
> > > +
> > > > MSDE
> > > > > > Sp3.
> > > > > >
> > > > > > Any one have an idea what may be wrong and how can I check the
> > > problem?
> > > > > >
> > > > > > --
> > > > > > Kind regards
> > > > > >
> > > > > > Guoqi Zheng
> > > > > > guoqi AT  meetholland dot com
> > > > > > http://www.meetholland.com
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Quoted-Printable class
    ... Kind regards ... guoqi AT meetholland dot com ... "Jorge" wrote in message ... >>guoqi AT meetholland dot com ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Calling a public method in my code-behind class
    ... Kind regards ... guoqi AT meetholland dot com ... > public String GetDisplayText> ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: access is denied, dotnet class
    ... Although indexing service is really useful, but if turn it off can solve ... Kind regards ... guoqi AT meetholland dot com ... >> guoqi AT meetholland dot com ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: dynamic meta tag
    ... Kind regards ... guoqi AT meetholland dot com ... "Teemu Keiski" wrote in message ... > guoqi AT meetholland dot com ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: shift + ctrl charactor
    ... Kind regards ... guoqi AT meetholland dot com ... shift and ctrl are keycode modifiers, while chrproduces an> ascii char. ...
    (microsoft.public.dotnet.framework.aspnet)