{"id":1770,"date":"2013-06-20T08:14:46","date_gmt":"2013-06-20T08:14:46","guid":{"rendered":"http:\/\/www.tsls.co.uk\/?p=1770"},"modified":"2013-06-20T08:14:46","modified_gmt":"2013-06-20T08:14:46","slug":"sharepoint-performance-testing-counters-iis-logs-load-senario","status":"publish","type":"post","link":"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/","title":{"rendered":"SharePoint Performance testing (Counters, IIS Logs, Load, Senario)"},"content":{"rendered":"
\n

This blog contains information on how to performance test SharePoint 20102013, to benchmark the load the SharePoint farm is under.<\/p>\n

<\/p>\n

Web Performance load testing:<\/h2>\n

These tools are used to create web test scenarios which then can be load tested with virtual users, usual these tools will provide information such as response times, failed pages, hits, bandwidth and user count.<\/p>\n\n\n\n\n
Web Performance Pro http:\/\/www.webperformance.com\/<\/a><\/td>\n\"\"<\/a><\/td>\n<\/tr>\n
Visual Studio Ultimate with MSDN http:\/\/www.microsoft.com\/visualstudio\/eng\/products\/visual-studio-ultimate-2012<\/a><\/td>\n\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Web Log Analysing Tools<\/h2>\n

These are used to review the IIS web logs, providing information such as page views, hits, connected users, location of users and RPS<\/p>\n\n\n\n\n
IIS Log Parser 2.2 http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=24659<\/a>This is a command tool which extracts information into CSV files for\u00a0 manipulation in excel.<\/p>\n

 <\/p>\n

This tool will provide RPS results and Page Views<\/p>\n

 <\/p>\n

Usage with SharePoint http:\/\/www.microsoft.com\/downloads\/details.aspx?familyid=f159af68-c3a3-413c-a3f7-2e0be6d5532e&displaylang=en&tm<\/a><\/td>\n

\"\"<\/a><\/td>\n<\/tr>\n
AWSTATS http:\/\/awstats.sourceforge.net\/<\/a>This is a web based tool <\/p>\n

This tool will only provide Hourly page view and hits rather than RPS\u00a0 and page viewsec<\/td>\n

\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Performance Monitor<\/h2>\n

Performance monitor is used to capture the performance state of the system whilst the performance tests are running, this allows us to understand what load the servers are under and helps us to understand the limits of the environment and when the farm should be increased.<\/p>\n\n\n\n
Counters to capture ever 1 secondEach Web SharePoint ServerASP.NET\u00a0 Applications(__Total__)Requests\/Sec<\/p>\n

Processor(_Total)%\u00a0 Processor Time<\/p>\n

SharePoint\u00a0 Foundation(_Total)Current Page Requests<\/p>\n

Web\u00a0 Service(_Total)Current Anonymous Users<\/p>\n

Web\u00a0 Service(_Total)Current Connections<\/p>\n

MemoryAvailable\u00a0\u00a0 MBytes<\/p>\n

Memory%\u00a0 Committed Bytes In Use<\/p>\n

Web\u00a0 Service(_Total)ISAPI Extension Requests\/sec<\/p>\n

Web\u00a0 Service(_Total)Current ISAPI Extension Requests<\/p>\n

SharePoint\u00a0 Publishing Cache(_Total)Publishing cache hit ratio<\/p>\n

SharePoint\u00a0 Publishing Cache(_Total)Total number of cache compactions<\/p>\n

 <\/p>\n

Each App SharePoint Server<\/p>\n

Processor(_Total)%\u00a0 Processor Time<\/p>\n

MemoryAvailable\u00a0\u00a0 MBytes<\/p>\n

Memory%\u00a0 Committed Bytes In Use<\/p>\n

Search\u00a0 Gatherer – SearchPointServerSearchDocuments\u00a0 Filtered<\/p>\n

Search\u00a0 Gatherer – SearchPointServerSearchDocuments\u00a0 Filtered Rate<\/p>\n

Search\u00a0 Gatherer – SearchPointServerSearchPerformance\u00a0 Level<\/p>\n

Search\u00a0 Gatherer – SearchPointServerSearchThreads\u00a0 Accessing Network<\/p>\n

 <\/p>\n

SQL Server:<\/p>\n

Processor%Processor\u00a0 time_total<\/p>\n

MemoryAvailable\u00a0\u00a0 MBytes<\/p>\n

Memory%\u00a0 Committed Bytes In Use<\/p>\n

PhysicalDiskDisk Read\/sec_Total<\/p>\n

PhysicalDiskDisk Write\/sec_Total<\/p>\n

 <\/td>\n

\"\"<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Results<\/h2>\n

Using the information gathered from the tools above we can then gather the test information and align to the optimal performance zones into Green and Red zone limits.<\/p>\n

Typically you would want to fall within the Green Zone and only the Red Zone when the traffic generated is unexpected<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/td>\n<\/td>\nGreen Zone<\/span><\/td>\nRed Zone<\/span><\/td>\n<\/tr>\n
Web Server<\/td>\n<\/td>\nCPU <60% averagePage Response <1000ms for 75%<\/td>\nCPU <80%Page Response <3000ms for 75%No 500 errors<\/p>\n

0.1% page failure rate<\/td>\n<\/tr>\n

Concurrent Users(test tool)<\/td>\nNumber of concurrent users running a scenario test<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Processor%Processor time_total(performance monitor)<\/td>\nThe % Processor Time counter measures the percentage of elapsed time\u00a0 that the processor spends to execute a non-Idle thread<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Memory AvailableMemoryAvailable Mbytes(Performance Monitor)<\/p>\n

 <\/p>\n

 <\/td>\n

Available MBytes counter to measure the\u00a0 amount of physical memory in MB immediately available for allocation to a\u00a0 process or for system use<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Page Response Times(test tool)<\/td>\nTime in milliseconds to return a page<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Request Per Second(test tool and IIS logs)<\/td>\nNumber of requests the farm is performing in a second<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Page views Per Second(test tool)<\/td>\nNumber of pages return in a second<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Database Server<\/td>\n<\/td>\nCPU <50%<\/td>\nCPU <80%<\/td>\n<\/tr>\n
Processor%Processor time_total(performance monitor) <\/td>\nThe % Processor Time counter measures the percentage of elapsed time\u00a0 that the processor spends to execute a non-Idle thread<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
PhysicalDiskDisk Read\/sec_Total(Performance monitor)<\/td>\nNumber of disk reads per second<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
PhysicalDiskDisk Write\/sec_Total(performance monitor)<\/td>\nNumber of disk writes per second<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Physical Disk IOPS<\/td>\nAdding both readwrite per second = IOPS<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Analysis Tools<\/h1>\n

PAL Download: http:\/\/pal.codeplex.com\/releases\/view\/51623<\/a>, Documentation: http:\/\/pal.codeplex.com\/<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

This blog contains information on how to performance test SharePoint 20102013, to benchmark the load the SharePoint farm is under.<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[21],"tags":[1531,1831],"class_list":["post-1770","post","type-post","status-publish","format-standard","hentry","category-microsoft","tag-performance","tag-sharepoint"],"jetpack_publicize_connections":[],"yoast_head":"\r\nSharePoint Performance testing (Counters, IIS Logs, Load, Senario) - TSLS - Luke Smith<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_GB\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SharePoint Performance testing (Counters, IIS Logs, Load, Senario) - TSLS - Luke Smith\" \/>\r\n<meta property=\"og:description\" content=\"This blog contains information on how to performance test SharePoint 20102013, to benchmark the load the SharePoint farm is under.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/\" \/>\r\n<meta property=\"og:site_name\" content=\"TSLS - Luke Smith\" \/>\r\n<meta property=\"article:published_time\" content=\"2013-06-20T08:14:46+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/www.tsls.co.uk\/wp-content\/uploads\/2013\/06\/image002-300x135.png\" \/>\r\n<meta name=\"author\" content=\"Luke Smith\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Luke Smith\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/\",\"url\":\"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/\",\"name\":\"SharePoint Performance testing (Counters, IIS Logs, Load, Senario) - TSLS - Luke Smith\",\"isPartOf\":{\"@id\":\"https:\/\/www.tsls.co.uk\/#website\"},\"datePublished\":\"2013-06-20T08:14:46+00:00\",\"dateModified\":\"2013-06-20T08:14:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tsls.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SharePoint Performance testing (Counters, IIS Logs, Load, Senario)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tsls.co.uk\/#website\",\"url\":\"https:\/\/www.tsls.co.uk\/\",\"name\":\"TSLS - Luke Smith\",\"description\":\"- Knowledge - Thoughts - Microsoft -\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tsls.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7\",\"name\":\"Luke Smith\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.tsls.co.uk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g\",\"caption\":\"Luke Smith\"},\"description\":\"I\u2019ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I\u2019ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft\u2019s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint\",\"sameAs\":[\"http:\/\/www.tsls.co.uk\"],\"url\":\"https:\/\/www.tsls.co.uk\/index.php\/author\/luke\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SharePoint Performance testing (Counters, IIS Logs, Load, Senario) - TSLS - Luke Smith","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/","og_locale":"en_GB","og_type":"article","og_title":"SharePoint Performance testing (Counters, IIS Logs, Load, Senario) - TSLS - Luke Smith","og_description":"This blog contains information on how to performance test SharePoint 20102013, to benchmark the load the SharePoint farm is under.","og_url":"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/","og_site_name":"TSLS - Luke Smith","article_published_time":"2013-06-20T08:14:46+00:00","og_image":[{"url":"http:\/\/www.tsls.co.uk\/wp-content\/uploads\/2013\/06\/image002-300x135.png"}],"author":"Luke Smith","twitter_misc":{"Written by":"Luke Smith","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/","url":"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/","name":"SharePoint Performance testing (Counters, IIS Logs, Load, Senario) - TSLS - Luke Smith","isPartOf":{"@id":"https:\/\/www.tsls.co.uk\/#website"},"datePublished":"2013-06-20T08:14:46+00:00","dateModified":"2013-06-20T08:14:46+00:00","author":{"@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7"},"breadcrumb":{"@id":"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tsls.co.uk\/index.php\/2013\/06\/20\/sharepoint-performance-testing-counters-iis-logs-load-senario\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tsls.co.uk\/"},{"@type":"ListItem","position":2,"name":"SharePoint Performance testing (Counters, IIS Logs, Load, Senario)"}]},{"@type":"WebSite","@id":"https:\/\/www.tsls.co.uk\/#website","url":"https:\/\/www.tsls.co.uk\/","name":"TSLS - Luke Smith","description":"- Knowledge - Thoughts - Microsoft -","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tsls.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/e4d7dac4fe1b3f8df31f3857bb3ebda7","name":"Luke Smith","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.tsls.co.uk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/29abc50f07a4ebe68cb4f31981884f89b2157d7e4ed63b09631d40c0717faa94?s=96&d=mm&r=g","caption":"Luke Smith"},"description":"I\u2019ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I\u2019ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft\u2019s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint","sameAs":["http:\/\/www.tsls.co.uk"],"url":"https:\/\/www.tsls.co.uk\/index.php\/author\/luke\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2gf1k-sy","_links":{"self":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/1770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=1770"}],"version-history":[{"count":0,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/posts\/1770\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=1770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/categories?post=1770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tsls.co.uk\/index.php\/wp-json\/wp\/v2\/tags?post=1770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}