I need to collect the following information. Does anyone
know where do I go to get these information? It doesn't
look like is in the SQL profiler.

Processor - % Processor Time - _Total

Process - Virtual Bytes - msmdsrv

Process - Working Set - msmdsrv

Process - Page Faults/sec - msmdsrv

Network Interface - Current Bandwidth - <NIC 1>

Network Interface - Current Bandwidth - <NIC 2 if used>

Network Interface - Bytes Total/sec - <NIC 1>

Network Interface - Bytes Total/sec - <NIC 2 if used>

System - Processor Queue Length - N/A

Analysis Server:Last Query - Query num - N/A

Analysis Server:Last Query - Rows Read - N/A

Analysis Server:Last Query - Time (ms) - N/A

Analysis Server: Query - Avg time/query - N/A

Analysis Server: Query - Bytes Sent/sec - N/A

Analysis Server: Query - Current process thread queue
length - N/A

Analysis Server: Query - Current process thread pool - N/A

Analysis Server: Query - Current process threads active -
N/A

Analysis Server: Query - Current queries - N/A

Analysis Server: Query - Current threads - N/A

Analysis Server: Query - Current worker thread pool - N/A

Analysis Server: Query - Current worker threads active -
N/A

Analysis Server: Query - Total bytes sent - N/A

Analysis Server: Query - Total queries requested - N/A

Analysis Server: Query - Total rows sent - N/A

Analysis Server: Agg Cache - Evictions/sec - N/A

Those are perfmon counters.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Talia" <anonymous (AT) discussions (DOT) microsoft.com> wrote