Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2006-10-03 : 06:25:37
|
| Hi, Whats the best way to use T-SQL to query how many CPU the server is using? and the server memory etc? just like the page shows up on the server property using EM? Or need to use DMO for that? (Guess this question goes to SQL 2000 and 2005).Thanks, |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-03 : 06:35:47
|
| Nah, I think master..xp_msver will do.Peter LarssonHelsingborg, Sweden |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-03 : 08:47:08
|
| Do you want to know the maximum it's set to be allowed to use, or the actual amount of CPU and memory usage during operation?-------Moo. :) |
|
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-10-04 : 02:21:30
|
| both I guess, the max and what its set, for what it set to use (for memory) I can get that from sp_configure, but not too sure about CPUI just found out the smo can do it, not sure if dmo can do the same.but with TSQL will be much easier...:) |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-10-04 : 04:02:09
|
| Windows Performance monitor in control panel will give you real time stats.-------Moo. :) |
|
|
|
|
|
|
SQL Processors