Sunday, March 25, 2012

Database grew 50% in a week ??

What happened ?
normal volume of transaction.. db recovery is set to simple
Any Idea
Is there any way I can know the size of each table ?
Thanks
Sam
Probably did a reindex. That requires lots of free space other wise it will
grow the db.
Andrew J. Kelly SQL MVP
"Sam" <samnadeau@.sympatico.ca> wrote in message
news:elb7gTX3EHA.936@.TK2MSFTNGP12.phx.gbl...
> What happened ?
> normal volume of transaction.. db recovery is set to simple
> Any Idea
> Is there any way I can know the size of each table ?
> Thanks
> Sam
>
|||Can the system do this by itself ? Cause I know for sure I didn't do it.
What else ?
How can we get more info the the space usage of each tables ?
Thanks
Sam
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uS9Pmaa3EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Probably did a reindex. That requires lots of free space other wise it
> will grow the db.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <samnadeau@.sympatico.ca> wrote in message
> news:elb7gTX3EHA.936@.TK2MSFTNGP12.phx.gbl...
>
|||It's also possible that that you had many inserts on a table that was
clustered in such a way that the inserts occurred throughout the table and
caused a lot of page splits. Run DBCC SHOWCONTIG to see the extent of
fragmentation. Pay close attention to page density.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Sam" <samnadeau@.sympatico.ca> wrote in message
news:ePgqTXf3EHA.3416@.TK2MSFTNGP09.phx.gbl...
Can the system do this by itself ? Cause I know for sure I didn't do it.
What else ?
How can we get more info the the space usage of each tables ?
Thanks
Sam
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:uS9Pmaa3EHA.1564@.TK2MSFTNGP09.phx.gbl...
> Probably did a reindex. That requires lots of free space other wise it
> will grow the db.
> --
> Andrew J. Kelly SQL MVP
>
> "Sam" <samnadeau@.sympatico.ca> wrote in message
> news:elb7gTX3EHA.936@.TK2MSFTNGP12.phx.gbl...
>
|||SQL Server doesn't do this by itself, but perhaps you have a join, possibly created by Maintenance
Plan Wizard, that does this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <samnadeau@.sympatico.ca> wrote in message news:ePgqTXf3EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Can the system do this by itself ? Cause I know for sure I didn't do it.
> What else ?
> How can we get more info the the space usage of each tables ?
> Thanks
> Sam
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:uS9Pmaa3EHA.1564@.TK2MSFTNGP09.phx.gbl...
>
|||> SQL Server doesn't do this by itself, but perhaps you have a join,
> possibly created by Maintenance
I think Tibor really means "Job" not "Join"<g>.
Andrew J. Kelly SQL MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uRtaG1f3EHA.2156@.TK2MSFTNGP10.phx.gbl...
> SQL Server doesn't do this by itself, but perhaps you have a join,
> possibly created by Maintenance
> Plan Wizard, that does this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <samnadeau@.sympatico.ca> wrote in message
> news:ePgqTXf3EHA.3416@.TK2MSFTNGP09.phx.gbl...
>
|||True. Thanks Andrew.
I've just talked about joins in class, and probably typed a bit too fast... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:O7e919f3EHA.1152@.TK2MSFTNGP14.phx.gbl...
> I think Tibor really means "Job" not "Join"<g>.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uRtaG1f3EHA.2156@.TK2MSFTNGP10.phx.gbl...
>

No comments:

Post a Comment