THE BEST SQL SERVER PERFORMANCE MONITOR COUNTERS TO ANALYZE
– These are listed OBJECT first, then COUNTER
– Memory – Available MBytes
– Paging File – % Usage
– Physical Disk – Avg. Disk sec/Read
– Physical Disk – Avg. Disk sec/Write
– Physical Disk – Disk Reads/sec
– Physical Disk – Disk Writes/sec
– Processor – % Processor Time
– SQLServer: General Statistics – User Connections
– SQLServer: Memory Manager – Memory Grants Pending
– SQLServer: SQL Statistics – Batch Requests/sec
– SQLServer: SQL Statistics – Compilations/sec
– SQLServer: SQL Statistics – Recompilations/sec
– System – Processor Queue Length
Pantelis Apostolidis is a Sr. Specialist, Azure at Microsoft and a former Microsoft Azure MVP. For the last 20 years, Pantelis has been involved to major cloud projects in Greece and abroad, helping companies to adopt and deploy cloud technologies, driving business value. He is entitled to a lot of Microsoft Expert Certifications, demonstrating his proven experience in delivering high quality solutions. He is an author, blogger and he is acting as a spokesperson for conferences, workshops and webinars. He is also an active member of several communities as a moderator in azureheads.gr and autoexec.gr. Follow him on Twitter @papostolidis.
