Posted by caseahr on 12/14/06 14:16

Merci beaucoup, Cédric. That's exactly what I needed.

Cédric Del Nibbio wrote:
> Hi,
>
> You may try the following commands :
> sp_spaceused : gets the statistics of usage for a DB or a table. these
> stats are not splitted by file.
> DBCC SHOWFILESTATS : Gets the statistics of usage per data file. Log
> file is ignored. The size is given in extents, depending on your system
> (usually, the factor number is 64 to get the size in KB).
> DBCC SQLPERF (LOGSPACE) : Gets the statistics of usage for the log
> file.
> sp_helpdb and sp_helpfile : gets the information about size and growth,
> for the database and the files.
>
> These functions work properly either on SQL Server 2000 and SQL Server
> 2005.
>
> Hope this will fit your needs.
>
> Cédric Del Nibbio
> MCP since 2003
> MCAD .NET
> MCTS SQL Server 2005
>
>
> caseahr a écrit :
>
> > When you create data files and filegroups, you specify a size. My
> > question is -- how do you know how full they are? Is there a stored
> > procedure for that?

• Next in forum: Security issues in SQL Server 2005
• Prev in forum: Help with joining records
• Thread view: Re: How do I find out how full my files are?

[Reply to this message]