|
Home > Archive > MS SQL Server > September 2005 > Temp Filegroup Disk Usage
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Temp Filegroup Disk Usage
|
|
| Joe K. 2005-09-06, 1:23 pm |
|
I have my tempDB database set up using filegroup (tempdev1, tempdev2,
tempdev3,tempdev4). So I have 4 files that represent my tempDB database.
How can I output the same values for disk space used and total from the SQL
Server Enterprise Manager in theTaskpad view for the TempDB database?
| |
| David Gugick 2005-09-06, 1:23 pm |
| Joe K. wrote:
> I have my tempDB database set up using filegroup (tempdev1, tempdev2,
> tempdev3,tempdev4). So I have 4 files that represent my tempDB
> database.
>
> How can I output the same values for disk space used and total from
> the SQL Server Enterprise Manager in theTaskpad view for the TempDB
> database?
use tempdb
exec sp_helpfile
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
|
|
|
|
|