Solved

Perfmon to analyse Disk Behaviour on window server 2008

Posted on 2013-06-25
3
1,037 Views
Last Modified: 2013-07-08
Hello Experts,

We have one central SCCM Site server where we are facing an issue. The SMS_Inventory_Data_Loader of central SCCM Server unable to move the MIF Files to the database , It resulted in piling up the dataldr.box folder with huge *.MIF files.

I am not an SCCM Administrator , but when asked the administrator he said *.mif are inventory files which moved to database from dataldr.box location with the help of SMS_Inventory_Data_Loader .

As the data is not getting moved to the database , most of the inventories are not getting updated.

Hence we have opened the call with Microsoft regarding this issue and they have come up with an answer stating there are some disk issues in a server

Basically we are using one physical disk (G:) for SCCM and (F:) for SQL ,

The Technician analyzed the perfmon logs of physical disk and found the Disks needs to updated with latest drives and defragmentation has to performed.

Below is the analyses.

\PhysicalDisk(2 F:)\% Idle Time
        [Min: 0%, Max: 102.73%, Avg: 52.84%]
             - Disk is heavily utilized and may be a bottleneck.
             - Investigate Disk bytes/sec and individual process IO Data bytes/sec for high disk usage.

   \PhysicalDisk(2 F:)\Avg. Disk Queue Length
        [Min: 0, Max: 4,766.439, Avg: 17.676]
             - Generally up to 2 per spindle (Hard Disk Device) is acceptable.

   \PhysicalDisk(3 G:)\Split IO/Sec
        [Min: 0, Max: 5,114.549, Avg: 6.405]
             - Split IO operations make up 9.01% of Disk Transfers.
             - Avg should be extremely close to 0.000.
             - RAID may be too small/NTFS block too small.
             - Disk may have moderate to heavy fragmentation

Action Plan for disks
1.  Could you please involve vendor for the disk to check it? May be updating the drivers may help.
2.  There are lot of Split I/O for both F: disk and G: disk. I would recommend to defragment the disks


Also he was talking about Read Cache and write Cache , can some one tell me what are these all about.

Please let me know the above statement made by technician are vaild , since I have never taken or analysed perfmon logs.

Also  , Can someone let me know how to take the perfmon log and analyse it?

I want to be 100% before I carry out the "Action Plan for Disk" provided by the technician

Thanks,

-Prashant Girennavar.
0
Comment
Question by:Prashant Girennavar
  • 2
3 Comments
 
LVL 10

Expert Comment

by:Subhashish Laha
ID: 39274671
Yes, the Technician is correct. You should get your Physical HDDs checked by Vendor and defragment your partitions.

Split I/O should be zero or near to zero.

Split I/O: Shows the rate at which that I/O requests to the disk were split into multiple requests. A split I/O may result from requesting data in a size that is too large to fit into a single I/O or that the disk is fragmented on single-disk systems.

You can refer below articles to check and for explanations on disk perfmon counters.

http://msdn.microsoft.com/en-us/library/ms804035.aspx
http://technet.microsoft.com/en-us/library/cc938959.aspx
http://blogs.technet.com/b/cotw/archive/2009/03/18/analyzing-storage-performance.aspx

Read Cache and write Cache

http://sqlmag.com/sql-server/setting-readwrite-cache-different-types-workloads
0
 
LVL 10

Author Comment

by:Prashant Girennavar
ID: 39277188
Thanks for the explanation ,

Does this means if we defrag the both the disk , we should see some Spilt I/O sec avg value getting reduced?

Also he talks about some driver updates ,

Is he mentioning the BIOS/ RAID controller Drivers?

Thanks,

-Prashant Girennavar.
0
 
LVL 10

Accepted Solution

by:
Subhashish Laha earned 500 total points
ID: 39277533
Yes, after defrag - you should see some reduction in Spilt I/O.

Yes, you should update BIOS and RAID controller driver. Specially updating RAID controller driver is more important if available.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn about cloud computing and its benefits for small business owners.
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question