Most significant perfmon counters for MS SQL server

Memory Available MBytes Memory Free System Page Table Entries Memory Pages/Sec Paging File %Usage Paging File %Usage Peak Processor Processor Time Process(sqlservr) % Privileged Time Process(sqlservr) % Processor Time PhysicalDisk Avg. Disk sec/Read PhysicalDisk Avg. Disk sec/Write SQLServer:Access Methods Forwarded Records/sec SQLServer:Access Methods FreeSpace Scans/sec SQLServer:Access Methods Full Scans/sec SQLServer:Access Methods Index Searches/sec SQLServer:Access Methods…

0

handling Persistent Reservation failures in Windows 2012 R2 and Windows 2012

Run Cluster Validation Wizard: https://technet.microsoft.com/library/jj134244#BKMK_RUN_TESTS   If you notice the following errors in the Cluster Validation Wizard output as following, please use the following remediation plan.   Physical Disk <DBReports>: PR reserve failed Physical Disk <DBReports>: ResHardDiskArbitrateInternal: PR Arbitration for disk Error Physical Disk <DBReports>: OnlineThread: Unable to arbitrate for the disk Physical Disk <DBReports>:…

2

Azure concepts – Update Domain vs Fault Domain in Availability Sets – simply explained

In Windows Azure a rack of computers is indeed identified as a fault domain. And the allocation of a fault domain is determined by Windows Azure at deployment time. A service owner can not control the allocation of a fault domain, however can programmatically find out which fault domain a service is running within.Windows Azure…

0