Skip to content

Instantly share code, notes, and snippets.

View martinrayenglish's full-sized avatar

Martin English martinrayenglish

View GitHub Profile
@martinrayenglish
martinrayenglish / ThreadPoolSizeMonitor.cs
Created September 20, 2020 12:45
Sitecore Thread Pool Size Monitor
using Sitecore.Abstractions;
using Sitecore.Framework.Conditions;
using System;
using System.Threading;
namespace Sitecore.Analytics
{
internal class ThreadPoolSizeMonitor : IThreadPoolSizeMonitor, IDisposable
{
private readonly int _accelerationRate;
<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:role="http://www.sitecore.net/xmlconfig/role/" >
<sitecore>
<httpRequestBegin role:require="ContentDelivery">
<processor type="Sitecore.Pipelines.HttpRequest.BeginDiagnostics, Sitecore.Kernel" >
<patch:delete />
</processor>
</httpRequestBegin>
</pipelines>
</sitecore>
using System.Collections.Generic;
using System.Threading;
using System.Threading.Tasks;
using Sitecore.Framework.Conditions;
using Sitecore.Xdb.Collection.Indexing;
using Sitecore.Xdb.Collection.Model;
namespace Test.SCExtensions.Xdb.Collection.Search.Solr
{
using System.Collections.Generic;
using System.Threading.Tasks;
using Sitecore.Xdb.Collection;
using Sitecore.Xdb.Collection.Indexing;
using Sitecore.Xdb.Collection.Model;
namespace Test.SCExtensions.Xdb.Collection.Search.Solr
{
public sealed class IndexRebuilderFilterDecorator : IIndexRebuilder
<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/" xmlns:role="http://www.sitecore.net/xmlconfig/role/">
<sitecore role:require="Standalone or ContentDelivery or ContentManagement">
<dataAdapterManager>
<providers>
<add name="xconnect" type="MyProject.Analytics.XConnect.DataAccess.CustomXConnectDataAdapterProvider, MyProject.Analytics">
<FilteringEnabled>true</FilteringEnabled>
<IncludeGoals>true</IncludeGoals>
<filterEvents hint="raw:AddFilterEvents" patch:source="Sitecore.ContentTesting.config">
<PageEventDefinitionId Id="{1AD8EBEB-24E3-46F1-9EDD-2295C5219C5E}" description="Email Opened"/>
@martinrayenglish
martinrayenglish / CustomXConnectDataAdapterProvider.cs
Created June 21, 2020 12:10
Sitecore xConnect XConnectDataAdapterProvider extension to only goals and other events specified in configuration
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using System.Xml;
using Sitecore.Analytics.Model;
using Sitecore.Analytics.XConnect.DataAccess;
using Sitecore.Framework.Conditions;
using Sitecore.Xml;
<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:role="http://www.sitecore.net/xmlconfig/role/" xmlns:search="http://www.sitecore.net/xmlconfig/search/">
<sitecore role:require="Standalone or ContentDelivery or ContentManagement" search:require="azure">
<contentSearch>
<configuration type="Sitecore.ContentSearch.ContentSearchConfiguration, Sitecore.ContentSearch">
<indexes hint="list:AddIndex">
<index id="test_locations_web_index" type="Sitecore.ContentSearch.Azure.CloudSearchProviderIndex, Sitecore.ContentSearch.Azure">
<param desc="name">$(id)</param>
<param desc="connectionStringName">cloud.search</param>
<param desc="totalParallelServices">5</param>
<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/" xmlns:search="http://www.sitecore.net/xmlconfig/search/" xmlns:role="http://www.sitecore.net/xmlconfig/role/">
<sitecore role:require="Standalone or ContentDelivery or ContentManagement" search:require="azure">
<contentSearch>
<indexConfigurations>
<locationCloudIndexConfiguration ref="contentSearch/indexConfigurations/defaultCloudIndexConfiguration">
<documentOptions type="Sitecore.ContentSearch.DocumentBuilderOptions, Sitecore.ContentSearch">
<indexAllFields>false</indexAllFields>
<include hint="list:AddIncludedTemplate">
<locationTemplateId>{53720ED3-C9F1-494F-88D8-BF05609E79FB}</locationTemplateId>
@martinrayenglish
martinrayenglish / Sitecore xDB.postman_collection.json
Created June 7, 2020 13:02
Solr xDB Index Troubleshooting Postman Collection
{
"info": {
"_postman_id": "ac487bbf-4bc0-498c-9b16-034706b6fc19",
"name": "Sitecore xDB",
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
},
"item": [
{
"name": "xDB Contacts Count",
"request": {
@martinrayenglish
martinrayenglish / Sitecore.Support.312397.sql
Created August 17, 2019 13:23
Stored Procedure performance issues related to SQL when querying the Sitecore Reference Data database - Sitecore.Support.312397
ALTER PROCEDURE [xdb_refdata].[DeleteDefinitions]
(
@Keys [xdb_refdata].[DefinitionKeys] READONLY
)
WITH EXECUTE AS OWNER
AS
BEGIN
SET NOCOUNT ON;
DECLARE