SQL 7 stats from ASP?

<i><b>Originally posted by : wk (skrecycle@rediffmail.com)</b></i><br />Do you know how can I get the current stats like the server resources, load, processor load etc. from my ASP script?<br />I need this info for my load balancing pages.<br /><br />thanx.<br />

<i><b>Originally posted by : (indigo@mail.gr)</b></i><br />There is a set of stored procedures you can use to get statistics on your sql server load..<br /><br />For example<br /><br />sp_who<br />sp_lock<br />sp_spaceused<br />sp_monitor<br /><br /><br />Check out the books online for more..<br /><br /><br />------------<br />wk at 3/14/2001 1:25:23 AM<br /><br />Do you know how can I get the current stats like the server resources, load, processor load etc. from my ASP script?<br />I need this info for my load balancing pages.<br /><br />thanx.<br />