December 28, 2010 at 10:29 pm
How to view the below mentioned parameters in sql BOX
Memory
Availbale Mbytes
cach bytes
Pages/Sec
pool paged resident bytes
Physical disk
% disk read time
% disk write time
December 29, 2010 at 2:05 am
You can use Performance Monitor utility to get this information. Run --> perfmon.exe
Here are the screenshots on how to add counters in Performance Monitor.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
December 29, 2010 at 3:39 am
If you meant , how to do it using command from SQl box, then you may use:
xp_cmdshell 'typeperf "\Memory\Available bytes" "\processor(_total)\% processor time"'
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
December 29, 2010 at 7:32 am
If you want to capture performance counters in TSQL, instead of using extended calls, which can be very problematic, and require different security settings that might not be all that attractive, since you're 2005 (or above) use DMOs:
SELECT * FROM sys.dm_os_performance_counters AS dopc
You won't get every possible perfmon counter, but you can see quite a few of them, quickly and easily.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply