current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite

For reporting purposes, I want to get SQL Server box CPU, memory, network (not SQL Server process alone) and show it in report. Do you have any idea how to pull this? My initial thoughts are run wmi queries through task scheduler to get the data every 15 minutes and insert into database table and use it in reports

My report format will be like below

Server name:
CPU usage
Memory usage
Network usage
Disk space usage:

My questions:

  1. can this be done in any,other way other than wmi/power shell
  2. I will also need to get web servers data
  3. will you be able to give one sample query for one server.
share|improve this question

1 Answer 1

up vote 2 down vote accepted

If you are running SQL Server 2008 and up, then you can use Performance Data Collector on SQL Server. This will get you all the metrics (and even more) that you need.

Below is from my TEST server :

enter image description here

If you want for webserver, then your best bet is to use Powershell. Even you can generate nice reports with charts out of your collection.

share|improve this answer
    
This looks best, thanks so much.let me check.but do you have any suggestions for web –  TheGameiswar Jun 28 at 1:43
    
Powershell would be best choice querying perfmon data. –  Kin Jun 28 at 2:07
    
any pointers please –  TheGameiswar Jun 28 at 2:46
    
@TheGameiswar Something like collecting performance data for SQL Server via Powershell will get you started. –  Kin Jul 30 at 15:19
    
Thank you kin for your help –  TheGameiswar Jul 30 at 15:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.