Internal documentation writing/performance analysis/documenting database structure

[analyst]

Hello everybody.

1. At this moment i am writing some sort of internal documentation, documenting all aspects of main product of our company and i have to write some sections on performance analysis.

The problem is that i have to go deep into low level side of the product operation ( like number of disk i/os per second et cetera). Does anybody know a tool for collecting information like this?

2. I have also another section on the database structure description. I need to get a diagram for links between tables. ( approx 120 tables in the database). The Server Explorer of the Visual Studio .Net has this function of creating diagrams, but has none for exporting them into some user-friendly format. Does anybody know any tool which will create the diagram and export it at least in some picture format? The database is MSDE.

Thanks in advance.

[Agregat]

1. disk i/o per sec - бери из тас манагера - количество хитов поделить на время работы процесса. Все эти данные можно получить в том числе программно.
2. Visio?

[Hrach_Techie]

http://www.bitmover.com/lmbench/man_lmbench.html
http://techpubs.sgi.com/library/tpl/cgi-bin/getdoc.cgi?coll=0650&db=bks&srch=&fname=/SGI_Developer/Guide_Comps/sgi_html/ch05.html
http://www.microsoft.com/resources/documentation/Windows/2000/server/reskit/en-us/Default.asp?url=/resources/documentation/Windows/2000/server/reskit/en-us/core/fneg_net_zbnu.asp

just my google search string :) the sequence of contents on a product specification document is important - let me know if you need pointers for this!

2) Visio or try the relational db modeling s/w http://www.dds-lite.com/main.html

HTH...

[analyst]

Thanks a lot, thats exactly what i needed.