How should I estimate disk space requirement?

[crowsario]

Hello All,

I have been given the task of estimating the disk space requirement per record in a database being accessed by an application. I have no idea where to start.. or if there is a utility I can use to help in this endevor. Does anyone have any good links or suggestions to get a better idea of how to do this as accurately as possible?

Thanks
Crow

 

[Natalie]

Not sure if this will help, but there are 2 sp's I find invaluable:

sp_mstablespace [tablename]
and
sp_spaceused

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_sa-sz_0kro.asp

The sp_mstablespace is undocumented, but if you search it in Google, you'll find a bunch of stuff.

Good luck!

Natalie