May 25, 2012 at 1:49 am
Hi Guys,
I monitor my SQL servers from SSRS reports that I wrote or collected from different places. What I can’t find is a way to monitor my servers’ memory usage i.e. total memory usage of each server (the whole OS). As I found all TSQL scripts and counters can tell you the memory consumption by SQL server not all application in that server. (If you looking for this or any other SQL performance counter just query sys.dm_os_performance_counters)
On the other hand I found some Powershell scripts that give me the answer but I don’t know how I can use these scripts in SSRS or more precisely how can I use Powershell as a data-source in SSRS?
Do you have any suggestion?
Many Thanks,
Amir
May 30, 2012 at 7:10 am
I use perfmon, Brent Ozar has an excellent artical on this http://www.brentozar.com/archive/2012/05/perfmon-your-sql-servers-vital-stats-video/, other than that if you have the budget Redgate and Quest have some excelllent tools for this or you can use your system admin tools such as System Center or Solarwinds.
May 30, 2012 at 10:13 pm
Thanks for your reply and introducing some useful tools.
But my question is something else, I am looking for a way to capture my servers RAM (total used and free) and use this data in my SSRS reports.
I can find this info by running a powershell script like the attached one, what I am wondering is a way to use result of powershell scripts directly in SSRS as a datasource. Otherwise another approach could be saving result of Powershell in a table and using that table in SSRS.
Thanks
Amir
May 30, 2012 at 11:08 pm
Using a WMI query may be able to get you that query, not my thing but a quick google may help.
May 31, 2012 at 4:33 am
Using a WMI query may be able to get you that query, not my thing but a quick google may help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply