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 |
|
nandac
Starting Member
27 Posts |
 Posted - 2008-11-28 : 11:16:59
|
| guys, i would like to know how to find the following information on ms sql from the system tables :database space - total size, used, freelong running transactionsblocked processes |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-11-28 : 13:44:13
|
| i would actually like to get the information from either system tables or system views instead of system stored procedures. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-28 : 14:09:29
|
| 1) sys.master_files2) sys.dm_exec_request 3)sys.sysprocesses |
|
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-12-01 : 14:50:42
|
| i saw the information i wanted in sp_spaceused.but cannot find the same information in sys.master_file!btw sp_spaceused only gives information regarding the dataspace and not the log space?that's exactly what i want - only data not log.appreciate if someone could point out how i could get the database size and the space currently used up from the system tables. |
|
|
|
nandac
Starting Member
27 Posts |
Posted - 2008-12-01 : 16:18:05
|
| ok, i got the data size by dividing size in master_files by 128.but where will i get the current space used up in a database? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
database information