Displaying posts categorized under

WMI

SQL Server connection in WMI Script

SQL Server connection in WMI Script. VB Script provides composition of WMI and SQL Server. You can connect SQL Server and store WMI informations in SQL Server. Before reading this blog you already know that WMI is also works like central communication machine for all network servers. To know more read http://nirav.extreme-advice.com/2013/05/15/get-disk-space-usage-from-central-server-with-wmi/. I have created one [...]

Monitor performance counter with WMI and SQL Server

Monitor performance counter with WMI and SQL Server. WMI is very important to use as central monitoring task. I have created performance monitoring which checks Disk Queue Legth, Disk Read/Sec, Disk Write/Sec, CPU Usage, Memory Usage, Disk Read Bytes/Sec, Disk Write Bytes/Sec, ASP Request/Sec. Create a table “PerformanceCounter” to store all information. Open Notepad and save [...]

Get List of Stopped SQL Services from central server with WMI

Get List of Stopped SQL Services from central server with WMI. As a DBA we have to monitor many things. To monitor all SQL Server Serives wotking properly works fine we have to check status of services periodically. We can do that it manually or automatically, Manually – By using Services.msc, Automatically – By using [...]

Get Disk space usage from central server with WMI

Get Disk space usage from central server with WMI. As a DBA job we have to check server health regularly. sometime that happens when you are working on multiple servers and its very difficult to monitor health of all servers. I faced the same issue last week. My application abnormally going down and i am [...]

SSIS Package to get Disk Space Info with WMI and Script Task

SSIS Package to get Disk Space Info with WMI and Script Task. In Previous blog i have created SSIS Package to get Disk Space Info with WMI.(Link: http://nirav.extreme-advice.com/2013/02/20/ssis-package-to-get-disk-space-info-with-wmi/) That was a simple way to gather disk space information with importing data in CSV file and exporting data in database. I have used same table in [...]

SSIS Package to get Disk Space Info with WMI

SSIS Package to get Disk Space Info with WMI. I have created package that gives Disk Space info using WMI Data Reader Task. You need minor knowledge on WMI Query and WMI Class, here i have used “Win32_LogicalDisk” WMI class. This package checks disk info for logical disk of your machine and stores value to [...]