Sitecore Health. Christopher Wojciech. netzkern AG. Sitecore User Group Conference 2015

Sitecore User Group Conference 2015

Sitecore Health

Christopher Wojciech

netzkern AG

christopher.wojciech@netzkern.de

1

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

% Increase in Page Abondonment

0%

10%

20%

30%

40%

2  sec  to  4

2  sec  to  6

2  sec  to  8

2  sec  to  10

%  Increase  in  Page  Abondonment

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Average Impact of one second delay in Response Time

-­‐16%

-­‐12%

-­‐8%

-­‐4%

0%

-­‐16%

-­‐7%

-­‐11%

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Why do I have to optimize my Site?

Optimized  Site

Not  optimized  Site

Bounce  Rate

13,38%

14,35%

Pages  per  Visit

15,64%

11,04%

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Located here: http://<host>/sitecore/admin/*

!! Please remove or protect on production environments !!

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

https://marketplace.sitecore.net/en/Modules/Cache_Tuner.aspx

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

https://marketplace.sitecore.net/en/

Modules/

Sitecore_Log_Analyzer.aspx

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Counters

Counting

Numbers

Statistical Data

Bild

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Sitecore Counters

Sitecore.Kernel.Counters

(Sitecore CMS Performance Counters)

Sitecore.Analytics.Counters

(Sitecore Analytics Counters)

Sitecore.Analytics.MongoDb

(Sitecore Analytics MongoDB

Counters)

Sitecore.HealthMonitor

(Sitecore  Memory  Usage  Counters)

Counters:

Examples:

Category

Name

Description

Sitecore.Caching Cache  Hits  /  sec Total  number  of  cache  hits  for  all  caches.

Sitecore.Caching Data  Cache  Clearings  /  sec Total  number  of  times  that  an  instance  of  a  data  cache  has  been  _cleared.

and 19 more ...

Sitecore.Data Data  |  Client  Data  Reads  /  sec The  total  number  of  client  data  values  that  have  been  read. Sitecore.Data Links  |  Fields  Examined  /  sec The  total  number  of  fields  that  have  been  scanned  for  links

and 17 more ...

Sitecore.Jobs Jobs  |  Jobs  Executed  /  sec The  total  number  of  jobs  that  have  been  executed. Sitecore.Jobs Pipelines  |  Pipelines  Aborted  /  sec The  total  number  of  times  a  pipeline  was  aborted.

And 9 more…

Sitecore.Presentation Rendering  |  Controls  Rendered  /  sec The  total  number  of  Sitecore  controls  rendered.

Sitecore.Presentation Rendering  |  Controls  Rendered  From  _{Cache  /  sec} The  total  number  of  Sitecore  controls  rendered  from  a  cache.

And 11 more

Sitecore.Security Access  Denied  /  sec The  total  number  of  access  requests  that  have  been  denied. Sitecore.Security Programmatic  Disabling  /  sec The  total  number  of  times  that  security  has  been  _{programmatically  disabled  (using  SecurityDisabler).}

And 18 more

Sitecore.System Logging  |  Errors  Logged  /  sec The  number  of  error  messages  that  have  been  sent  to  the  log. Sitecore.System Reflection  |  Types  Resolved  /  sec The  total  number  of  types  that  have  been  resolved  using  

reflection.

And 10 more…

Category

Name

Description

Sitecore.Analytics Collection  |  Total  Visits  /  sec The  total  number  of  visits  per  second  that  are  registered  by  the   system.

Sitecore.Analytics Collection  |  Unique  Visitors  /  sec The  number  of  unique  visitors  per  second.

Sitecore.Analytics Data  |  Last  Tracker  Flush  Time The  time  in  milliseconds  that  it  took  to  execute  the  last  request  _{to  write  data  to  the  database.}

Sitecore.Analytics Aggregation  |  Average  Write  Time  (ms) Average  time  it  takes  to  save  aggregated  data  to  the  reporting   database.

Sitecore.Analytics GeoIP  |  Cache  Size The  number  of  entries  in  the  GeoIP  cache.

Sitecore.Analytics Data  |  Aggregation  –  Visits  saved  to  _{reporting  database  /  sec} The  number  of  visits  saved  to  the  reporting  database  per  second. And  61  more....

Category

Name

Description

Sitecore.Analytics.MongoDb Reads  /  sec The  number  of  read  operations  from  MongoDB.

Sitecore.Analytics.MongoDb Writes  /  sec The  number  of  write  operations  from  MongoDB.

Sitecore.Analytics.MongoDb Documents  fetched  /  sec The  number  of  documents  fetched  from  MongoDB. And  8  more...

Sitecore.Automation

(Sitecore Engagement Automation

Counters)

Category

Name

Description

Process Private  Bytes The  total  amount  of  memory  that  a  process  has  allocated,   not  including  memory  shared  with  other  processes.

Process Virtual  Bytes The  current  size  of  the  virtual  address  space  that  the   process  is  using.

Process Page  File  Bytes The  current  amount  of  virtual  memory,  in  bytes,  that  this   process  has  reserved  for  use  in  the  paging  files.

.net  CLR  Memory #  Bytes  in  all  Heaps This  counter  indicates  the  current  memory  allocated  in  _{bytes  on  the  garbage  collection  heaps.}

.net  CLR  Memory Current  Assemblies The  number  of  assemblies  that  are  loaded  in  the  process. And  other  10...  

Category

Name

Description

Sitecore.Automation State  Evaluations  –  Page  Events  /  sec The  number  of  automation  condition  evaluations  per   second  that  are  triggered  by  page  events.

Sitecore.Automation Aggregation  |  Average  Automation  _{Aggregation  Pipeline  Time  /  sec} The  average  time  in  milliseconds  that  it  takes  to  run  the  _{automation  aggregation  pipeline}

Sitecore.Automation Aggregation  |  Transition  Aggregation  _{Errors  /  sec} The  number  of  errors  (exceptions)  occured  during  _{aggregation  of  state  transitions.}

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Some settings,…

• The IIS AppPool Identity needs the correct permissions 


via group assignement

• Setting of Counters.Enabled set to true

• Setting of Counters.InstanceName (only if more than one instance on a server)

• Setting of the HealthMonitorInterval

• Setting of Sitecore.Tasks.CounterDumpAgent

Caution: Difference between Counters for Sitecore 7 and for Sitecore 8!

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Key Counters

Memory  

• Available  Bytes  

• Committed  Bytes    

Processor    

• %  Processor  Time

Physical  Disk  

• %  Disk  Time  

• Avg.  Disk  Queue  Length  

Network  Interface  

• Bytes  Total/sec  

• Current  Bandwidth  

• Output  Queue  Length  

System  

• Processor  Queue  

Length    

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Use performance counters to check warning signs

• Memory: Committed Bytes is creeping up long term

• Processor: % Processor Time is above 75% long term and System: Processor Queue Length is above 10

• Physical Disk: % Disk Time is above 50% long term and Avg. Disk Queue Length is above 2

• Network Interface: Bytes Total/sec shows utilization is above 25% and Output Queue Length is above

2

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Key Sitecore Counters

Cache  

• Cache  Hits  

• Cache  Clearings  

• Cache  Misses  

Data  

• Data  Physical  Reads  

• Data  Physical  Writes

Process  

• Private  bytes  

• Virtual  bytes  

• Page  File  bytes  

• IO  Data  Operations/sec  

• IO  Other  Operations  

• %  Processor  Time

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Too much data

Too much possibilities

Too much of all

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Alternative EKL

Main  storage  for  log  files  

Automatic  Scaling  

Visualization  of  structured  documents  

Flexible  interface    

Completely  customizeable  

Logfile  parser    

Transforms  logfiles  into  

structured  documents.  

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Automatic monitoring within Sitecore

Completely customizeable

Generation of Apdex Index value for the whole environment

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Quick wins

Fast

Achievement

Winning

Bild

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

SQL: Check SQL Server Index Fragmentation Level

1.

Dramatic increase in CPU usage.

2.

Performance degradation on queries.

3.

Performance degradation on database writes.

4. Dropped connections to the database server.

5.

Slow performance of renderings.

6. Slow performance of the Sitecore client tools — Desktop,

Content Editor, and so on

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

4. Auto Shrink Property Set To False

SQL Settings: Database Properties

3. Auto Close Property Set To False

1. Compatibility Level Set To SQL Server 2008 (100)

Inability to run scripts to improve performance

Longer times required connecting to the database.

Performance degradation.

2. Recovery Model Set to Simple

Performance degradation during recovery intervals

There are 4 main settings to improve performance:

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

IIS Settings: HTTP Response Headers

Symptoms:

1. Constant high load times for requested pages.

2. Poor performance.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

IIS Settings: Content Compression

Symptoms:

1. Constant high load times for requested pages.

2. Poor performance.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Sitecore Cache Settings:Tuning Sitecore Caches

Symptoms ·

Limited amount of memory to caches. ·

Frequent eviction of caches due to limited memory.

Slow page rendering performance

Sitecore Recommendations:·

If you have a 64-bit system, Sitecore recommends to

disable cache limit.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Sitecore Cache Settings:Tuning Sitecore Caches

Environment  

Target  Cache

Value

Content  Delivery  Only

Web

Prefetch

200  MB

Web

Data

200  MB

Web

Item

200  MB

Output  (per  site)

html

100  MB

CMS  Only

Master

Prefetch

200  MB

Master

Data

200  MB

Master

Item

200  MB

CMS  and  Content  Delivery  on  same  server  (master  and  web  databases)

Master

Prefetch

200  MB

Master

Data

200  MB

Environment  /  Target

Master

Item

200  MB

Web

Prefetch

150  MB

Web

Data

150  MB

Web

Item

150  MB

Output  (per  site)

html

100  MB

CMS  and  Content  Deliver  on  same  server  (Live  mode)

Master

Prefetch

300  MB

Master

Data

300  MB

Master

Item

300  MB

Output  (per  site)

html

100  MB

Symptoms ·

Poor solution performance. ·

Excessive server load.

Decreased system capacity

Sitecore Recommendations:

Set initial values:

Tune cache values:

Sitecore recommends that the Sitecore database

cache size(s) is between 70% and 80% of their

MaxSize, without seeing constant fluctuations to the

Delta value.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Cacheable — The Cacheable property defines whether or not the

presentation component should be cached, regardless of what the

VaryBy properties are set to.

Sitecore Cache Settings:Configuring Output Cache

VaryByData — Set to true for components that generate different

output when used with different data sources.

VaryByDevice — Set to true for components that generate

different output when used with different devices

VaryByLogin — Set to true for components that generate different

output for an authenticated vs. an unauthenticated user. Note,

the layout engine treats all anonymous users as a single

authenticated user. o

VaryByQueryString — Set to true for components that generate a

different output when different query string parameters are

passed in.

VaryByUser — Set to true for components that generate different

output for different users. Note, to avoid excessive memory usage

only use VaryByUser on solutions with a relatively small number

of users.

Sitecore allows developers to define output cache settings in three places:

VaryByParm — Set to true for components that generate a

different output when different rendering parameters are passed

in.

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Symptoms ·

Slow performance during publishing. ·

Slow performance during indexing.

Sitecore Settings: Check Database Cleanup Agents

Sitecore Recommendations:·

Sitecore recommends that the scheduling frequency

be enabled by setting it to a value greater than

00:00:00. ·The default value for the frequency =

00:05:00

Cleanup agents for the History, PublishQueue, and

EvenQueue be configured to have an interval greater

than 00:00:00. The default value for the frequency =

00:05:00 and the default for the intervals =

Unsichtbare Technologie. Sichtbare Kreativität. netzkern.

Sitecore Settings: Disable Showing Number of Locked Items

Symptoms ·

Dramatic performance degradation during loading the Experience Manager. ·

Sitecore Recommendations:·

Set WebEdit.ShowNumberOfLockedItemsOnButton

setting to false!

Sitecore User Group Conference 2015

Thank you