Hi all - I have an sql2k server, and i would like to see the stats of a particular database on that server - is there a way to see the stats (pages, usage, size on disk...) for a database ???? I would like to display this information on a stats web page.. thanks tony
While Performance Monitor can provide some specific details on the stats of a database, in most cases, you will need to use the various system stored procedures and DBCC commands available to see them. Of course, Enterprise Manager also displays a few, but not in much detail. None of these tools allow you to directly see them via a web browser, unless you want to write your own code. Some of the system stored procedures and DBCC commands (but not a complete list, which you can find in books online) include: DBCC SQLPERF sp_help sp_spaceused sp_statistics etc. See the SQL Server Books Online for a complete list of the DBCC and system stored procedures. There are some third party tools that allow you to see some database stats via a web browser. Some of these are available from www.idisoft.com, www.netiq.com, www.precise.com, www.bmcsoftware.com, and others. ------------------ Brad M. McGehee Webmaster SQL-Server-Performance.Com
