3

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.
marc_s
9,0626 gold badges46 silver badges52 bronze badges
asked Jun 27, 2014 at 19:42

1 Answer 1

3

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.

answered Jun 27, 2014 at 21:10
4
  • This looks best, thanks so much.let me check.but do you have any suggestions for web Commented Jun 28, 2014 at 1:43
  • Powershell would be best choice querying perfmon data. Commented Jun 28, 2014 at 2:07
  • any pointers please Commented Jun 28, 2014 at 2:46
  • @TheGameiswar Something like collecting performance data for SQL Server via Powershell will get you started. Commented Jul 30, 2014 at 15:19

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.