Administrating SQL

Folks,
I am looking a way to better manage my SQL Server environment. Here are my
requirements
1 I need to know used, free and availabe space
2 Utilization of memory and other SQL Server 2000 related resources whether
on weekly average (for example) it's good
3 System spec that running the server.
I can do some kind of scripting to dump everything on one webpage that list
the above info but i would like to find out whether there is already any tool
availabe to ease my administration.
Protype of the display should be something like this
Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max 300)
A 80.760 1G(Good) 25G out of 50G
235 (good)
Thank you
rupart
Start with
http://www.sql-server-performance.com
"rupart" <rupart@.discussions.microsoft.com> wrote in message
news:D717B8B5-26B0-4320-BC33-9075FF689AA6@.microsoft.com...
> Folks,
> I am looking a way to better manage my SQL Server environment. Here are my
> requirements
> 1 I need to know used, free and availabe space
> 2 Utilization of memory and other SQL Server 2000 related resources
whether
> on weekly average (for example) it's good
> 3 System spec that running the server.
> I can do some kind of scripting to dump everything on one webpage that
list
> the above info but i would like to find out whether there is already any
tool
> availabe to ease my administration.
> Protype of the display should be something like this
> Srv Name Ver RAM(Threshold 2G) Diskspace(threshold 30%) Total Hits(max
300)
> A 80.760 1G(Good) 25G out of 50G
> 235 (good)
> Thank you