Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PaulTeal
Yak Posting Veteran
67 Posts |
 Posted - 2003-09-02 : 11:31:53
|
| Can profiler monitor the physical size of the .mdf and .ldf files on a SQL Server? We are concerned that our tempdb is filling up the partition it is located in.I have been looking through the options in profiler and do not see one for monitoring the size of the actual files themselves. The tempdb can grow and shrink alot, if I am not mistaken.Paul Tealpaul@partytilyoupop.com |
|
|
PaulTeal
Yak Posting Veteran
67 Posts |
Posted - 2003-09-02 : 11:35:56
|
| I have placed this in the wrong forum, I will repost it in AdministrationPaul Tealpaul@partytilyoupop.com |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-02 : 12:07:20
|
| I guess it could fall here as well...Try looking at:master..xp_cmdshell 'dir d:\database\<instance name>\MSSQL$<instance name>\Data\temp*.*'Where <instance name> is your named instance for sql 2k..if it's not, the just the server name if it's the default...Brett8-)SELECT @@POST=NewId()That's correct! It's an AlphaNumeric! |
|
|
|
|
|
|
Profiler / File Size